ServiceNow Integration with Azure data factory for incremental data extraction

Question

I am trying to create a pipeline in ADF where ServiceNow is a source and Azure blob storage is my target as and storing extracted files n json format.

I have to get only incremental data from SNOW and load that into blob storage. Please provide any suggestion to achieve this.

Answer 1

Hi @Kapil Ganweer ,

Welcome to Microsoft Q&A Platform. Thank you for posting your query here.

You need to use Lookup activities and Copy Activities with some watermark columns to achieve the same.

Below documentation explains incremental data copy in case of sql tables. Kindly follow same approach to accomplish your need.
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-portal

To know more above service now connector in Azure data factory Click here.

Hope this will help. Thank you.

-------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.