Connecting to MySQL Database using ODI
While working with Oracle Data integrator 11g and MySQL, we come across a strange situation where ODI does not provide any default JDBC connector (in-built). Though MySQL is shown up as one of the technologies in Topology Manager, but when user tries to establish a physical connection, there is no pre-defined connector available in ODI. Steps to connect to MySql ODI is a java based tool using JAR files to establish connection to different technologies. On similar grounds, we need to provide Java based driver file to it. Download MySQL JDBC connector MySQL JDBC connector is available on MySQL site for download. Download the MySQL Connector/J from following URL: http://dev.mysql.com/downloads/connector/j/ Unzip the downloaded Drivers Unzip the downloaded file. We will have the following set of files after unzip. In this example, we are using MySql drivers’ ver 5.1.17. Placing JAR file Place this JAR file in the following 2 locations: a. ...