dotConnect for Salesforce is a solution for integrating data of the Salesforce.com cloud CRM and Database.com cloud database with widely used Microsoft data development technologies. It includes Entity Framework provider, ADO.NET provider, and offers Devart Salesforce Source and Destination components for SSIS packages. dotConnect for Salesforce offers local SQL engine, advanced data caching, and other enterprise level features.
* Powerful SQL Engine With dotConnect for Salesforce you don't need to learn complex Salesforce Web Services API - use your existing SQL knowledge. dotConnect for Salesforce has its own local SQL engine that allows you to use SQL-92 compatible SELECT statements to work with Salesforce Leads, Contacts, Opportunities, Accounts and other objects in the same way as with SQL tables. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with SOQL.
* Entity Framework Support dotConnect for Salesforce supports Entity Framework v1 and v4, which allows you to benefit from using LINQ to Entities, entity relations with lazy/eager loading. With Entity Framework you don't need to post each edited/created object separately - a single SaveChanges() call to persist all the changed objects. dotConnect for Salesforce goes with its own advanced visual Entity Framework model designer - Entity Developer.
* SSIS Data Flow Components Devart Salesforce Source component allows querying data with both SOQL and SQL in Integration Services packages. 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. SSIS DataFlow components are included into dotConnect for Salesforce Professional Edition and a new SSIS Edition.
* Microsoft SQL Server 2016 is supported in SSIS DataFlow components
Visual Studio 2017 is supported
The Readonly connection string parameter is added to allow only reading source data (only SELECT statements)
The new "Text Type" property displaying the text type of a column is added to column properties in the Devart Salesforce Source editor