How to add MySQL component in the Tivoli Directory Intregator (TDI).

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.