Connections > NetSuite Mass Ingestion connection properties
  

NetSuite Mass Ingestion connection properties

When you set up a NetSuite Mass Ingestion connection, you must configure the connection properties.
Note: 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.
You must specify a Secure Agent as the runtime environment.
Note: You cannot run application ingestion and replication 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.
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.
Note: For more information about the additional connection properties, see the NetSuite documentation.