Knowledgebase
[QXL-ALL] How to export to DB2
Posted by Jack - QODBC Support on 11 May 2018 12:10 PM

How to export to DB2

Problem Description:

I am using QXL & I want to export QuickBooks Data to DB2.

How can I export QuickBooks Data to DB2 using QXL?

Solution:

You can export QuickBooks Data to DB2 using QXL.

First, You need to create ODBC DSN for DB2, which will point to the DB2 Database.

I have already created ODBC DSN for DB2 below the property of the DSN.

We will test the connection of DB2 DSN by providing DB2 by clicking the "Connect" button.

DB2 ODBC DSN test connection is successful. 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 & "IBM DB2" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXL_DB2

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 DB2. You can export by clicking on the Export icon from QXL Setup Screen.

QuickBooks Data is exported to the DB2.

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).