Devart is glad to announce the release of the new version of dotConnect for Salesforce, an ADO.NET provider for accessing data of the Salesforce.com cloud CRM and Database.com cloud database through the standard ADO.NET or Entity Framework interfaces. New dotConnect for Salesforce includes Devart Salesforce Source and Devart Salesforce Destination components for Integration Services packages to be used in data flows.
Devart Salesforce Source component allows querying data with both SOQL and SQL in Integration Services packages. It provides advanced visual editor with object tree, that displays all the Salesforce objects with their properties and allows you to just drag Salesforce to the query editor to create a query. The source component is able to query data with or without deleted records or system fields.
Devart Salesforce Destination component uses native bulk protocol for loading data in Integration Services packages. It supports all kinds of load operations - insert, update, delete, and upsert, and offers an advanced per-row error processing, creating an error output with Salesforce IDs of the records, loaded successfully, and error information columns for records that caused the error. It can insert related objects without modifying database, you won't need to create external id fields for parent objects.
Read more about dotConnect for Salesforce SSIS components...
SSIS DataFlow components are included into dotConnect for Salesforce Professional Edition and a new SSIS Edition. The new SSIS Edition includes only Devart Salesforce Source and Devart Salesforce Destination components along with Devart Salesforce Connection Manager, and can be used in Integration Services projects only.
Here is the complete list of dotConnect for Salesforce 2.0.2 features:
- SSIS DataFlow Source and Destination components for Salesforce are implemented
- The bug with availability of the Yes/No/Cancel options when saving models created with previous versions of Entity Developer is fixed