向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:
,它指定选择 JDBC驱动程序,编辑",首选项"中的额外类路径",但不存在此类首选项,
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.
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屋!