SQL Connector

Connect your Accounting Data to SQL Database

Our SQL Connector copies your accounting data into SQL Server or MySQL. We support Sage 50C (not the US Version), Xero, Quickbooks Online, and Sage 200.

Tell your IT people - they have been wanting this for years !

Customer, Supplier, Product, and Nominal codes are synchronised together with all associated Invoices, Credit Notes and Purchase Orders. Sales and Purchase documents are stored down to each individual line item for analysis by Product code. Nominal Transactions and Payments are also copied so you can analyse Trial Balance and Balance Sheet transactions and make cashflow forecasts. You have full access to the database and can integrate with your own systems and reporting tools. 

Exporting accounting data to a SQL Database allows eary access from your internal systems and business intelligence reporting with Power BI and Tableau is easily achieved. You can synchronsise your data hourly or daily. Multi-company reporting is very achievable allowing easy multi-company accounting reports for a Group of related Companies. 

Our ready-made Power BI report used in our Power BI Connector is included as part of the SQL Connector subscription. It illustrates nicely all the data available to you once you push your data into a SQL Database. Please see the Power BI report below which is a multi-company report with sample data from 12 different accounting databases. We have downloaded data multiple accounting databases and you can use the "Legal Entity" filter on the Power BI report to select one or more Companies for the accounting reports:

• Sage 50C - IE, UK, NZ, SA, AU
• QuickBooks online - US, UK, CA, and DE.
• Xero - US, UK, AU, and NZ.
• Sage 200 - UK.