Tuesday, November 27, 2018

Use NetSuite ODBC as Data Source for Informatica Integration

1. Create a Connection setup for ODBC to connect to your NetSuite account
2. Navigate to Data Services > Data Synchronization, click "New"
3. Assign the following Values:

Task Name: [ name of your choice ] 
Task Operation: [ operation of your choice ]
Wizard Mode: Advanced
Source Connection: [ the NetSuite ODBC connection created in Step 1 ] (Please note that NetSuite ODBC is currently limited for data query only so NetSuite ODBC connection can only be used as Source in Informatica Integrations and not Target Connection)
Source Type: [ as needed ] 
Source Object: (click Select)

Notice an error which will not allow the tables to be shown, the user can however type the name of the table to include in the integration in the "Selected Objects" box and click OK.

4. Select the Target Connection, Data Filters, Field Mapping and Schedule

No comments:

Post a Comment