ADO.NET Provider for Salesforce with Entity Framework and SSIS Support
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.
Key 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 – v6 and Entity Framework Core, 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.
