[QXL-ALL] How to configure QXL to export to SQLite
Posted by Jack - QODBC Support on 18 May 2017 06:16 AM
How to configure QXL to export to SQLite
I am using QXL & I want to export QuickBooks Data to ODBC Database.
How can I export QuickBooks Data to ODBC Database using QXL?
You can export QuickBooks Data to ODBC Database using QXL.
In this example, We will show you to export QuickBooks Data to SQLITE (ODBC Database) using QXL.
First, You need an ODBC connector to connect to the ODBC database.
You need to download & install the ODBC connector on your system.
After installing the ODBC connector, You need to configure ODBC DSN, which will point to the ODBC Database.
I have already created ODBC DSN for SQLite. Below is the property of the DSN.
We will use this DSN in QXL. We will use this DSN in QXL.
The first step in adding an ODBC connection is to click on the settings icon for QXL options details.
Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.
Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Others/Custom Mapping" as a Mapping Type.
You can insert any value for the Connection Name.
Sample ODBC Connection String Format: DSN = Data Source Name
For Example DSN=SQLITE
You can configure data mapping as per your ODBC Database. You can choose different data types as per your ODBC Database.
For Example: If your ODBC database support smallint instead of Int16, then you need to write smallint in the text box of Int16. The sIn the same way, you can change ODBC Mapping for different datatypes as per your ODBC Database.
After changing ODBC Mapping as per your ODBC Database, click the "Test Connection" button.
Test Connection Successful.
Click the "Save" button to save connection details.
Connection information updated.
The connection is added to the dropdown list.
Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."
Now data is ready to export into ODBC Database. You can export by clicking on the Export icon from QXL Setup Screen.
QuickBooks Data is exported to the SQLITE (ODBC Database).