1

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.

Muhammad Younas
  • 1,543
  • 1
  • 22
  • 32

2 Answers2

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

Muhammad Younas
  • 1,543
  • 1
  • 22
  • 32
0

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.

bolav
  • 6,938
  • 2
  • 18
  • 42
  • Jobln or Job there is no such type of option called Jobln what will be the best method to fetch data job or transformation – Muhammad Younas Mar 24 '16 at 07:28
  • sorry. Typo. The best method will depend on your data. Check the FAQ: http://wiki.pentaho.com/display/EAI/Beginners+FAQ#BeginnersFAQ-What%27sthedifferencebetweentransformationsandjobs%3F – bolav Mar 24 '16 at 07:31
  • thanks dear link help me is it possible that i send data from DI to RD file and than it genrate report automatically – Muhammad Younas Mar 24 '16 at 07:34
  • What you normally do is to store the data locally, in a dataware house/database and then connect RD to that. – bolav Mar 24 '16 at 07:41
  • i want to fetch data from server every hour than create the report of that data – Muhammad Younas Mar 24 '16 at 07:43
  • I successfully connected the database and fetch data the problem is how to do job scheduling and how to send receive data to report desiging file to create report – Muhammad Younas Mar 24 '16 at 07:45
  • For scheduling, either use Pentaho's scheduler, or use cron to schedule the job. For report design file you need to put the data somewhere it can find and use the data. – bolav Mar 24 '16 at 07:55
  • i think cron on server side i want to use local machine for that – Muhammad Younas Mar 24 '16 at 08:54
  • I also want to do the same thing on schedule basis but i want that report to send via email as attachment prefer PDF not zip file. can you please help me how to do – Dhrumil Shah Sep 25 '17 at 10:05