Connectors and 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
Connection Name	A name for the connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + - Spaces at the beginning or end of the name are trimmed and are not saved as part of the name. Maximum length is 100 characters. Connection names are not case sensitive.
Description	An optional description for the connection. Maximum length is 255 characters.
Type	The type of connection. Select the Netsuite Mass Ingestion connection type.
Runtime Environment	Name of the runtime environment where you want to run the ingestion tasks. For application ingestion and replication tasks, you can select a Secure Agent or a serverless runtime environment. You can’t use a Hosted Agent.
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.