adding a jdbc driver to pentaho design studio and configuring the datasource

adding a jdbc driver to pentaho design studio and configuring the datasource  using -'jdbc,driver,pentaho'

I've just integrated pentaho's design studio into the BI server. Does anyone know how to add mysql jdbc drivers. I need to connect in order to define the relational action process.
In my research I found:

which specifies selecting
JDBC Driver, Edit, Extra Class Path from Preferences but no such preference exists,

which resulted in me creating a jdbc folder in which I placed the drivers in plugins\org.pentaho.designstudio.editors.actionsequence_4.0.0.stable\lib\
but just as the author of the thread I'm stuck

suggests that:
3. If you are using the Pentaho DesignStudio you have to copy your jdbc (JAR files) to the plugins directory (in pentaho plugin) so you can develop, deploy and run your applications. This apply also to eclipse plugin (If you have now an Eclipse).
Which resulted in me placing the jar files in the plugin directory to no avail.
    talks of a directory, rdw which does not exist

Any form of assistance will be greatly appreciated.

asked Oct 19, 2015 by mtabakade
0 votes

2 Answers

0 votes

You have to configure the datasource by adding a Relational Process Action to your .xaction in the Pentaho Design Studio wherein you can specify the JDBC Driver, Username, Password and the Database URL. But first you have to put your MySQL JAR file in your lib folder /path/to/biserver-ce/tomcat/lib

You will also have to save your *.xaction file/s in the pentaho-solutions folder /path/to/biserver-ce/pentaho-solutions in order for your *.xaction files to connect to the database which you have assigned in your Relational Process Action.

answered Oct 19, 2015 by deepak07.s
0 votes

I encountered the same problem and solved as follow

  1. place mysql-connector-java-5.1.17.jar under (bi server path)\tomcat\lib\ folder
  2. start Pentaho Admin Console (PAC) with

    user: admin
    password: password

    and add a connection there

  3. use the name of the connection just created for action sequence as JNDI

The problem solved for me.

answered Oct 19, 2015 by rolvyrf