A JDBC connection allows you to access NetSuite SuiteAnalytics and conveniently fetch large amounts of data. You must enable the Connect Service feature and add your SuiteAnalytics Connect permissions before connecting to NetSuite SuiteAnalytics.
Set up a connection
After you start the connection, you have to configure it in the Create connection panel and complete all of the required * authentication settings:
|Server name *||Enter the NetSuite SuiteAnalytics Connect server TCP/IP address.|
|Port number||Displays 1708 and cannot be edited. This is required while configuring the data source in NetSuite.|
|Server data source *
Select the NetSuite SuiteAnalytics Connect server data source, either NetSuite.com or NetSuite2.com.
Note: As of November 8, 2021, new Connect users can access the Connect Service using the NetSuite2.com data source only. If you gained access to the Connect Service before this date, you can still access the NetSuite.com data source to ensure a smooth transition to NetSuite2.com. Note that the NetSuite.com data source is no longer being updated with newly exposed tables and columns, and support for this data source will end in a future release. The use of the NetSuite.com data source is no longer considered a best practice, and all Connect users are encouraged to use the NetSuite2.com data source. For more information about this change, see New Accounts and Access to the Connect Data Source.
|Username *||Enter the username for your NetSuite account.|
|Password *||Enter your NetSuite password.
Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s password safe. When editing this form later, you must enter this value again; it is stored only for a saved connection.
|Account Id *||Enter your NetSuite Account Id. Navigate to Setup → Integration → Web Services Preferences. If you can’t find your Account Id here, please contact NetSuite’s support team.|
|Role internal Id *||Enter the Internal Id associated with your user’s Role. Determine the user you’re using for this connection. Navigate to Setup → Users/Roles → Manage Roles. If your settings automatically display the Internal Ids, find the proper Id and add it to the connection. If the Internal Id is not automatically displayed, open the Role in View mode and use the URL in your browser to find the Id. If you can’t find your Role Internal Id, please contact NetSuite’s support team.|
|Static schema export *||Choose Yes to use the static data model, which provides the structure, the name of all available record types, and the fields in the NetSuite2.com data source. (To use the static data model in your account, you must add the StaticSchema attribute and set it to 1.)|
|Authentication types *||Choose between:|