ServiceNow Integration with Azure data factory for incremental data extraction

Kapil Ganweer 1 Reputation point
2021-07-08T08:58:23.397+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,721 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 30,426 Reputation points Microsoft Employee
    2021-07-09T10:53:51.133+00:00

    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.