Devart Salesforce Source component allows querying data with both SOQL and SQL. It provides advanced visual editor with object tree, that displays all the Salesforce objects with their properties and allows users 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. 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, no need to create external id fields for parent objects.
Read more about dotConnect for Salesforce SSIS components (http://www.devart.com/
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.
Pricing and availability
Users' feedback helps Devart Team produce better products, so make sure to visit forum (http://www.devart.com/
Devart is a widely recognized provider of database connectivity solutions and developer tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite.
Since 1998, Devart has been focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Now, Devart solutions provide the fastest data access available on the market and the broadest database support to many thousands of industry professionals.
For additional information about Devart, visit the official web site. (http://www.devart.com/)