[QXL-ALL] How to export to MariaDB
Posted by Jack - QODBC Support on 11 May 2018 12:44 PM
How to export to MariaDB
I am using QXL & I want to export QuickBooks Data to MariaDB.
How can I export QuickBooks Data to MariaDB using QXL?
You can export QuickBooks Data to MariaDB using QXL.
First, You need to create ODBC DSN for MariaDB which will point to the MariaDB Database.
I have already created ODBC DSN for MariaDB below property of the DSN.
We will test connection of MariaDB DSN by clicking "Test DSN" button.
MariaDB ODBC DSN test connection successful. 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 & "MariaDB" 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=QXL_MariaDB
Test Connection Successful.
Click "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 MariaDB. You can export by clicking on the Export icon from QXL Setup Screen.
QuickBooks Data is exported to the MariaDB.