Task Factory
Save time managing tedious data warehousing ELT/ETL tasks.
Save time on tedious ELT/ETL tasks
Do you find yourself asking…
Which data sources can I connect to with Task Factory?
Connect to dozens of different data sources from platforms such as SharePoint, Salesforce, Facebook, Twitter, and virtually any REST-enabled source without writing any code.
How can I increase productivity?
Development teams often face trade-offs between programming efficiency and application performance. With Task Factory, you can both eliminate needless programming of SSIS components and improve the efficiency of your data-centric applications in production. Productivity components include Secure FTP Task, data cleansing components such as the Null Handler, and more.
Can I improve performance on my data-centric applications with Task Factory?
Accelerate performance of your data-centric applications with Task Factory high-performance components, including the Upsert Destination, which speeds batch processing, and the Dimension Merge SCD, which is a high-performance replacement for the Slow Changing Dimension wizard in SSIS.
Can I manage and load data warehouses with Task Factory?
Accelerate the process of loading and managing data warehouses with Task Factory components such as Dimension Merge SCD Transform, which helps you load a slowly changing dimension in SSIS much faster than with built-in components. Task Factory streamlines many tedious data warehousing management tasks, including upserting data.
Which data sources can I connect to with Task Factory?
Connect to dozens of different data sources from platforms such as SharePoint, Salesforce, Facebook, Twitter, and virtually any REST-enabled source without writing any code.
Frequently Asked Questions
Task Factory is licensed per server instance, with the exception of clustered servers. Each cluster within a cluster group must have a Task Factory license.
Task Factory Azure Data Factory edition is licensed per Azure Data Factory node.
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.
Yes, but to continue using the Salesforce features, you must upgrade to the latest version of Task Factory.
- Microsoft Visual Studio
- Microsoft .NET Framework 4.5
- SQL Server Integration Services 2012, 2014, 2016, 2017, or 2019
- SQL Server Data Tools (SSDT) 2012, 2014, 2016 (for Visual Studio 2015), 2017 (for Visual Studio 2015 or 2017), or Visual Studio 2019
Task Factory includes dozens of components.
Yes, Task Factory components can be used with Azure databases.