Task Factory 2018.3 Delivers Support for Azure Data Factory and Cloud Data

John Welch

Published On: August 10, 2018

Categories: Cloud, Azure, Azure Data Factory, Task Factory 0

Task Factory 2018.3 extends the toolbox for SQL Server Integration Services (SSIS) by providing high-performance SSIS components that now connect to Amazon S3, Microsoft Azure storage accounts, and Azure Data Factory (ADF). Rather than having to write custom code, you can save time with Task Factory components and tasks.

Let’s take a closer look at some of these new connectivity features, which address specific business scenarios as well as data warehousing and other back-end operations.

Amazon S3 and Microsoft Azure Connectivity

Task Factory 2018.3 includes Amazon S3 connectivity so that you can pull information out of or push information to Amazon S3 using SSIS. This release also provides the same functionality for Microsoft Azure Storage.

Task Factory for Azure Data Factory

Support for running SSIS packages in ADF is relatively new; Microsoft introduced SSIS support in ADF as a preview at the end of 2017 and released it to production this year. ADF is a cloud-based data integration tool. SSIS has always been an on-premises data integration pool. This new support allows you to lift and shift your SSIS packages to run in the cloud on ADF.

Task Factory now supports installation and setup in the ADF SSIS Integration Runtime (IR). The same SSIS packages that you're currently running on-premises that use Task Factory can run in ADF—no package modifications are required. This support enables you to move SSIS processes to the cloud without giving up the enhancements to SSIS that Task Factory offers.

Setting Up ADF to Use Task Factory

There are some steps you need to take when you are setting up your ADF cluster to ensure Task Factory is available and can run properly. For instructions on how to create an Azure SSIS IR and install Task Factory during the startup process of the IR, please visit sentryone.com/products/task-factory/feature/azure-data-factory-edition-ssis/install-activate.

To learn more about deploying SSIS packages with Task Factory to Azure Data Factory, check out our on-demand webinar "SSIS in the Cloud: How to Read and Write to the Cloud with Task Factory to Azure Data Factory."

John Welch is the Chief Technology Officer at SentryOne, where he leads a team in the development of a suite of data and BI products that make monitoring, building, testing, and documenting data solutions faster and more efficient. John has been working with data, business intelligence, and data warehousing technologies since 2001. He was awarded as a Microsoft Most Valued Professional (MVP) 2009 - 2016 due to his commitment to sharing his knowledge with the IT community, and is an SSAS Maestro. John is an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), SQL Bits, and others. He has also contributed to multiple books on SQL Server and business intelligence.