BI Application System

Actuate Birt iHub

Download trail version from http://www.actuate.com/resources/product-downloads/#ihub

After install in CentOS, you may have all the items in <iHub Installation Path>/modules/BIRTiHub

1. Start ihub system:

#cd <iHub Installation Path>/modules/BIRTiHub

#./startPostgreSQL.sh

#./startiHub.sh

2. Stop ihub system:

#cd <iHub Installation Path>/modules/BIRTiHub

#./stopiHub.sh

#./stopPostgreSQL.sh

3. log path: <iHub Installation Path>/modules/BIRTiHub/iHub/data/server/log

4. Need oracle connection, put oracle drive file ojdbc6.jar into folder

<ihub installation path>/modules/BIRTiHub/iHub/jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_4.4.0.v20150710-0101/drivers

Reportserver

1. Install the download exe file into Tomcat application;

2. Create schema in database and run the script to create related tables in it.

3. Start the tomcat service and visit URL http://<HOSTNAME>/reportserver

4. Add jar file into E:\Tomcat\webapps\reportserver\WEB-INF\lib

5. Upload the birt report through web application

Birt

1. Copy birt.war file into Tomcat application;

2. Visit URLhttp://<HOSTNAME>/birt/

3. Copy the design file into birt application folder

4. Using the link to trigger the report

http://<HOSTNAME>/birt/frameset?__report=MembNonmemb.rptdesign

SpagoBI + Oracle11g

Database

1. Create tablespace spagobi

2. Create user spagobi

3. Download scripts from http://forge.ow2.org/project/showfiles.php?group_id=204

4. Change scripts ORA_create.sql remove the blank line for the first table create script

5. Create all objects using the script

Application

1. unzip the All-In-One-SpagoBI-5.1-21012015.zip

2, Rename package to SpagoBI

3. Change the configuration file

A. /u01/SpagoBI/conf/server.xml

Remove following context

     <Resource name="jdbc/spagobi" auth="Container"

          type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver"

          url="jdbc:hsqldb:file:${catalina.base}/database/spagobi"

          username="sa" password="" maxActive="20" maxIdle="10"

          maxWait="-1"/>

   <Resource name="jdbc/foodmart" auth="Container"

          type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver"

          url="jdbc:hsqldb:hsql://localhost:9001/foodmart"

          username="sa" password="" maxActive="20" maxIdle="10"

          maxWait="-1" validationQuery="select 1 from INFORMATION_SCHEMA.SYSTEM_USERS"

      removeAbandoned="true" removeAbandonedTimeout="3600"/>

    <Resource name="jdbc/bam" auth="Container"

          type="javax.sql.DataSource" driverClassName="org.hsqldb.jdbcDriver"

          url="jdbc:hsqldb:file:${catalina.base}/database/bam"

          username="sa" password="" maxActive="20" maxIdle="10"

          maxWait="-1"/>

Add Following context

     <Resource name="jdbc/spagobi" auth="Container"

          type="oracle.jdbc.pool.OracleDataSource" 

          driverClassName="oracle.jdbc.driver.OracleDriver"

          url="jdbc:oracle:thin:@127.0.0.1:1521:DWHS"

          factory="oracle.jdbc.pool.OracleDataSourceFactory"

          user="spagobi" 

          password="spagobi" 

          maxActive="20" 

          maxIdle="10"

          maxWait="-1"/>

Change from 

<Environment name="spagobi_service_url" type="java.lang.String" value="http://localhost:8080/SpagoBI"/>

<Environment name="spagobi_host_url" type="java.lang.String" value="http://localhost:8080"/>

to

<Environment name="spagobi_service_url" type="java.lang.String" value="http://<HOSTNAME>:8080/SpagoBI"/>

<Environment name="spagobi_host_url" type="java.lang.String" value="http://<HOSTNAME>:8080"/>

B. /u01/SpagoBI/webapps/SpagoBI/META-INF/context.xml

Change the total context to

<Context docBase="SpagoBIProject" path="/SpagoBI" reloadable="true" source="org.eclipse.jst.j2ee.server:SpagoBIProject">

        <ResourceLink global="jdbc/spagobi" name="jdbc/spagobi" type="oracle.jdbc.pool.OracleDataSource"/>

        <ResourceLink global="spagobi_resource_path" name="spagobi_resource_path" type="java.lang.String"/>

        <ResourceLink global="spagobi_sso_class" name="spagobi_sso_class" type="java.lang.String"/>

        <ResourceLink global="spagobi_host_url" name="spagobi_host_url" type="java.lang.String"/>

        <ResourceLink global="wm/SpagoWorkManager" name="wm/SpagoWorkManager" type="jcommonj.work.WorkManager"/>

</Context>

C. /u01/SpagoBI/webapps/SpagoBI/WEB-INF/classes/hibernate.cfg.xml

Change from

<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>

to

<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>

D./u01/SpagoBI/webapps/SpagoBI/WEB-INF/classes/jbpm.hibernate.cfg.xml

Change from

<property name="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>

to

<property name="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property>

E. /u01/SpagoBI/webapps/SpagoBI/WEB-INF/classes/quartz.properties 

Change from

org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.HSQLDBDelegate

to

org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate

4. Set environment parameter

#vim /etc/profile.d/tomcat.sh

export CATALINA_HOME=/u01/SpagoBI

export PATH=$CATALINA_HOME/bin:$PATH

#. /etc/profile.d/tomcat.sh

5. Start the Tomcat service

catalina.sh start

6. Change the log in /u01/SpagoBI/logs to monitor the status

#tail -f /u01/SpagoBI/logs/catalina.out

7. Login to url

http://<HOSTNAME>:8080/SpagoBI