pentahopentaho-cdepentaho-spoonpentaho-ctools

Fetch Data From Remote Database Every Hour


Yesterday i Download

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.


Solution

  • 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