NetSuite

Obtaining credentials

To connect to NetSuite, you need to have your details on hand. Please follow the corresponding instructions below to obtain the required credentials.

Obtaining a NetSuite Account ID

1.	Log in to Netsuite.

2.	Select the Setup tab.

3.	In the drop-down menu select Integration -> Web services preferences.

4.	In the opened window you can cut and paste your Account ID into the NetSuite configuration dialog box.

Obtaining a Netsuite Application ID

1.	Log in to your NetSuite account.

2.	Click on Setup -> Integrations -> Manage Integrations -> New

3.	On the resulting page, Name the application that will be integrating with NetSuite (for example, "Access") Make sure the "Token Based Authentication" is unchecked and only the "User Authentication" is checked

4.	Press Save. On the resulting page, the Application ID will be generated for the application

5.	Copy the Application ID and Paste it into the driver configuration dialog box.

Connection Dialog

To connect to NetSuite, required connection parameters must be set.

The following connection options are required:

1.	Account Id - The NetSuite account number, which is required for most interactions with NetSuite outside of the NetSuite application;

2.	User Id - The NetSuite login account;

3.	Password - The password for the NetSuite login account;

You can find your Account Id from the support section of the application by clicking Support -> Visit the SuiteAnswers Site -> Contact Support by Phone (on the right side of the page).

In addition to the required options, Advanced connection options may be set for more fine connection tuning.

Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced Connection Editor dialog box:

Option	Description
Account Id	The NetSuite account number, which is required for most interactions with NetSuite outside of the NetSuite application.
Application ID	Application ID is used to specify the application you want to connect to. To obtain a NetSuite Application ID, refer to the Obtaining Account ID and Application ID section.
Authentication	Type of Authentication. May be Basic or Token-Based.
Connection Lifetime	When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by Connection Lifetime. The default value is 0 (connection always returns to pool).
Connection Timeout	The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. The default value is 15.
Default Command Timeout	The time in seconds to wait while trying to execute a command before terminating the attempt and generating an error.
Local SQL Engine	Determines whether to enable local SQL processing (enabled by default). Local SQL processing allows performing complex SELECT statements that cannot be directly compiled to NetSuite API calls. In this case ll the data from the mentioned cloud objects is queried to the local cache, and then the query is performed against the cache. If local SQL processing is disabled, only simple SELECT statements that can be directly translated into NetSuite API calls can be used. More complex SELECT statements will fail.
Max Pool Size	The maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.
Min Pool Size	The minimum number of connections allowed in the pool. The default value is 0.
Password	The password for the account.
Persist Security Info	Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.
Pooling	If true, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.
Proxy Host	The host name or IP address of proxy server.
Proxy Password	The password for the proxy server account.
Proxy Port	The port number of the proxy server. The default value is 3128.
Proxy User	The proxy server account name.
Readonly	Indicates whether the connection is read-only (allows only SELECT statements).
Server	Server name
Use Custom Fields	Set this parameter to True if you need to work with custom fields of predefined NetSuite objects. However, please note that processing custom fields may take a substantial amount of time, and it's better to leave the default False value if you don't need to work with custom fields.
Use Custom Tables	Set this parameter to True if you need to work with custom NetSuite objects. However, please note that processing custom objects may take a substantial amount of time, and it's betterto leave the default False value if you don't need to work with custom NetSuite objects.
User ID	The NetSuite login account.
UTC Dates	If set to True, dates will be converted to UTC format during import, and the date values entered by the user (in SELECT statements, etc.) are considered UTC dates when sending them to the data source.