Azure Data Factory Resources

Using JSON data in Data Factory

Transforming JSON to CSV with the help of Flatten task in Azure Data Factory

Transform/transpose/flatten your JSON structure into a denormalized flatten datasets that you can upload into a new or existing flat database table.

How to read files on SharePoint Online using Azure Data Factory. Organizations that have moved to Office 365, maintain few key data points on excel files/SharePoint Lists stored in SharePoint Online. If the situation demands you to analyze these data points, it has to be consumed to a database or a data lake.

Azure Data Factory Pipeline Email Notification – Part 1. When building ETL pipelines, you typically want to notify someone when something goes wrong (or when everything has finished successfully). Usually this is done by sending an e-mail to the support team or someone else who is responsible for the ETL. But in Azure Data Factory there’s no built-in activity for sending an e-mail. Here is an implementation using the Web Activity and an Azure Logic App.

Craig Robert Shenton, PhD

Azure Data Factory Resources

Using JSON data in Data Factory