Allowing Integrate.io ETL access to NetSuite JDBC(Source)

Integrate.io ETL can read data in your NetSuite account using JDBC connectivity. The SuiteAnalytics Connect option should be enabled in your account. Get the connection information to your account through Settings -> Set Up SuiteAnalytics Connect -> Your Configuration.

To create a NetSuite JDBC(Source) connection in Integrate.io ETL:

1. Click the Connections icon (lightning bolt) on the top left menu.
2. To create a connection, click New connection.
3. Choose NetSuite JDBC(Source).
4. In the new NetSuite JDBC(Source) connection window, name the connection and enter the connection information:
   • Name - name for the new connection
   • Hostname - copy from SuiteAnalytics Connect configuration (see image below)
   • Port - copy from SuiteAnalytics Connect configuration (see image below)
   • User name - your NetSuite user name.
   • Password - your NetSuite password. 
   • Service data source - copy from SuiteAnalytics Connect configuration (see image below).
   • Account ID - copy from SuiteAnalytics Connect configuration (see image below).
   • Role ID - copy from SuiteAnalytics Connect configuration (see image below).
5. Then, test the NetSuite connection by clicking Test connection. Once the connection tests successful, click Create connection.

You can find the connection information needed above in the SuiteAnalytics Connect configuration panel shown here:

To setup Netsuite2.com as data source:

1. Create a new role. Go to Setup > Users/Roles > Manage Roles > New.
   
2. Enter a name for this role. Select Permissions tab and then click Setup tab and assign following permissions:
   
   • Log in using Access Tokens
   • SuiteAnalytics Connect
     
     • Note: The 'Subsidiary Restriction' section may limit access to certain records you wish to retrieve. Depending on the type of subsidiary structure your organization operates under, you should carefully select these options to ensure you obtain the desired data.
3. Grant an access to the selected tables. On the same role creation page, go to Lists tab and select tables.
   • Note: The screenshot below is demonstrating how to enable access to the Account table. Before proceeding, we recommend coordinating with your business team to determine the complete list of NetSuite tables required for your integration. Once the list is finalized, please contact your NetSuite Account Manager for assistance in configuring the appropriate permissions to ensure all relevant tables are both visible and accessible for integration purposes.
4. Assign the Roles to the selected User. Select Access tab and then add following roles under Roles tab:
   • The role that has just been created from previous step
   • Data Warehouse Integrator role 
     
5. Configure DB connection in Integrate.io ETL. Enter connection information (see steps "To create a Netsuite connection in Integrate.io ETL" from above ) along with Netsuite2.com as Service data source and Role ID from the role that we just created from step 2.