Skip to content

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), XeroQuickbooks 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.

Videos

SQL Connector

Sage Overview

SQL Connector

Quickbooks Online Overview

SQL Connector

Sage 50C Installation

SQL Connector

Xero Installation


Pricing

The Connector comes in three flavours for Dynamics, SQL and for Stripe each priced independently. Pricing is per user for the Dynamics Connector with a price break from the 51st user onwards whilst the SQL and Stripe Connectors are a monthly or annual subscription per legal entity. Monthly subscription is available at a tenth of the annual price (two months free with annual subscription). Contact us for bespoke pricing If you have more than one legal entity or Stripe instance. Reseller pricing is the same as our direct pricing.

SQL Connector

£ 950 /Year/Company

  • Customer, Supplier, Sales, Purchase and Accounting Data
  • Power BI Template included.
  • Export to MySQL or SQL Server.
  • Simple TXT files for Excel.
  • Incremental Updates.
Free Trial

Configuration

£ 750 

  • Configuration and Handholding.
  • Requirements Specification.
  • Software Configuration.
  • Supervised UAT.
  • Typically three 40 minute online sessions.
Free Trial
Register now for a free trial or contact us or your reseller directly for fully supervised configuration and handholding including three online sessions.

REDWARE CONNECTOR

Xero
Sage 50C
QuickBooks Online
Dynamics 365
SQL Server
Power BI
About Us

Specialist billing software house working with Dynamics 365 and Power BI connected to Xero, Sage 50 and QuickBooks Online.

Find out more
Contact Us

 +44 203 1799 444

 sales@redware.com

 Redware Research Limited.
32 Welbeck Avenue, Hove BN3 4JL, ENGLAND.