twelvejie/pentaho-server-配置.md

## pentaho-server-配置.md

      
    Raw
  

              pentaho-server-配置.md
            
          
    pentaho server 9.4 安装和配置

官方文档

https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/9.4.x/mk-95pdia001/getting-started-with-pentaho-data-integration-and-analytics-installation

下载 pentaho-server-ce-9.4.0.0-343.zip

https://pentaho.com/download/#download-pentaho

安装与配置（使用postgres）


解压文件

unzip pentaho-server-ce-9.4.0.0-343.zip


更改sql文件中账号的默认密码 路径：pentaho-server/data/postgresql， 替换当前路径中所有的密码：sed -i 's/oldpass/newpass/g' *


create_jcr_postgresql.sql
create_quartz_postgresql.sql
create_repository_postgresql.sql
pentaho_mart_postgresql.sql


执行sql文件,在psql命令行执行

\i <your filepath>/data/postgresql/create_quartz_postgresql.sql
\i <your filepath>/data/postgresql/create_repository_postgresql.sql
\i <your filepath>/data/postgresql/create_jcr_postgresql.sql
\i <your filepath>/data/postgresql/pentaho_mart_postgresql.sql


这里使用pg数据库，更改数据库连，路径：pentaho-server/tomcat/webapps/pentaho/META-INF的文件，context.xml。

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/pentaho" docbase="webapps/pentaho/">
<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/hibernate?prepareThreshold=0" validationQuery="select 1" jdbcInterceptors="ConnectionState" defaultAutoCommit="true"/>
<Resource name="jdbc/Audit" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/hibernate?prepareThreshold=0" validationQuery="select 1" />
<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="pentaho_user" password="123@789" testOnBorrow="true" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/quartz?prepareThreshold=0" validationQuery="select 1"/>
<Resource name="jdbc/PDI_Operations_Mart" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/hibernate?prepareThreshold=0" validationQuery="select 1"/>
<Resource name="jdbc/pentaho_operations_mart" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/hibernate?prepareThreshold=0" validationQuery="select 1"/>
<Resource name="jdbc/live_logging_info" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="hibuser" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/hibernate?searchpath=pentaho_dilogs?prepareThreshold=0" validationQuery="select 1"/>
<Resource name="jdbc/jackrabbit" auth="Container" type="javax.sql.DataSource" factory="org.pentaho.di.core.database.util.DecryptingDataSourceFactory" maxActive="20" minIdle="0" maxIdle="5" initialSize="0" maxWait="10000" username="jcr_user" password="123@789" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://192.168.1.2:6432/jackrabbit?prepareThreshold=0" validationQuery="select 1" jdbcInterceptors="ConnectionState" defaultAutoCommit="true"/>
</Context>