Generate reports from MYOB AccountRight
hi there, We use Microsoft's Power BI to generate reports but as Microsoft have advised that they have EOL the content pack integration to Power BI Online as of 1 September 2019, we cannot use Po...
Forum Discussion
Thank you for the reply.
Yes, we looked at this option of using the myob API to download data from myob table into sql server tables and then generate reports in using Power BI (power BI connects to sql server).
As we are already using the myob API to export data, we know that its very slow at times. So downloading data and the need to create myob tables in sql server is a time consuming process and the data is not up to date.
We were looking at the below option where u use this addon to access myob tables directly in sql server. It paid though unlike myob API.
https://accountingaddons.com.au/odbclink/
Wondering if u have used this addon or have more information on it. Wouldn't this be better than myob API ?
I would like to know your thoughts on this.
Hi PujaParekh , the ODBCLink app uses the API to access the AccountRight file, and then converts the endpoints into tables that look like the ODBC tables in v19. So it is likely to operate at the same speed or slower than native API, given that there is a conversion/transformation process included.
hi mike,
Before when myob supported ODBC driver, we accessed myob tables in Microsoft Access. It was quite fast. So I am assuming this addon be similar.
When using myob API to download data, i will have to manually create the myob tables in sql server and every time i have to run reports, I will need to run the api first to download latest data. Wouldn't this take long ?
sorry but I am just trying to figure out the best option here.
Hi PujaParekh , the ODBC and API access methods are completely different, so don't make any assumptions about performance in general, or particular apps. The vendor can probably comment further.
We do the same, ie we use a local relational database to store API extracts for further reporting, and we find the performance of the extracts is generally adequate for most users' requirements. Occasionally we switch to reporting off the live file, either because performance is not an issue, or for functional reasons.
Note that extracting data from cloud files requires you to deal with oauth2 credentials and processes including 2FA, whereas extracting data from files held locally or on a network does not.
Hi PujaParekh
I agree with Mike_James on the how to improve performance of retrieving MYOB data. The best way we have now is to pull all data from MYOB api to SQL database tables.
The speed is faster if you use data file locally. Secondly, you may need reduce the frequency of retrieving large tables like Journal,
Regards,
