Pentaho


Helical Blog

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

Business Intelligence

Migrate Oracle with Pentaho

By Nikhilesh

Steps to migrate Oracle with Pentaho Step 1:- Run the 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...
  • 0