Forum Discussion

RHussler's avatar
3 years ago

AccountRight Database Schema

Wondering if anyone can assist.

 

Does anyone have the DB schema for Acountright? I have searched teh blog for the database schema but can only an MYOB ODBC table access guide, which does not have the same table structure. 

 

I need these to develop PowerBi Reports and am trying to make sense of them atm. I am using a third party oData connector, which is working well.

3 Replies

Replies have been turned off for this discussion
  • Does anyone know how I can identify the specific fields / information that is exported into the reports that can be generated in MYOB? I want to create something similar so it is accessabile in PowerBi.

  • gavin12345's avatar
    gavin12345
    Ultimate User
    3 years ago

    Hi RHussler 

     

    How are you accessing the database? If using the API then you need to use the exposed API Endpoints. Suggest you locate the Development board - I can't find the link at present.

     

    Regards

    Gavin

  • RHussler's avatar
    RHussler
    3 years ago

    Hi Gavin, I am accessing the DB through oData. Thanks for the tip. I'll look into the developers forum.