Articles in this section

Set up a connection to NetSuite JDBC

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.

Important

A NetSuite JDBC connection is considered a separate endpoint from a standard NetSuite connection. For more on endpoint capacity, see How much capacity your account has.

Tip

The NetSuite JDBC connection offers certain advantages over integrating with NetSuite via Saved Searches. In general, NetSuite JDBC is best suited for integration developers with SQL expertise; the statements needed to mimic the NetSuite web interface can be complex for beginners.

Consider selecting NetSuite JDBC if you have any of the following requirements:

  • Complex joins, which can’t be accomplished in a Saved Search with the single-layer join limit

  • Exporting large amounts of data for analytics

  • More quickly exporting large amounts of data in your flow – for example, an entire transaction history with 50+ columns and hundreds of thousands or millions of records

  • Reducing API usage, since NetSuite JDBC is not typically governed by NetSuite concurrency restrictions

  • Have access to a paid NetSuite SuiteAnalytics Connect subscription

Tip

Click pencil_handlebars.svg to open the Build SQL query editor and ask Celigo AI to generate a query for you. Enter a description of your query in plain English in the space provided, and Celigo AI will attempt to generate a query based on your prompt.

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:

Application details

Description

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.

NetSuite.com *

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 SetupIntegrationWeb 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 SetupUsers/RolesManage 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.

NetSuite2.com *

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:

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.