AccountRight Database Schema

RHussler · August 2022

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.

RHussler · August 2022

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 · August 2022

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

(gavinw222@gmail.com)

RHussler · September 2022

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