question

KapilGanweer-6432 avatar image
0 Votes"
KapilGanweer-6432 asked ShaikMaheer-MSFT commented

ServiceNow Integration with Azure data factory for incremental data extraction

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
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KapilGanweer-6432 ,

Following up to check is below provided answer helps you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you.

0 Votes 0 ·

Hi @KapilGanweer-6432 ,

Just checking is below provided answer helps you? If yes, Please Accept Answer. Accepting answer will help community too. Thank you.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered

Hi @KapilGanweer-6432 ,

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://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.