DataFlow Components in dotConnect for Salesforce 2.0!
November 2, 2012
Devart is glad to announce the release of dotConnect for Salesforce 2.0, Devart ADO.NET data provider for Salesforce.com and Database.com cloud databases! The new version 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 object 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.
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.
Download and try dotConnect for Salesforce now!
For detailed information on dotConnect for Salesforce please refer to the product pages. If you wish to provide feedback on the new version, you can do it in our forum or by e-mail. We are always glad to hear your comments and take into account your development needs.