Devart dotConnect

Devart dotConnect

About TrustRadius Scoring
Score 7.4 out of 100
Devart dotConnect

Overview

Recent Reviews

Read all reviews

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Devart dotConnect, and make your voice heard!

Pricing

View all pricing

Standard Edition

$169.95

On Premise

Professional Edition

$339.95

On Premise

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.devart.com/dotconnect/salesf…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Devart dotConnect?

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.


Devart dotConnect Features

  • Supported: Local SQL engine
  • Supported: Advanced data caching
  • Supported: 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.
  • Supported: 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.
  • Supported: SSIS Data Flow Components - Devart Salesforce Source component allows querying data with both SOQL and SQL in Integration Services packages.

Devart dotConnect Screenshots

Screenshot of

Devart dotConnect Integrations

  • Microsoft Visual Studio

Devart dotConnect Competitors

  • CData ADO.NET Data Provider for Salesforce
  • Progress DataDirect for Salesforce
  • Cozyroc for Salesforce

Devart dotConnect Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo
Supported LanguagesEnglish

Comparisons

View all alternatives

Reviews and Ratings

 (51)

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Vinicius Lima | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
dotConnect is a great product that allows us use MySQL with ADO.Net Entity Framework. Usually, SQL Server is considered when using ADO.Net but sometimes MySQL is desirable due to license costs and available functionallities. So, in that cases, our company uses dotConnect when programmers an analysts take the decision of using MySQL. Mainly, it is used integrated to Microsoft Visual Studio to develop Lightswitch based applications.
  • Supports several MySQL features, such as secure connections, SSH and HTTP tunneling.
  • Allows us to consider in our Lightswitch applications the most used relational database in the world
  • Implements Role, Session State, Membership, Profile and other ASP 2.0 providers (essential for Lightswitch applications)
  • Direct connections via TCP/IP to MySQL (no client libraries needed)
  • There is a free version (Express Edition) with basic but essential features
  • Better troubleshooting for errors in Visual Studio integration mode
  • Improvements in performance
  • Documentation could be better
dotConnect for MySQL is suitable if you work with .net technologies and frameworks to develop applications but do not want to use SQL Server. This is a very common scenario and the Express edition can solve this problem if you need only basic connectivity features. If high performance is a crucial requirement for you, it may be a real concern. Maybe paid editions can deliver better performance, but you will need to deal with relevant costs.
Jackie Bassett | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
We have used nearly every CRM out there. but Salesforce.com is the most popular amongst our F100 clients.
We also do a lot of data queries accessing different SQL servers. We needed an OBDC driver that was easy to use, easy to connect, and fast.

While dotConnect met two of the criteria very well, it's not fast, although it could be due to the other technologies involved in data queries: volume, FWs, etc.
  • Easy to use, client report-friendly
  • Easy integration when accessing multiple SQL servers on the client side
  • Pulls/connects easily from any application
  • Can be slow which may be more due to the many FW issues involved when accessing multiple SQL servers
  • While it was easy for us to use, a few of our client-side Database teams wanted something more robust
Most appropriate when running queries from the client side, as the installation is rather straightforward and reporting is quite transparent, clear, and supportive of decision-making. We have known some extremely seasoned data researchers who had found dotConnect not as sophisticated as they would have liked.