1. SuiteAnalytics
  2. Connect
  3. Connect Service Notifications
  4. Mandatory Update for SuiteAnalytics Connect ODBC Drivers

Mandatory Update for SuiteAnalytics Connect ODBC Drivers

On May 11, 2018, new DigiCert SSL certificates were installed on the SuiteAnalytics Connect servers. This change caused older versions of the ODBC drivers for SuiteAnalytics Connect to stop working. New versions of the ODBC drivers were made available for download on March 22, 2018.

To avoid a service outage, you should upgrade to Windows ODBC driver version 7.20.55 or Linux ODBC driver version 7.20.51. These drivers support the new ca3.cer certificate.

If you use JDBC or ADO.NET drivers to access SuiteAnalytics Connect, no action is required. However, you should verify that all of the required certificates are in your truststores.

Required and Preferred Actions

To find the version of your current driver, open the Windows Control Panel and browse to Programs > Programs and Features. Find your driver in the list and check its version in the Version column.

ODBC Driver Version

Required Actions

Additional Information

Windows ODBC Driver 7.20.54

Upgrade to Windows ODBC driver version 7.20.55. If you are using a DSN-less connection, you should add a path to the newly introduced ca3.cer certificate to the Truststore parameter in your connection string.

For more information, see Downloading and Installing the ODBC Driver for Windows and Connecting Using a Connection String.

Linux ODBC Driver 7.20.50

Upgrade to Linux ODBC driver version 7.20.51. If you are using a DSN-less connection, you should add a path to the newly introduced ca3.cer certificate to the Truststore parameter in your connection string .

For more information, see Downloading and Installing the ODBC Driver for Linux and Connecting Using a Connection String.

JDBC or ADO.NET Driver Version

Preferred Actions

Additional Information

JDBC Driver 7.20.50

Verify truststore certificates.

If the required certificates are present, no action is required. If the certificates are not present, you must add them manually. For more information, see Authentication Using Server Certificates for JDBC.

ADO.NET Driver 7.20.50

Verify truststore certificates.

If the required certificates are present, no action is required. If the certificates are not present, you must add them manually. For more information, see Authentication Using Server Certificates for ADO.NET.

Verifying Certificates for JDBC and ADO.NET Drivers

Complete the following steps to check whether the required certificates are in your truststores. If the certificates are present, no further action is required. If they are not, you must install the certificates manually to avoid service interruptions.

Note:

The following paths and commands will vary, depending on your version of Java.

JDBC Drivers

  1. Open a command window.

    1. Click the Start icon on the Windows Taskbar.

    2. Type cmd.

    3. Press Enter.

  2. At the command prompt, type the file path for your Java bin directory.

    For example, "C:\Program Files\Java\jre1.8.0_144\bin".

  3. Press Enter.

  4. The command list for the Key and Certificate Management Tool is displayed.

  5. In Windows Explorer, go to the folder where your Java truststore certificates are stored.

    For example C:\Program Files\Java\jre1.8.0_144\lib\security.

  6. Copy the file path for the Java truststore certificates folder.

  7. In the command window, enter the following command where path is the file path for your Java truststore certificates folder:

    keytool -list -v -keystore “path\cacerts”

    For example,

    keytool -list -v -keystore “C:\Program Files\Java\jre1.8.0_144\lib\security\cacerts”

  8. Press Enter.

  9. In the command window, a list of keystore entries appears. An entry named digicertglobalrootca should be listed. If it is not, you must manually add the required certificates to your Java truststore. For more information, see Authentication Using Server Certificates for JDBC.

    Note:

    You might be required to enter a keystore password before the keystore entries are displayed. If you do not know the keystore password, contact your administrator.

ADO.NET Drivers

  1. On your Windows Start menu, type certmgr.msc in the search field.

  2. Press Enter.

  3. The Certificate Manager tool appears in a new window.

  4. Open the Trusted Root Certification Authorities> Certificates folder.

  5. The DigiCert Global Root CA certificate should be listed. If it is not, you can download the required certificates from the SuiteAnalytics Connect Driver Download page and manually add them to your Windows Trusted Root Certification Authorities store. For more information, see Authentication Using Server Certificates for ADO.NET.

Related Topics

General Notices