informatica mysql odbc_Informatica MySQL ODBC Driver安装和配置

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 thenconfigure 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 linkhttp://dev.mysql.com/downloads/connector/odbc/