Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

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.
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.

0 COMMENTS

We’d like to hear from you!