向pentaho design studio添加jdbc驱动程序并配置数据源 [英] Adding a jdbc driver to pentaho design studio and configuring the datasource

问题描述

我刚刚将pentaho的设计工作室集成到BI服务器中.有谁知道如何添加mysql jdbc驱动程序.我需要连接以便定义关系操作过程. 在我的研究中，我发现:

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:

http://wiki.bizcubed.com.au/xwiki/bin/view/Pentaho%20Tutorial/Install%20Pentaho%20Design%20Studio#Comments

，它指定选择 JDBC驱动程序，编辑"，首选项"中的额外类路径"，但不存在此类首选项，

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

这导致我创建了一个jdbc文件夹，在其中将驱动程序放置在plugins\org.pentaho.designstudio.editors.actionsequence_4.0.0.stable\lib\中 但是就像该主题的作者一样，我被困住了

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

建议: 3.如果使用的是Pentaho DesignStudio，则必须将jdbc(JAR文件)复制到plugins目录(在pentaho插件中)，以便开发，部署和运行应用程序.这也适用于eclipse插件(如果您现在拥有Eclipse). 这导致我将jar文件放在插件目录中毫无用处.

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.

http://forums.pentaho.com/showthread.php?53715-Can-t-add-new-datasource-GA-version&highlight=add+jdbc+driver+to+design+工作室 谈论目录rdw不存在

http://forums.pentaho.com/showthread.php?53715-Can-t-add-new-datasource-GA-version&highlight=add+jdbc+driver+to+design+studio talks of a directory, rdw which does not exist

任何形式的协助将不胜感激.

Any form of assistance will be greatly appreciated.

推荐答案

您必须通过在Pentaho Design Studio中向.xaction中添加关系流程操作来配置数据源，您可以在其中指定JDBC驱动程序，用户名，密码和数据库URL.但是首先，您必须将MySQL JAR文件放入lib文件夹/path/to/biserver-ce/tomcat/lib

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

您还必须将*.xaction文件保存在pentaho-solutions文件夹/path/to/biserver-ce/pentaho-solutions中，以使*.xaction文件连接到在关系过程操作"中分配的数据库.

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.

这篇关于向pentaho design studio添加jdbc驱动程序并配置数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！