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