Knowledgebase: Connection
[QODBC-Desktop] Configure QODBC for use with Jitterbit Community Edition 3.0.0 (QRemote)
Posted by Jack - QODBC Support on 20 August 2015 10:37 AM

Configure QODBC for use with Jitterbit Community Edition 3.0.0 (QRemote)

To use QODBC with Jitterbit community edition 3.0.0, you should follow the steps below to configure your QODBC driver and Jitterbit connection. These steps work for QODBC with Jitterbit 3.0.0 on 32-bit Windows 7. Other platforms have not been tested.

First, you need to configure QRemote. To configure QRemote, please follow the below steps:

QRemote has two components "QRemote Client Driver for QODBC" and "QRemote Server for QODBC." 

QRemote Client Driver: Allows 64-bit Applications to connect to QRemote Server and sends the Request to QRemote Server for Processing.  

QRemote Server: Processes requested instruction from QRemote Client to QuickBooks using QODBC DSN Driver. 

 

Start "QRemote Server for QODBC" from the start menu. ( If QRemoteServer is not running ) 

 

Double-click the QRemote Server icon from the system tray

QRemote Server Main screen shows the IP address and Port allowing the QRemote Client to connect.

Note the IP address and Port number listed on the QRemote Server "Event Logs window."

Create a new DSN entry/or configure the existing one

Navigate to Start Menu, QODBC Drivers for Use with QuickBooks, and click

Configure QODBC Data Source

QODBCStartMenu.png

"QuickBooks Data QRemote" is the default DSN created when installing QODBC.

 

Configure the DSN and provide the IP address and Port as listed under "QRemote Server."

Under the QRemote for QuickBooks – Client  DSN configuration screen, Please fill in the following information. 

  • Data Source Name: Name of your DSN entry 
  • Server: IP address displayed on QRemote Server 
  • Port: Port displayed on QRemote Server 
  • Encryption Key: Keep default key "QODBC#QRemote$1" (In case you want to use encrypted data transfer between QRemote client and QRemoteServer, You can configure your encryption key on QRemoteServer and use the same on QRemote Client DSN) 
  • Remote DSN: select the QODBC DSN from the list. ( Make sure QRemote Server is running) 

After configuring QODBC, you need to configure Jitterbit. To configure Jitterbit, please follow the below steps:

1. Start the Jitterbit client

2. Right-click Sources and create a New Source

http://support.flexquarters.com/esupport/newimages/Jitterbit/Step4.png

 

3. Type QB in the Name field

4. Select the Database for the type

5. Click Options

6. Ensure the box marked "Construct connection string manually" has a tick in it

7. Enter DSN=QuickBooks Data QRemote into the field adjacent to the checkbox.

8. Click the Save icon.

http://support.flexquarters.com/esupport/newimages/Jitterbit/Step5.png

(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).