Connections

Back Next

NetSuite Mass Ingestion connection properties

When you set up a NetSuite Mass Ingestion connection, you must configure the connection properties.

Before you configure the connection properties, install the SuiteAnalytics Connect JDBC driver and copy the NQjc.jar file to the following directory:

<Secure_Agent>\ext\connectors\thirdparty\informatica.netsuiteami

For more information about installing the SuiteAnalytics Connect JDBC driver, see the SuiteAnalytics Connect documentation.

The following table describes the connection properties for a NetSuite Mass Ingestion connection:

Connection property	Description
Runtime Environment	Name of the runtime environment where you want to run the ingestion tasks. You must specify a Secure Agent as the runtime environment. You cannot run application ingestion tasks on a Hosted Agent or serverless runtime environment.
Email ID	User name of the NetSuite account. The user name is an email address.
Password	Password for the NetSuite account.
Service Host	Name of the SuiteAnalytics Connect Service host. The value in this field must match the value specified in the Service Host field under the Your Configuration section of the SuiteAnalytics Connect Driver Download page in NetSuite. To access the SuiteAnalytics Connect Driver Download page, log in to NetSuite and click the Set Up SuiteAnalytics Connect link in the Settings portlet.
Service Port	TCP/IP port on which the SuiteAnalytics Connect server is listening. Default is 1708.
Service Datasource	Data source that you want to use to access NetSuite data. You can select one of the following data sources: NetSuite.com NetSuite2.com Default is NetSuite2.com. In connections configured before the August 2022 release, the default value for this field is NetSuite.com. To use a NetSuite2.com data source, the NetSuite user account must be configured with some specific roles and permissions. For more information about the roles and permissions required to access NetSuite2.com data sources, see the NetSuite documentation.
Account ID	NetSuite account ID. To find your account ID, log in to NetSuite and click Setup Integration Web Services Preferences . If you cannot access the Setup menu, navigate to Support Go to Suite Answers Contact support by phone . The page displays your account ID.
Role ID	Role ID associated with the NetSuite account.
Additional Connection Properties	Additional properties for the SuiteAnalytics Connect Driver that is used to connect to the NetSuite service data source. Specify the properties in <property>=<value> format. If you want to specify multiple properties, separate each property-value pair with a semicolon (;). You can specify the following connection properties in this field: ValidateServerCertificate : Determines whether the driver validates the certificate sent by the SuiteAnalytics Connect server. During SSL server authentication, the SuiteAnalytics Connect server sends a certificate issued by a trusted Certificate Authority (CA). The required CAs are usually included in the Java truststore but you can also specify them using the TrustStore property. Valid values for the ValidateServerCertificate property are true and false . TrustStore : Contains the path to a valid truststore containing the security certificates to be used for server authentication. The TrustStore property is ignored if the ValidateServerCertificate property is set to false . For more information about the additional connection properties, see the NetSuite documentation.

Rename Saved Search

Table of Contents

Connections

Connections

NetSuite Mass Ingestion connection properties

NetSuite Mass Ingestion connection properties