Task Factory Feature: Salesforce Source and Destination SSIS Components 

Salesforce Source and Destination SSIS Connectors

The Salesforce Source and Destination SSIS components can be configured in just minutes to easily get data out of and write data to Salesforce.

Task Factory provides dozens of high-performance SSIS components, including Salesforce connectors, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.

 

Download Free Trial

Learn More About Task Factory Pricing

Task Factory Salesforce Module

Includes 3 Salesforce-specific components. Learn More

Task Factory

Includes 70+ high-performing SSIS components that help you efficiently manage ETL pipelines. Learn More

Task Factory Azure Data Factory 

Includes 65+ high-performing SSIS components that help you efficiently manage ETL pipelines in Azure Data Factory (ADF). Learn More

Salesforce.com SSIS Source

 

Task Factory SalesForce.com SSIS Source

The Task Factory Salesforce.com Source retrieves data from any Salesforce.com object and can be configured in seconds with very little SalesForce.com experience. If you need to import data from Salesforce for in-house processing, the Salesforce.com Source allows you to retrieve any data supported by the Salesforce.com Soap API like leads, accounts, contacts and opportunities right into your SSIS data flow.

Within 5 minutes, you’ll be pulling Salesforce data into your local environment. Simply create your connection manager and point to the object you want to retrieve data from a drop-down box. Want more advanced functionality? You can also customize the query and pass variables into the query for ranged retrieval of data.

Feature Highlights

  • Retrieve data from SalesForce.com custom or built-in objects using SSIS in minutes
  • Easily customize the SOQL query
  • Pass variables into the query to ask better questions of your data, like retrieve all the rows modified since the last load

Salesforce.com SSIS Destination

 

The Salesforce.com Destination is used to send data from your local environment to your Salesforce.com account. If you need to insert, update, delete, or upsert data into any Salesforce object from within SSIS, then the Salesforce.com Destination makes it super simple with very little configuration. Supports both regular and bulk mode transfer. You can also send errors that might occur due to your data to another part of the data flow for additional cleansing.

*Must have an enterprise Salesforce.com account to use this task. This is a Salesforce.com requirement.

Feature Highlights

  • Write data to SalesForce.com in bulk using SSIS
  • Delete data from SalesForce.com
  • Update and Upsert data into SalesForce.com
Task Factory Salesforce SSIS Destination

 

"The University of Calgary Data Warehouse consists of over two dozen data marts, built upon a decade's worth of ETL programming in IBM Cognos Data Manager. When support for that product ended and we investigated converting all ETL to SSIS, concerns were raised about performance and maintainability in the new toolset. Thus the decision was made to purchase Task Factory; I can say with confidence that halfway into the conversion effort, it has been one of our smartest and most cost-effective software acquisitions in recent memory."

—Gabriel Gray, University of Calgary

 

Task Factory Licensing Options

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.

Compare Editions

Task Factory Modules

Annual Subscription License

 

$425–$795

Per Server


Learn More

Choose from more than a dozen Task Factory modules, each of which delivers high-performance components targeted to a specific SSIS task.

Task Factory

Annual Subscription License

 

$1,245

Per Server
Includes annual maintenance

Buy

70+ SSIS tasks and components

Task Factory Azure Data Factory

Annual Subscription License

 

$1,495 

Per ADF Node

 
Buy

65+ SSIS tasks and components