QIntegrator Database Solutions

QIntegrator can import directly from MS Access, SQL Server, MYSQL, or any ODBC Compliant Data source.

Additionally, QIntegrator can update a flag in your database as transactions are successfully imported. This makes batching transactions automatic.

Your Recordset (in Access), SQL command, or stored procedure should return a de-normalized set of Invoices or Sales Receipts (or other transactions). This means that each line item of the transaction is a row of data and the header information (invoice number, customer name, etc.) repeats for each line.

Download a sample recordset to see the general layout. The fields names can be anything and you can add or remove columns as needed. The order of the fields isn't important either but there's a small performance gain if the Reference Number or Key is first.

Sample Invoice, Sales Receipt or Sales Order Recordset

Sample Vendor Bill with Line Items Recordset

Contact us about importing from your database.