Export data from servicenow to Pentaho Kettle

zakbelgh
Kilo Explorer

‎07-18-2015 03:48 PM

Hello guys, I'm working on a BI project and I want to retrieve data from servicenow and load it to Pentaho Integration Services 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 to the data warehouse, someone knows how can I acheive my goal? Help me please

Labels:
0 Helpfuls
  • 2,262 Views
3 REPLIES 3

oswaldo
Kilo Contributor

‎03-02-2017 03:07 PM

Hello guys!



Currently I`m facing a similar scenario as Zakbelgh. @Zakbelgh, did you had success with SN ODBC driver? What was the solution to extract data from Service Now?



Is there any material considering best practices to extract data from service now for BI purpose?



Thanks,


Oswaldo


0 Helpfuls

chrisbons02
Kilo Explorer

‎12-14-2017 02:11 AM

  1. You need to set up an ETL job that incrementally loads data. That will require you to define a time-stamp 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.
0 Helpfuls