Helical Blog

Stay up to date with our most recent news & technical updates

Business Intelligence

Steps to migrate oracle with pentaho

By Nikhilesh

Step 1:- Run script as DB admin. Script is available in location:- biserver-ce\data\oracle10g. Modify configuration file:- applicationContext-spring-security-hibernate.properties. Location:- pentaho-solutions\system\applicationContext-spring-security-hibernate.properties. original code:- jdbc.driver=org.hsqldb.jdbcDriver jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.HSQLDialect Modified code:- dbc.driver=oracle.jdbc.OracleDriver jdbc.url=jdbc:oracle:thin:@localhost:1521/sysdba jdbc.username=hibuser jdbc.password=password hibernate.dialect=org.hibernate.dialect.Oracle10gDialect hibernate-settings.xml Location:- pentaho-solutions\system\hibernate\hibernate-settings.xml. Original code <config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file> Modified...
  • 0