Devart SSIS Data Flow Components for Salesforce allow you to integrate Salesforce data with cloud applications and databases via SQL Server Integration Services (SSIS).Devart SSIS Data Flow Components for Salesforce include Source, Destination, and Lookup components along with Devart Salesforce Connection Manager.
Devart Salesforce Source
Devart Salesforce Source provides convenient editor which allow you to quickly create a query to the data source. It displays data source metadata and variables list, and allow previewing the queried data. Devart Salesforce Source allows using SQL select statements to query data from Salesforce even though Salesforce does not support SQL natively. No need to study Salesforce API to integrate your data.
Devart Salesforce Lookup
Devart Salesforce Lookup component offer advanced two-level] performance optimizations. They check incoming rows for matches in batches and] cache the data returned from a lookup object in order to provide the highest possible performance.
Devart Salesforce Destination
Devart Salesforce Destination support not only the standard Insert operations, but also Update, Upsert, and Delete.
