As I did not found it somewhere documented, here are the instructions to connect Tivoli Directory Integrator (TDI) to a MYSQL database:
- Get the MySQL JDBC driver
- Copy the file “mysql-connector-java-5.1.22-bin.jar” (the version number may differ!) from the archive to “<TDI install directory\ jars\3rdparty\others”
- Restart TDI if it is already running
- In a TDI assembly line add a new component of type “Database Connectors (JDBC)”
- As “Database Type” select “JDBC”
- As “JDBC URL” use: “jdbc:mysql://<dbhostname>:<port>/<databasename>” (e.g. “jdbc:mysql://localhost:3306/test”)
- As “JDBC Driver” use “com.mysql.jdbc.Driver”
Now you should be able to successfully connect to your MySQL database.
Tivoli Directory Integrator: Connect to MySQL Database