Connection String Options
The connection string properties describe the various options that can be used to establish a connection.
SSIS Components
RSSBus NetSuite SSIS Components
Remarks
The connection string can be set to a series of "option=value" pairs separated by semicolons. If a connection string property value has special characters such as semicolons, single quotes, spaces, etc., then you must quote the value using either single or double quotes.
Connection options are case insensitive.
To specify where the table, view, and stored procedures of the database are located, set the Location property. In addition, you must also set User, Password, and AccountId. Caching Data can be enabled by using the appropriate options.
Connection String Options
The following is the full list of the options you can configure in the connection string for this provider. Click on the links for further details.
| Account Id | The company account your username is associated with on NetSuite. |
| Aggregate Column Mode | Indicating how aggregate columns should be treated. |
| Auto Cache | The AutoCache property controls automatic caching of data. |
| Cache Connection | The connection string for the cache database. |
| Cache Location | Specifies the path and file name of the cache file when caching to a file. |
| Cache Metadata | Whether or not to cache the table metadata. The cache will be stored in memory unless CacheConnection or CacheLocation are set. |
| Cache Provider | The name of the provider to be used to cache data. |
| Firewall Password | A password, if authentication is required to connect through a firewall. |
| Firewall Port | The TCP port for the firewall FirewallServer -- see the description of the FirewallServer option for details. |
| Firewall Server | Specify a firewall name or IP address to authenticate requested connections, if necessary. |
| Firewall Type | The type of firewall to connect through. |
| Firewall User | The user name to authenticate with the firewall. |
| Include Child Tables | A boolean indicating if child tables should be displayed. |
| Include Custom Field Columns | A boolean indicating if you would like to include custom field columns. |
| Include Custom Record Tables | A boolean indicating if you would like to use tables based on custom record types. |
| Include Reference Columns | A comma separated list representing the columns to include when retrieving data from a field representing a record reference. |
| Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
| Logfile | A path to the log file. |
| Logout Unknown Sessions | Boolean indicating if unknown sessions already established to the user account should be removed. |
| Maximum Concurrent Sessions | The maximum number of concurrent sessions available for use by the username specified in the connection. |
| Netsuite Metadata Folder | A path to a directory to download metadata files from NetSuite. Set this for best performance. |
| Offline | Use offline mode to get the data from the cache instead of the live source. |
| Other | The other parameters necessary to connect to a data source, such as username and password, when applicable. |
| Pagesize | The number of results to return per page from NetSuite. |
| Password | The password of the NetSuite user used to authenticate. |
| Proxy Auth Scheme | The proxy server authorization scheme (default: BASIC). |
| Proxy Auto Detect | This indicates whether to use the default system proxy settings or not. Set ProxyAutoDetect to FALSE to use custom proxy settings. This takes precedence over other proxy settings. |
| Proxy Password | A password, if authenticating with a proxy server. |
| Proxy Port | The TCP port for the proxy ProxyServer (default: 80). |
| Proxy Server | If a proxy server is given, then the HTTP request is sent to the proxy instead of the specified server. |
| Proxy SSL Type | The SSL type to use when connecting to the proxy server (default: AUTO). |
| Proxy User | A user name, if authentication is to be used for the proxy. |
| Pseudo Columns | Indicates whether or not to include pseudo columns as columns to the table. |
| Query Cache | The time duration, in seconds, for which the in-memory cached data is reused. |
| Readonly | You can use this property to enforce read-only access to NetSuite from the provider. |
| Request Memorized Transactions | A boolean indicating if you would like to request memorized transactions when retrieving transactions from NetSuite. |
| Role Id | The RoleId is the InternalId of the role that will be used to log in to NetSuite. Leave empty to use the user's default role. |
| RTK | The runtime key used for licensing. |
| SSL Cert | The certificate to be accepted from the server when connecting using SSL. |
| Tables | Comma-separated list of tables to be listed. For example: Tables=TableA,TableB,TableC. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| Use Async Services | A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting. |
| User | The user of the NetSuite account used to authenticate. |
| Use Sandbox | A boolean indicating if you would like to use the sandbox instance of your NetSuite account. |
| Use Sessions | Establish sessions with NetSuite, or instead submit user credentials on each request. |
| Use Upserts | A boolean indicating if you would like to perform an upsert when an insert operation is used. |
| Verbosity | The verbosity level that determines the amount of detail included in the log file. |
| Version | The version of the NetSuite API in usage. Defaults to 2013_1. |
| Web Service Host | An optional override for the web service host such as webservices.na1.netsuite.com. |