Configuring the ODBC Data Source on Linux

Editing odbc.ini or odbc64.ini and Configuring the ODBC Data Source

To update the ODBC Data Source on Linux, you must edit the odbc.ini or odbc64.ini file, depending on whether you installed the 32-bit or the 64-bit version of the driver. Use the odbc64.ini if you installed a 64-bit ODBC Connect driver.

To edit odbc.ini or odbc64.ini and configure the ODBC data source on Linux:

1. Locate the odbc.ini or odbc64.ini file. Typically, this file is located in your driver’s installation folder.

2. Edit the following values in odbc.ini or odbc64.ini. You can find many of these values under Your Configuration on the SuiteAnalytics Connect Driver Download page. You can access the SuiteAnalytics Connect Driver Download page using the Set Up Analytics Connect link in the Settings portlet when you are logged in to NetSuite. For more information, see Finding Your Settings Portlet.

   Variable Name	Description
   Host	Connect Service host name. The host name you should use for your connection is displayed in the Service Host field on the SuiteAnalytics Connect Driver Download page, under Your Configuration.
   Port	Should always be set to 1708.
   ServerDataSource	Data source for the Connect Service. Available values: NetSuite2.com For more information about the data source, see Connect Data Source.
   Encrypted	Should always be set to 1.
   TrustStore	The security certificates used for the connection.
   AccountID	The NetSuite account ID that will access the SuiteAnalytics Connect schema. Enter this value under CustomProperties. The value is displayed in the Account ID field on the SuiteAnalytics Connect Driver Download page, under Your Configuration.
   RoleID	Role ID corresponding to the Account ID. Enter this value under CustomProperties. The value is displayed in the Role ID field on the SuiteAnalytics Connect Driver Download page, under Your Configuration.
   AllowSinglePacketLogout	You must set this attribute to 1. You must use AllowSinglePacketLogout=1. For more information, see Connection Attributes. Note: The downloadable ZIP file for the ODBC driver contains the odbc[64].ini file with the new attribute. If you overwrite the existing INI file, you do not need to edit it.
   StaticSchema	Optional. The Static Data Model option provides you with the structure and the name of all available record types and fields in the NetSuite2.com data source. To use the Static Data Model in your account, you must add the StaticSchema attribute and set it to 1. For more information, see Setting the Static Data Model for Connect Drivers.

You can have more than one Data Source defined in a Linux ODBC driver configuration.

Note:

The below examples are working with a 64-bit version, for a 32–bit version use odbc.ini.

Adding an ODBC Data Source

To add a new ODBC Data Source on Linux, you must edit the odbc64.ini file.

To add an ODBC Data Source on Linux

1. Locate odbc[64].ini.

2. Modify the [ODBC Data Sources] section. Add new line:

                     MyNewDatasource=NetSuite ODBC Drivers 8.1 
   
                   

3. Add a new [MyNewDatasource] section:

                     [MyNewDatasource]
   Driver=/opt/netsuite/odbcclient/lib64/ivoa27.so
   Description=My new Sandbox ODBC datasource
   Host=<ServiceHost>
   Port=1708
   ServerDataSource=NetSuite.com
   Encrypted=1
   AllowSinglePacketLogout=1
   TrustStore=/opt/netsuite/odbcclient/cert/ca3.cer
   CustomProperties=AccountID=<accountID>;RoleID=<roleID> 
   
                   

   The resulting odbc64.ini file looks like the following:

                     [ODBC Data Sources]
   NetSuite_DC001=NetSuite ODBC Drivers 8.1
   MyNewDatasource=NetSuite ODBC Drivers 8.1
   
   [NetSuite]
   Driver=/opt/netsuite/odbcclient/lib64/ivoa27.so
   Description=Connect to your NetSuite account
   Host=<ServiceHost>
   Port=1708
   ServerDataSource=NetSuite.com
   Encrypted=1
   AllowSinglePacketLogout=1
   TrustStore=/opt/netsuite/odbcclient/cert/ca3.cer
   CustomProperties=AccountID=<accountID>;RoleID=<roleID>
   
   [MyNewDatasource]
   Driver=/opt/netsuite/odbcclient/lib64/ivoa27.so
   Description=My new Sandbox ODBC datasource
   Host=<ServiceHost>
   Port=1708
   ServerDataSource=NetSuite.com
   Encrypted=1
   AllowSinglePacketLogout=1
   TrustStore=/opt/netsuite/odbcclient/cert/ca3.cer
   CustomProperties=AccountID=<accountID>;RoleID=<roleID>
   
   [ODBC]
   Trace=0
   IANAAppCodePage=4
   TraceFile=odbctrace.out
   TraceDll=/opt/netsuite/odbcclient/lib64/ddtrc27.so
   InstallDir=/opt/netsuite/odbcclient 
   
                   

   Note:

   To include the required attribute values, see the following:

   The <ServiceHost>, <accountID> and <roleID> variables represent your host name, account ID, and role ID. The values are available on the SuiteAnalytics Connect Driver Download page under Your Configuration. You can access the SuiteAnalytics Connect Driver Download page using the Set Up Analytics Connect link in the Settings portlet when you are logged in to NetSuite. For more information, see Finding Your Settings Portlet.

Related Topics

Downloading and Installing the ODBC Driver for Linux

Installing the Latest Driver on Linux

Installing a Driver for Linux into an Alternate Directory

Accessing ODBC Data Source on Linux

Verifying the ODBC Driver Installation on Linux

General Notices