Integration with Hadoop for Report Analytics

[pdjakk_snow]

Hi All,

We are planning to Integrate Service now with Hadoop. We are able to extract delta data on a daily basis for few tables based on the updated dates.

We also need to extract few configuration tables like SLA definition and Metric defintion etc..

But challange is we are not able to extract delta data for configuraiton tables delta as records in these tables created in the dev instance and when migrated into production it will still have develoment created/updated dates. Hadoop extraction will not be able to capture these as updated dates is before 24 hours.

I am looking for the best approach to be followed for integating Service now with Hadoop.

Any suggestion? Thanks

Regards,

Prashant Jakkani

[Arnoud Kooi]

Maybe you can force a update on DEV right before you extract?

var gr = new GlideRecord('your_table');
gr.addEncodedQuery('');
gr.query();
while(gr.next()) {
   gr.setForceUpdate(true);
   gr.update();
}

[ofaura]

Hello Prashant,

I have a customer that is very interested on integrating ServiceNow and Hadoop. Please, can you share how you have done it? Is your integration based on export sets? If not, what mechanisms are in place?

Thanks in advance,