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/
JDBC URL: jdbc:mysql://<servername>:<port>