Marketing description

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. 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. 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.

Key selling points

• 60+ prebuilt SQL Server Integration Services (SSIS) components to accelerate ETL processes
• Optimized for SSIS to ensure fast performance of data-centric applications
• Connect to dozens of data sources, including REST-enabled sources
• Streamline many tedious data warehouse management tasks

Product features

• Dimension merge SCD transform
  A powerful replacement for the native Slowly Changing Dimension (SCD) Wizard in SSIS.
• Excel SSIS components
  Read data and write data to Excel and refresh your Excel Power BI queries and data.
• Fact table destination SSIS component
  Load data warehouse fact tables typically in a fraction of the time and with much less development work.
• Productivity components
  SSIS components designed to improve productivity and decrease development time.
• REST source and destination SSIS components
  Can be configured typically in minutes to more easily extract data from and write data to web or internal RESTful sources.
• Secure FTP (SFTP) task
  Send files to and from SFTP servers typically in minutes without writing a single line of code in SSIS.
• Social networking SSIS components
  Connect to social media sources such as Facebook, Twitter, and many others.
• SSIS connectivity
  Connect to dozens of data sources without writing a single line of code.