Recently, I have the opportunity to work on a project where I needed to extract large amounts of content from Sitecore and store it in the Database for additional processing. This task typically requires custom development, but as we move to the SaaS world, I started to look at other alternatives. One possibility was to use Azure ADF V2 to ETL Sitecore content. This approach allowed me to copy content from Sitecore to Azure Stores without writing any code or provisioning new infrastructure.

In this blog, I’ll focus on demonstrating data extraction from Sitecore to any common cloud-based data source. I will not be covering advanced topics, such as pagination and data integrity(both can be implemented, though ), but rather, I’ll cover a simple way to integrate ADF with Sitecore. Please reach out to me if you have any questions on these advanced topics.

In the core of my solution is Sitecore Item service and Azure ADF V2 REST linked service. I’ll be relying on Azure Integration runtime to create a secure channel for pulling data from my Sitecore instance. Thanks to the hard work of Azure and Sitecore engineers, I don’t really need to configure any infrastructure components or to write any code to integrate ADF with Sitecore.

Let’s take a look at this video tutorial: