[QXL-ALL] How to export to MySQL
Posted by Jack - QODBC Support on 24 April 2017 11:19 AM
How to export to MySQL
I am using QXL & I want to export QuickBooks Data to MySQL.
How can I export QuickBooks Data to MySQL using QXL?
You can export QuickBooks Data to MySQL using QXL.
First, You need MySQL ODBC connector to connect with MySQL database.
You need to download & install MySQL ODBC connector in your system.
Refer: Download Connector/ODBC to download MySQL ODBC connector.
After installing MySQL ODBC connector, You need to configure MySQL ODBC DSN which will point to the MySQL Database.
Refer: Configuring a Connector/ODBC 5.x DSN on Windows to configure MySQL ODBC DSN.
I have already created ODBC DSN for MySQL below is the property of the DSN.
MySQL ODBC DSN test connection successful. We will use this DSN in QXL. We will use this DSN in QXL.
The first step in adding ODBC connection is to click on settings icon for QXL options details.
Navigate to "Pro Edition" & click "Add New" button for adding the New connection.
Enter connection details (i.e. Connection Name, Connection String) select "ODBC Data Source" as a Connection Type & "MySQL Server" as Mapping Type and click "Test Connection" button.
You can insert any value for Connection Name.
Sample ODBC Connection String Format: DSN = Data Source Name
For Example: DSN=MYQXLANSI
Test Connection Successful.
Click "Save" button to save connection details.
Connection information updated.
The connection is added in 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 MySQL. You can export by clicking on the Export icon from QXL Setup Screen.
QuickBooks Data is exported to the MySQL.