Hi everybody,
I have a question about JDBC Datasources for Aris PPM (I'm using PPM 4.12).
I would like to create a JDBC connection to a MySQL database: has anybody ever tried?
I installed the MySQL JDBC driver on the server running PPM; how can I link this new JDBC connector to PPM? Creating a new Datasource in the Customizing Toolkit, I still can't select MySQL connector.
Thank you!
Marco Bianchetti
Hi Marco
you have to make the JDBC driver visible to JDBC extractor and CTK. To do so have to add the path to JDBC driver to following environment variables:
PPM 4.x:
PPM_CTK_CLASSPATH
PPM_JDBC2PPM_CLASSPATH
For PPM 5:
PPM5_CTK_CLASSPATH
PPM5_JDBC2PPM_CLASSPATH
After restarting the CTK you should see the driver. Please select "Other database type" as database type. Please be aware that using mySQL has not been tested and is not supported officially. However, there is a good chance that it will work.
Regards,
Tobias
Hi Tobias,
thank you very much for your answer.
I update the environment variables but I still cannot see the JDBC connector in the CTK (I mean, I cannot select any MySQL JDBC in the "Driver class for DB system" line in Datasource management menu).
Am I missing something?
Thanks again
Regards
Marco
Hi Marco,
you have to edit manually the XML file "..System.xml" contained in the directory of the data source. Create the new data source and select an arbitrary driver class. Then open the mentioned XML file and replace the driver class with the MySQL driver class:
<databasesettings name="TEST" dbtype="OTHER">
<driverclass>com.mysql.jdbc.Driver</driverclass>
...
Start the CTK again and you will see the MySQL driver class in your data source.
Best regards,
Michael
