To support MySQL database in the TDI, You first need to add mysql driver into the TDI
Here are the steps :
- Download and copy mysql (mysql-connector-java-5.1.23-bin.jar ) jar to the location "${IBM}\TDI\V7.1\jars\3rdparty\others" where IBM is your installation directory
- Restart TDI if it's running.
- Click on Add component under AssemblyLines and choose JDBC connector
- In JDBC URL, add “jdbc:mysql://<IP>:<PORT>/<DATABASE_NAME>”.
- in JDBC Driver, add com.mysql.jdbc.Driver
- Provider correct Username and Password of your database.
- Select table Name from select button.
- Click Finish to connect to the MySQL Database.
