Light BulbRecently Microsoft announced that Azure Data Factory moved out of public preview and is now generally available.  This is big news, as Azure Data Factory (ADF) is one of the key building blocks in the Cortana Analytics Suite.

ADF is a cloud-based data integration and orchestration service.  It acts as the glue connecting many of the other Azure data services allowing for the development of highly available data-flow pipelines that are capable of ingesting, transforming, analyzing, and even publishing data and insights.  These pipelines can be developed, scheduled, and monitored all from within an intuitive interface within the Azure Portal.


One of the key features of ADF is the diversity of data sources and compute activities it supports.  The service is capable of connecting to a host of on-premises data sources including SQL Server, Oracle, MySQL, and Teradata.  It also seamlessly integrates with Azure data sources including Azure SQL Database, Azure DocumentDB, and Azure Blob Storage.  Once data is ingested into a pipeline, it can be processed and transformed by a variety of services including active or on-demand HDInsight clusters with Pig and Hive, stored procedures hosted on Azure SQL Database, and even Azure Machine Learning for predictive processing.

ADF going into general availability leaves only a handful of services from the Cortana Analytics Suite that are not publicly available (Data Catalog, SQL Data Warehouse, and Data Lake).  This means clients can begin taking advantage of these services today, ahead of the formal release of the Cortana Analytics Suite later this year.

Keep an eye on 3Cloud’s blog for upcoming articles, technical presentations and how-tos for Azure Data Factory, as well as the business problems and use cases the service can help bring value to.

Want to learn how Azure Data Factory and the rest of the upcoming Cortana Analytics Suite might help your company transform data into insights?  Reach out to the 3Cloud team today.