Thursday, June 28, 2007

Making Pentaho Design Studio connect to a MySQL database

It seems not easy to add another JDBC driver to the report wizard in Pentaho Design Studio.
Here's my recipe:
1- Copy the MySQL JDBC Driver (mysql-connector-java-5.0.4-bin.jar) in the folder %pentaho-design-studio%\plugins\org.pentaho.designstudio.editors.actionsequence_1.2.1.357-GA\rdw\lib\jdbc\
2- Create a JNDI entry in ..\org.pentaho.designstudio.editors.actionsequence_1.2.1.357-GA\rdw\resources\solutions\system\simple-jndi\jdbc.properties
Add these lines as an example:
GestionDemandesLocal/type=javax.sql.DataSource
GestionDemandesLocal/driver=com.mysql.jdbc.Driver
GestionDemandesLocal/url=jdbc:mysql://localhost:3306/gestiondemandesv4_dbo
GestionDemandesLocal/user=root
GestionDemandesLocal/password=bateau
3- Restart the Designer and you will ne able to access your MySQL database.
www.CInformatique.com

No comments: