How Does Fivetran Connect to My NetSuite Account?

Question

How does Fivetran connect to my NetSuite account?

Environment

Connector: NetSuite SuiteAnalytics

Answer

To connect Fivetran with your Netsuite account, we utilize the following account information you provided while setting up your connector:

• Account ID
• Service Host
• Service Port
• Role ID for Netsuite.com sources or Data Warehouse Integrator Role ID for Netsuite2.com sources.

We create a Java Database Connectivity (JDBC) link, which allows the connector to extract data from your account by executing SQL SELECT statements against various tables. We update the JDBC driver regularly to ensure the Netsuite connector does not hit issues due to an outdated JDCB driver.