Microsoft’s ADF Automates Data Movement & Transformation Without Coding

In the world of data and technology, unorganised data ends up in relational, non-relational and other storage systems. But raw data does not have a content appropriate enough to provide with relevant, important information that the people in the data science team can grasp and learn from.

Microsoft Azure Data Factory (ADF) is a cloud-based data integration platform to solve issues like this regarding data. It is managed by cloud service that’s built for complex data integration projects.

Subscribe to our Newsletter

Join our editors every weekday evening as they steer you through the most significant news of the day, introduce you to fresh perspectives, and provide unexpected moments of joy
Your newsletter subscriptions are subject to AIM Privacy Policy and Terms and Conditions.

What Is ADF?

Data Flow is a feature of ADF that allows you to develop graphical data transformation logic that can be executed as activities within ADF pipelines. The objective of data flows is to provide a visual experience without needing the need of writing a code. It allows the development of graphical data transformation logic that can be executed as activities within ADF pipelines. ADF can handle large data in rapid succession and can handle all the code translation, spark optimization and execution of transformation in Data Flows.

The important feature is that the user does not have to write any line of code. An entire business logic can be designed from scratch using Data Flow UX and appropriate code in Scala will be prepared.  Behind the scenes, the ADF JSON code is converted to the appropriate code in the Scala programming language. After the code, it is compiled and executed in Azure DataBricks. So the data science team gets enough time to engage in important contributions like data cleaning, aggregation, data preparation and build code-free dataflow pipelines.

ADF enables the creation of data-driven workflows for the purpose of data automation and transformation. It can be used to create and schedule data pipelines that can take data from different data stores. It can transform the data with the help of Azure HDInsight Hadoop, Spark, Azure Data Lake Analytics and Azure Machine Learning services. It supports a variety of processing services like Data Lake Analytics and Hadoop.

No Need To Code

ADF uses Azure DataBricks as the compute for the data transformations built. It has activities to invoke Azure Databricks as a control flow component. These activities involve calling a Python file, a Juptyer Notebook or using some compiled Scala in a Jar file. These three options all requires the user to write either Python or Scala to process the data. With ADF data flow, the JSON output from the graphic ADF-DF user interface is used to write the Scala, which gets compiled into the Jar file and passed to Azure Databricks to execute as a job on a given cluster.

ADF Features

The V2 feature of ADF is a data integration tool. The tool is used in the cloud to provide coordination of both data movement and activity dispatch. With its data flow, ADF has become a genuine cloud replacement for SSIS. It has helped with an easy movement of massive amounts of data with Azure and has an on-premise data movement. It can dispatch activities for data transformation via scripting or using the custom mode.

Because no code is needed to be written, the user can can now perform data transformation, code-free, scaled-out on DataBricks, without leaving the ADF browser-based UI. Every data flow that you create are reusable entities that can be executed in many different pipelines and in multiple activities.

Advantages Of Data Flow

  • Data flow provides a GUI-dependant solution with no need of coding, which means that the user gets to build the solution by using drag-and-drop features of the ADF interface to perform data cleaning, data preparation and data aggregation.
  • Because of this feature, developing the ETL and ELT solutions will be easy to maintain.
  • The implementation of Spark in ADF dataflows allows for a high speed transformation run.
Disha Misal
Found a way to Data Science and AI though her fascination for Technology. Likes to read, watch football and has an enourmous amount affection for Astrophysics.

Download our Mobile App

MachineHack | AI Hackathons, Coding & Learning

Host Hackathons & Recruit Great Data Talent!

AIMResearch Pioneering advanced AI market research

With a decade of experience under our belt, we are transforming how businesses use AI & data-driven insights to succeed.

The Gold Standard for Recognizing Excellence in Data Science and Tech Workplaces

With Best Firm Certification, you can effortlessly delve into the minds of your employees, unveil invaluable perspectives, and gain distinguished acclaim for fostering an exceptional company culture.

AIM Leaders Council

World’s Biggest Community Exclusively For Senior Executives In Data Science And Analytics.

3 Ways to Join our Community

Telegram group

Discover special offers, top stories, upcoming events, and more.

Discord Server

Stay Connected with a larger ecosystem of data science and ML Professionals

Subscribe to our Daily newsletter

Get our daily awesome stories & videos in your inbox