Verify the ODBC driver whether it supports the Community Edition(Optional)

Prerequisites:

· Install the MySQL Community Server and Client.

· Create a user and a database for test

· Install the informatica powercenter client.

Configure the DSN and test the connection

· Double click Control Panel\All Control Panel Items\Administrative Tools\ Data Sources (ODBC)
and then configure an ODBC Data Source Name (DSN) Using the MySQL ODBC Driver shipped with informatica.

· Fill out the DSN, and test the connection, if it shows a warning message like the following figure, that means you should read this document, otherwise, Close the document and sip tea.

Download the MySQL Community ODBC Driver and Upload it to Powercenter Server

Download

· You should download the ODBC Driver from MySQL Website. Here is the download link http://dev.mysql.com/downloads/connector/odbc/

· Select platform

· Download the Compressed TAR Archive

Upload

· Decompress the tar Archive and then you will find the libraries in the lib folder.

· Upload the libmyodbc5a.so (for ASCII) and libmyodbc5w.so (for Unicode) to the $INFA_HOME/ODBC6.1/lib folder (please make sure that file names are unique to other files.)

· Change the owner(same with the powercenter service owner) and permission(644)

Configure the $ODBCINI and $ODBCINST files

Attention

Please don’t copy and paste directly;
The Driver is completely accurate;
Set DriverUnicodeType to 1 when the codepage is Unicode
Set Charset to utf8 when the codepage is Unicode, otherwise some characters such as Chinese are garbled.