Profile picture for user pep82

 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

by Tobias Blickle
Posted on Tue, 11/17/2009 - 13:20

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:



For PPM 5:



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.




by Marco Bianchetti Author
Posted on Wed, 11/18/2009 - 16:12

 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



by Michael Lupp
Posted on Thu, 11/19/2009 - 14:55

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">




Start the CTK again and you will see the MySQL driver class in your data source.


Best regards,


by Marco Bianchetti Author
Posted on Tue, 11/24/2009 - 17:44

 Hi Michael,

it works! Thank you very much!



Featured achievement

Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan


icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock