ODBC Installation on Windows for a Bundled Installation
Before you install or upgrade the Connect driver, ensure that you meet the installation prerequisites. For more information, see Installation Prerequisites.
Download an installation bundle to automatically incorporate your current user context data (such as Service Host, Account ID and Role ID) in to the installer. This is the preferred approach if you want to use the driver to connect to your current account. This installer uses the provided dsn.ini file to configure the System DSNs using the account information for the user who downloaded the installation bundle. Use this option if you want to install the driver on a single machine and connect to a production account.
After you downloaded the Connect driver, ensure that you install it as local administrator. If you install the driver on Windows as domain administrator, the installation process may fail.
When you install the bundle you get DSN content from dsn.ini and thus the DSN is created automatically.
After you complete the installation, you can add additional System DSNs to connect to the Connect Service for a sandbox or Release Preview account. For more information, see Configuring the ODBC Data Source on Windows and Driver Access for a Sandbox or Release Preview Account.
To install or update the ODBC driver using a bundled installation:
-
In the Settings portlet on your NetSuite home page, click Set Up SuiteAnalytics Connect. For more information about the Settings portlet, see Finding Your Settings Portlet.
Note:If the download link is not displayed, you need to enable the Connect Service. For more information, see Enabling the Connect Service Feature.
-
In the upper left corner, select your platform.
Note:If your platform is 64-bit, but you are planning to use a 32-bit application to get data from NetSuite, choose the 32-bit version of your platform, so you can install a 32-bit SuiteAnalytics Connect driver.
-
Click the Download button next to the ODBC Installation Bundle.
-
When the driver installation bundle is downloaded, extract the .zip file. The dsn.ini file and the driver .exe file are extracted to the same folder. If you decide to move the files elsewhere, make sure you move both the dsn.ini file and the .exe file, as they should always be in the same location.
-
Run NetSuiteODBCDrivers_Windows32bit.exe or NetSuiteODBCDrivers_Windows64bit.exe, depending on the driver version you downloaded.
-
Follow the wizard’s instructions to install or update the driver.
-
When the installation is complete, check that the correct data source is configured for your ODBC driver. For more information, see Verifying the ODBC Driver Installation on Windows and Configuring the ODBC Data Source on Windows.
Note:For information about the data source, see Connect Data Source.
When you installed the driver and verified the data source settings, you can configure your applications to access the SuiteAnalytics Connect service. One of the options is to connect your application using a connection string. To learn more about connection strings, see Connecting Using a Connection String.