Configuring SSL for MySQL Connector in Cloud Data Integration

Configuring SSL for MySQL Connector in Cloud Data Integration

Install the MySQL ODBC Driver on Linux

Install the MySQL ODBC Driver on Linux

Before you can configure SSL for the MySQL connection, you must install the MySQL ODBC driver version 8.0.12 on the Secure Agent machine.
  1. Click on the following link to download the MySQL ODBC driver: https://downloads.mysql.com/archives/c-odbc/
  2. Select the
    Product Version
    as
    8.0.12
    .
    Informatica recommends that you use the MySQL ODBC driver version 8.0.12.
  3. Select the
    Operating System
    as
    Linux- Generic
    .
  4. Select the
    OS Version
    as
    All
    .
  5. Download the
    Linux - Generic (glibc 2.12) (x86, 64-bit)
    file.
  6. Extract the downloaded file to a local directory in your system.
    When you extract the file, ensure that you copy all files from the downloaded driver package.
  7. In the Secure Agent installation directory, edit the
    odbcinst.ini
    file, and add the following values:
    [MySQL ODBC 8.0 Unicode Driver] Description = ODBC for MySQL Driver = <DRIVER_INSTALL_FILEPATH>/lib/libmyodbc8w.so Setup = <DRIVER_INSTALL_FILEPATH>/lib/libmyodbc8w.so FileUsage = 1
    In the Driver and Setup fields, you must specify the file path of the
    libmyodbc8w.so
    files that you extracted to the local directory in your system.

0 COMMENTS

We’d like to hear from you!