Query the MYOB Business API using regular SQL

Not directly, no. But SyncHub's ERD model, combined with the real-time* sync from MYOB Business, means that it is essentially the same as querying directly.

No. Our solution is cloud-hosted, meaning no installs are required on your own computers. Furthermore, because it is cloud-hosted, SyncHub runs in the background 24-7, keeping your data up to date while you sleep.

If your SQL skills are a little rusty, we've got you covered too. Our AI Assistant lets you speak with your MYOB Business data in natural language - no SQL or BI skills required! Read more about our AI here.

SyncHub can poll MYOB Business as frequently as every five minutes, however this capability may be limited by the amount of data you have and/or the type of plan you have with MYOB Business. The best way to find out is to simply grab a free trial of SyncHub, connect MYOB Business, then see for yourself.

No. SyncHub is a read-only tool and cannot reflect changes back to your cloud applications.

We currently sync Account, Account register, Company preference, Customer, Customer payment, Custom list, Employee, Employee payment detail, Employee payroll detail, Employee standard pay, Employment classification, Inventory item, Inventory location, Job, Job register, Journal transaction, Payroll category, Person, Purchase item bill, Purchase item order, Purchase service bill, Purchase service order, Balance sheet report, Employee payroll advice report, Journal transaction history report, Profit and loss report by fiscal year, Profit and loss report by month, Tax code report by fiscal year, Tax code report by month, Transaction coding report, Sale item invoice, Sale item quote, Sale service invoice, Sale service quote, Superannuation fund, Supplier, Supplier payment, Tax code, Tax table, Activity, Activity slip, Timesheet, Company email preference, Customer address, Customer identifier, Customer payment invoice, Custom list value, Employee address, Employee custom field, Employee identifier, Employee custom list, Employee payment details bank account, Employee payroll details entitlement, Employee payroll details deduction, Employee payroll details time billing rate, Employee payroll details superannuation category, Employee payroll details employer expense, Employee payroll details wage category, Employee payroll details employment classification, Employee standard pay payroll category, Inventory item location detail, Journal transaction line, Payroll category wage detail, Payroll category entitlement detail, Payroll category deduction detail, Payroll category expense detail, Payroll category superannuation detail, Payroll category tax detail, Person address, Purchase item bill line, Purchase item order line, Purchase service bill line, Purchase service order line, Balance sheet account, Employee payroll advice report line, Journal transaction history line, Profit and loss report by fiscal year account, Profit and loss report by month account, Tax code report by fiscal year item, Tax code report by month item, Sale item invoice line, Sale item quote line, Sale service invoice line, Sale service quote line, Supplier address, Supplier identifier, Supplier payment line, Timesheet line, Payroll category wage detail exemption, Payroll category entitlement detail linked category, Payroll category entitlement detail exemption, Payroll category deduction detail exemption, Payroll category expense detail exemption, Payroll category superannuation detail exemption and Timesheet entry (see our Data Model for full details). If there's something else you need just ask.

Your MYOB Business data is stored in its own dedicated data warehouse, hosted in our Microsoft Azure Sydney Data Center. If you'd like it stored somewhere else (even your own servers), just enquire about our BYOD (bring-your-own-database) option.

Absolutely. Every customer gets their very own isolated data warehouse. Database credentials are salt-encrypted...multi-factor authentication can be activated for your account...we take security very seriously. You can read more about our security best practices here.