1. SuiteAnalytics
  2. Connect
  3. Accessing the Connect Service Using an ODBC Driver
  4. Authentication Using Server Certificates for ODBC

Authentication Using Server Certificates for ODBC

ODBC uses TLS-secured connections. Currently, only TLS 1.2 is supported. Further, we actively look for new vulnerabilities and respond as needed to new threats.

You should use authentication using server certificates. To ensure that the authentication with server certificates is enabled, check the following topics:

Determining the Required Actions for your Driver and Operating System

The following tables outlines the actions required depending on your operating system and the version of the driver you install:

Driver

Action Required

Windows ODBC drivers (any)

Ensure you have the latest driver version installed. If you are connecting via connection string, verify that the Truststore attribute is set to "system."

For more information, see the following help articles:

Linux ODBC drivers (any)

Ensure that you have the latest driver version installed. Add the new ca4.cer certificate to your Truststore path. Retain path to existing ca3.cer.

For more information, see the following help articles:

Adding the Required Security Certificates to the Certificates Store

To access the Connect Service, the required server certificates must be included in your Windows Trusted Root Certification Authorities store. The server certificates are usually already included. If they aren't included and you can't connect, download the security certificates from the SuiteAnalytics Connect driver download page and add them manually.

To add the required security certificates to the certificates store:

  1. In the Settings portlet on your NetSuite home page, click Set Up SuiteAnalytics Connect. If you don't see the link, you need to enable the Connect Service. For more information, see Enabling the Connect Service Feature.

  2. Click the Download button next to CA CERTIFICATES.

  3. When the certificates .zip file is downloaded, extract it to any location on your computer.

  4. Next, go to your Windows Start menu, type mmc in the search field and press Enter. This opens the Microsoft Management Console.

  5. On the File menu, select Add/Remove Snap-in.

  6. Select the Certificates snap-in and click Add.

    You can set the snap-in to manage security certificates for your user account, service account, or computer account.

  7. When you've finished setting up the snap-in, click OK.

  8. In the console tree, double-click Certificates.

  9. Right-click the Trusted Root Certification Authorities store and select All Tasks > Import.

  10. Follow the wizard’s instructions to specify the downloaded security certificate files and import them to your Trusted Root Certification Authorities store.

When the security certificates are imported, the SuiteAnalytics Connect ODBC integrations will automatically start using them when connecting to NetSuite.

Related Topics

General Notices