The Microsoft ODBC Data Source Administrator is used by DB2 to create an ODBC DSN.
Select Windows for the Operating System and 64 bit for the version.
Under ODBC and JDBC Drivers, select the ODBC driver download for your environment (Hive or Impala).
To install on Linux, follow these instructions to download the driver, put it in the correct location, and set the appropriate permissions. We recommend that you install the latest MySQL 8.0 driver. If you don't have the MySQL driver installed, you can get it from the MySQL website. UsageCount=1 Īlibaba Data Lake Analytics for MySQL uses MySQL drivers. After you install the driver, add entries similar to these to the /etc/odbcinst.ini file, if they're not already there:.
For more information, see the Security Bulletin. Note: We strongly recommend that you upgrade to the latest MySQL ODBC driver because it contains fixes for an outdated OpenSSL library and other vulnerabilities.
Note: You must install iODBC before you install the MySQL ODBC connector. You can get the latest version (mxkozzz.dmg) from the website or download the file directly. Install the iODBC Driver Manager, if it's not already installed on your Mac.If you don't have MySQL drivers installed, follow the steps to install the Mac driver for MySQL. Note: The name of the MemSQL connector was changed to SingleStore beginning with Tableau version 2021.1.
Reference Materials Toggle sub-navigation.Teams and Organizations Toggle sub-navigation.