CODEWITHSUNDEEP
pentahodata-warehousebusiness-intelligencekettleservicenow
Zakaria Belghiti
Zakaria Belghiti

Reputation: 551

Loading data regulary from ServiceNow to Pentaho Kettle

I'm working on a BI project and I want to retrieve data from ServiceNow and load it to Pentaho Data Integration so I can record it in my data warehouse, and I want to do this regulary, in other words I want to retrieve the new records regulary from servicenow , only the new ones that haven't been loaded yet to the data warehouse, someone knows how can I acheive my goal? Help me please

Upvotes: 1

Views: 837

Answers (1)

nsousa
nsousa

Reputation: 4544

The question is too vague.

  1. You need to set up an ETL job that incrementally loads data. That will require you to define a timestamp or incremental key to identify which records are more recent than the ones already loaded.

  2. You will need to schedule that job, e.g., using crontab and calling kitchen from the command line.

Your question pretty much translates to "please develop my ETL project". Too wide in scope.

Upvotes: 1

Related Questions