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
The following is a list of BetterTesters who Advocate for this application. Do you want to be a BetterTester? Find out how!
Nobody is currently advocating this application. Now would be a good time to sign up.
How to Install CrossOver to run dotConnect for Salesforce
Click the Download Free Trial button above and get a 14-day, fully-functional trial of CrossOver. After you've downloaded CrossOver check out our YouTube tutorial video to the left, or visit the CrossOver Mac walkthrough for specific steps. Once you have CrossOver installed and running you can come back to this page and click the Step 2 button, or follow the manual installation guide, to begin installing your Windows application.
Click the Download Free Trial button above and get a 14-day, fully-functional trial of CrossOver. After you've downloaded CrossOver check out our YouTube tutorial video to the left, or visit the CrossOver Linux walkthrough for specific steps. Once you have CrossOver installed and running you can come back to this page and click the Step 2 button, or follow the manual installation guide, to begin installing your Windows application.
We're rebels. We're misfits. But mostly, we're software liberators. And we're very, very good at what we do. We have to be. Lots of developers work with open source, but only a tiny fraction of those are good enough to get software that was designed for one platform to work on another one. We invented CrossOver software - a unique approach to cross-platform compatibility that does not require dual-boot or another OS license. We launched PortJump to help app and game developers broaden their market beyond Windows® users. And we launched ExecMode to help organizations solve really ugly technical challenges.