Databases
StackOverflow2013
Postsdbo
POAdding a jdbc driver to pentaho design studio and configuring the datasource
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAdding a jdbc driver to pentaho design studio and configuring the datasource
    text
    copied!<p>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:</p> <p><a href="http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho%20Tutorial/Install%20Pentaho%20Design%20Studio#Comments" rel="nofollow">http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho%20Tutorial/Install%20Pentaho%20Design%20Studio#Comments</a></p> <p>which specifies selecting JDBC Driver, Edit, Extra Class Path from Preferences but no such preference exists,</p> <p><a href="http://forums.pentaho.com/showthread.php?85148-Design-Studio-xaction-database-connection-dropdown-list-empty&amp;highlight=add+jdbc+driver+to+design+studio" rel="nofollow">http://forums.pentaho.com/showthread.php?85148-Design-Studio-xaction-database-connection-dropdown-list-empty&amp;highlight=add+jdbc+driver+to+design+studio</a></p> <p>which resulted in me creating a jdbc folder in which I placed the drivers in <code>plugins\org.pentaho.designstudio.editors.actionsequence_4.0.0.stable\lib\</code> but just as the author of the thread I'm stuck</p> <p><a href="http://forums.pentaho.com/showthread.php?53303-Create-a-new-datasource&amp;highlight=add+jdbc+driver+to+design+studio" rel="nofollow">http://forums.pentaho.com/showthread.php?53303-Create-a-new-datasource&amp;highlight=add+jdbc+driver+to+design+studio</a></p> <p>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.</p> <p><a href="http://forums.pentaho.com/showthread.php?53715-Can-t-add-new-datasource-GA-version&amp;highlight=add+jdbc+driver+to+design+studio" rel="nofollow">http://forums.pentaho.com/showthread.php?53715-Can-t-add-new-datasource-GA-version&amp;highlight=add+jdbc+driver+to+design+studio</a> talks of a directory, rdw which does not exist</p> <p>Any form of assistance will be greatly appreciated.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload