In this data integration ETL example, we will create a Data Interface to extract Accounts data from a Database and load it into NetSuite.
Refer to the attached video on the steps involved in setting up a data interface between a source and target application.
The JDBC URL in the DB Info activity to configure the NetSuite connection uses the following format:
jdbc:netsuite:Account Id=< Account Id >;Password=< Password >;User=< User >;Role Id=< Role Id >;Version=< Version >;Location=< Location >;
< Account Id > is the company account your user name is associated with on NetSuite.
< Password > is the password of the NetSuite user used to authenticate.
< User > is the user of the NetSuite account used to authenticate.
< Role Id > is the Internal ID of the role that will be used to log in to NetSuite. Leave empty to use the user's default role.
< Version > is the version of the NetSuite API in usage. Defaults to 2013_1.
< Location > is a path to the directory that contains the schema files defining tables, views, and stored procedures.
The NetSuite Driver is already bundled with the product. Select this driver from the Database Driver drop-down list as shown in the video.
NOTE: To perform an Update to records in NetSuite, 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 InternalId of your NetSuite 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 InternalId, which would be the unique key for the record you want to update.