Connectors and Connections > Data Ingestion and Replication connection properties > 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.
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.
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.

Use the serverless runtime environment

In Data Ingestion and Replication, you can use a serverless runtime environment hosted on Azure to connect to the NetSuite database.
Before you configure a NetSuite Mass Ingestion connection using the serverless runtime environment, perform the following tasks:
Add the JDBC driver as a JAR file in the Azure container in your Azure account
Perform the following steps:
  1. 1Create the following structure for the serverless agent configuration in Azure: <Supplementary file location>/serverless_agent_config/
  2. 2Add the JDBC driver files in the Azure container in the following location in your Azure account:
    3. <Supplementary file location>/serverless_agent_config/netsuiteami
Configure the .yml serverless configuration file
Perform the following steps to configure the .yml serverless configuration file in the serverless runtime environment:
  1. 1Copy the following code snippet to a text editor and specify the driver file name:
    2. version: 1
    agent:
    databaseIngestion:
    autoDeploy:
    netsuiteami:
    jdbc:
    drivers:
    - fileCopy:
    sourcePath: netsuite/<file_name>.jar
    where the sourcePath is the directory path of the driver files in Azure.
  2. 2Ensure that the syntax and indentations are valid, and then save the file as serverlessUserAgentConfig.yml in the following Azure location: <Supplementary file location>/serverless_agent_config
    3. When the .yml file runs, the JDBC driver files are copied from the Azure location to the following serverless agent directory: <AGENT_DIR>/ext/connectors/thirdparty/informatica.netsuiteami