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