Fetch Data From Remote Database Every Hour

Question

Yesterday i Download

• Pentaho BI Server
• Data Integration
• Report Designer

Than I connect report designer to the remote database and fetch table and draw chart of that data successfully. My Question is ,I want to run that file (which i create in report designing ) every hour by fetching the new data from remote database can you please guide me step by step how to do it because i am new in all those stuff.

Answer 1

I will answer My own Question. So In order to schedule Job in Data Integration You Have To Follow these Steps

Step 1: Create Transformation

Create Transformation which you want to run like in my case i fetch the data from database and than write it to file.

Step 2: Create Job

Create Job and run above transformation according to your desired interval

Answer 2

In Pentaho you would create a Transformation or a Job in Data Integration to fetch data from the remote database, and then use the report created with Report Designer to visualize the data that you have downloaded with Data Integration.