Steps to migrate oracle with pentaho

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 code:- <config-file>system/hibernate/oracle10g.hibernate.cfg.xml</config-file> oracle10g.hibernate.cfg.xml:- Location:- pentaho-solutions\system\hibernate\ oracle10g.hibernate.cfg.xml Do not need to change any code in this …Read More

Insert file contents into the database using Talend

Insert file contents into the database using Talend There was a requirement to read a dynamically generated text file and put its contents inside the database which could be MySQL, Postgres or SQL server etc. In Talend you can’t change components, metadata and connections seamlessly from one database to another. Talend have provided independent component …Read More

Using MDX Query in Pentaho CDE

This blog will talk about Using MDX Query in Pentaho CDE In Layout Section: Design the layout of your Dashboard, from scratch or from a template – while defining the layout you can apply styles and add HTML elements as text or images. In Component Section: In side Component layout we are using different types …Read More

ETL JOB FOR DOWNLOADING AND UNTARING TAR FILE FROM FTP

  ETL JOB FOR DOWNLOADING AND UNTARING TAR FILE FROM FTP 1. To Download File from FTP , we first have to create connection by providing all credentials of FTP Server (Host-URl, Username, Password, Port No and which type of connection it is like FTP or SFTP)component Name : tFTPConnection 2. Then Next Task is …Read More

Reading multiple properties files in spring 3 web MVC

Reading multiple properties files in spring 3 web MVC Spring allows us to externalize string literals in its context configuration files into external properties files, in order to separate application specific settings from framework specific configuration. Spring will read all the properties files declared by PropertyPlaceholderConfigurer bean to resolve the placeholders at application’s start up …Read More

Define JNDI for Pentaho BA server 5.0

Define JNDI for Pentaho BA server 5.0 Note: For illustration I’m showing Oracle 11g configuration. Replace the Resource name, username, password, driverClassName, and url parameters, or any relevant connection settings. Add Driver Place appropriate driver for Oracle 11g which is ojdbc6-11.2.0.2.jar to this directory for the BA Server: /pentaho/server/biserver-ee/tomcat/lib/. Note: There should be only one …Read More

PhantomJS and its “Render” function

PhantomJS – The Headless Webkit browser & its “Render” function In this blog, we will have a quick introduction of PhantomJS and talk about its “Screen Capture” feature to render webpages or parts of webpages into images or PDFs. PhantomJS is a headless browser which has a JavaScript API. It can be used for headless …Read More

Generating Jasper reports in different formats using a JSON file as a Data Source

This article helps the reader how to fill a report with data from a JSON data source ( Generating Jasper reports in different formats using a JSON file as a Data Source ). JSON stands for Java Script Object Notation. Suppose that we have a file in the following format. The above file consists of …Read More

KPI used by Ecommerce Companies in Business Intelligence

Keeping a tab of KPI is a very good exercise and can help entrepreneurs in understanding the current state of business and the way forward.The general KPI used by Ecommerce companies are listed below (ofcourse there could be variations and a lot will also depend on the companies business goal as well). These KPI, in …Read More