In this data integration ETL example, we will create a Data Interface to extract Customer Accounts data from a Database and load it into QuickBooks.
Refer to the attached video on the steps involved in setting up a data interface between a source and target application.
The JDBC Server URL in the DB Info activity to configure the QuickBooks Online connection uses the following format:
jdbc:quickbooks:Schema=Online;Company Id=<Company Id>;OAuth Client Secret=<OAuth Client Secret>;OAuth Client ID=<OAuth Client ID>;OAuth Access Token=<OAuth Access Token>;OAuth Access Token Secret=<OAuth Access Token Secret>;
Please refer to the attached video and walk-through document to obtain the values for the Server URL fields above.
The QuickBooks Driver is already bundled with the product. Select this driver from the Database Driver drop-down list as shown in the video.
If you are connecting to an on-premise/Desktop version of QuickBooks, the JDBC Server URL uses the following format:
jdbc:quickbooks:Schema=< Schema >;user=< User >;password=< Password >;URL=< URL >;
NOTE: To perform an Update to records in QuickBooks, make the following modifications from the activities included in the video:
In the Data Interface Target configuration:
- Modify the My target layout details (Adv. Database Schema) to include a Primary Key, which is the Id of your QuickBooks object.
- Modify the My target location details (Adv. Database Target) to an Update Database Operation.
- Modify your Data Mapping to include a mapped value for the target element Id, which would be the unique key for the record you want to update.