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.

  • 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

      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

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