pentaho安装、启动、配置，数据库迁移MySQL
| pentaho | : | biserver-ce-5.4.0.1-130 | |||||||||||
| MYSQL | : | 5.7.11 | |||||||||||
| JDK | : | 1.7 | |||||||||||
| OS | : | win7 sp1 | |||||||||||
|
2.设置环境变量 |
|||||||||||
先看看成功启动之后的Server界面。
点任意一个[GO]就能登陆主页面了
| create_repository_mysql.sql | |||||||||||||||||||||||||||||||||
| 创建hibernate数据库，用于存储用户授权认证，solution repository以及数据源。 | |||||||||||||||||||||||||||||||||
| create_quartz_mysql.sql | |||||||||||||||||||||||||||||||||
| 为Quartz计划任务器创建资源库。 | |||||||||||||||||||||||||||||||||
| sampledata_mysql.sql | ||||||||||||||||||||
| 为sample数据添加pentaho所有基本的实例数据源。 | ||||||||||||||||||||
| # Thefully qualified Java class name of the JDBC driver to beused
datasource.driver.classname=com.mysql.jdbc.Driver
# Theconnection URL to be passed to our JDBC driver to establish aconnection datasource.url=jdbc:mysql://localhost:3306/hibernate
# Theconnection username to be passed to our JDBC driver to establish aconnection datasource.username=root
# Theconnection password to be passed to our JDBC driver to establish aconnection datasource.password=root
# The SQLquery that will be used to validate connections from this poolbefore returning them to the caller. # This querymust be an SELECT statement that returns at least onerow. # HSQLDB:SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS # MySQL, H2,MS-SQL, POSTGRESQL, SQLite: SELECT 1 # ORACLE:SELECT 1 FROM DUAL datasource.validation.query=SELECTUSER() |
| jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.MySQL5Dialect |
编辑
\biserver-ce\pentaho-solutions\system\hibernate\hibernate-settings.xml
| system/hibernate/mysql5.hibernate.cfg.xml |
编辑
\biserver-ce\pentaho-solutions\system\quartz\quartz.properties
放开注释
| org.quartz.jobStore.driverDelegateClass= org.quartz.impl.jdbcjobstore.StdJDBCDelegate |
编辑
\biserver-ce\pentaho-solutions\system\simple-jndi\jdbc.properties
| SampleData/type=javax.sql.DataSource
SampleData/driver=com.mysql.jdbc.Driver SampleData/url=jdbc:mysql://localhost:3306/sampledata SampleData/user=pentaho_user SampleData/password=password Hibernate/type=javax.sql.DataSource Hibernate/driver=com.mysql.jdbc.Driver Hibernate/url=jdbc:mysql://localhost:3306/hibernate Hibernate/user=hibuser Hibernate/password=password Quartz/type=javax.sql.DataSource Quartz/driver=com.mysql.jdbc.Driver Quartz/url=jdbc:mysql://localhost:3306/quartz Quartz/user=pentaho_user Quartz/password=password Shark/type=javax.sql.DataSource Shark/driver=com.mysql.jdbc.Driver Shark/url=jdbc:mysql://localhost:3306/shark Shark/user=sa Shark/password= SampleDataAdmin/type=javax.sql.DataSource SampleDataAdmin/driver=com.mysql.jdbc.Driver SampleDataAdmin/url=jdbc:mysql://localhost:3306/sampledata SampleDataAdmin/user=pentaho_admin SampleDataAdmin/password=password |
编辑
\biserver-ce\tomcat\webapps\pentaho\META-INF\context.xml
| <?xmlversion="1.0" encoding="UTF-8"?> <Contextpath="/pentaho"docbase="webapps/pentaho/"> <Resource name="jdbc/Hibernate" auth="Container"type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory"maxActive="20" maxIdle="5" maxWait="10000" username="hibuser"password="password" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate" validationQuery="select user()"/>
<Resource name="jdbc/Quartz"auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory"maxActive="20" maxIdle="5" maxWait="10000"username="pentaho_user" password="password" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz" validationQuery="selectuser()"/> </Context> |
删除
\biserver-ce\tomcat\conf\Catalina\localhost\pentaho.xml
因为每次重启pentaho会根据context.xml重建这个文件
停用默认的HSqlDB
\biserver-ce\tomcat\webapps\pentaho\WEB-INF\web.xml
注释掉
| <!-- [BEGIN HSQLDB DATABASES]--> <context-param> <param-name>hsqldb-databases</param-name> <param-value>[email protected]/../data/hsqldb/sampledata,[email protected]/../data/hsqldb/hibernate,[email protected]/../data/hsqldb/quartz</param-value> </context-param> <!-- [END HSQLDB DATABASES]--> <!-- [BEGIN HSQLDB STARTER]--> <listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class> </listener> <!-- [END HSQLDB STARTER]--> |
编辑
|
<context-param> <param-name>fully-qualified-server-url</param-name> <param-value>http://localhost:8080/pentaho/</param-value> </context-param> |
3.启动bi Server，打开浏览器，新建数据源
喜欢