dotConnect for Salesforce Reviews

7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.8 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Reviews (1-2 of 2)

Companies can't remove reviews or game the system. Here's why.
March 15, 2021
Sandarbh Asthana | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
Being a service provider, our company has to interact with our customers, and Salesforce is the best CRM out there to fulfill our needs. We needed to manage a lot of SQL Servers to contain our client's resources and internal resources and thus we required an ODBC driver, which was easy to use and maintain! Our company shortlisted dotConnect for Salesforce from LogicNets and Zoho, as being our primary database integration tool with Salesforce across our organization. Although being slow, dotConnect for Salesforce managed to handle our requirements easily and efficiently. As a provider and end-user, our overhead has reduced drastically in maintaining and managing multiple data sources. The integration and management of dotConnect for Salesforce with Visual Studio is the cherry on the top!
  • Provides powerful SQL engine integration out of the box.
  • Smooth integration and installation.
  • Create your data access layer without having to write any code.
  • Use same universal SQL statements without learning any new Salesforce APIs.
  • It can be slow but at the same time can be managed by considering other external factors like system compatibility, network & firewall issues.
  • Requires dependencies on certain tools and that may bring some unexpected compatibility errors.
  • Entity framework feature seems to be a bit lagging behind MS-SQL.
Scenarios best suited for dotConnect for Salesforce:
  • Mid or small-size companies with a very small team of staff can now easily manage their clients and their data.
  • The ease of deployment and consistency makes way for a more robust and reliable platform for the companies and their clients.
  • The use of cloud apps makes integration for companies easier to maintain, upgrade or install.
  • With the integration of SQL engine, hiring & training (if required) of new employees are easier.
Scenarios where dotConnect for Salesforce is less appropriate or not suited:
  • Companies working on another platform apart from Microsoft would have no option or find it hard to run and deploy dotConnect for Salesforce.
Read Sandarbh Asthana's full review
January 01, 2019
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.
Read Jackie Bassett's full review

dotConnect for Salesforce Scorecard Summary

What is dotConnect for Salesforce?

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.


Categories:  .Net Development

dotConnect for Salesforce Features

Has featureLocal SQL engine
Has featureAdvanced data caching
Has featureEntity 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.
Has featurePowerful 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.
Has featureSSIS Data Flow Components - Devart Salesforce Source component allows querying data with both SOQL and SQL in Integration Services packages.

dotConnect for Salesforce Screenshots

dotConnect for Salesforce Integrations

Microsoft Visual Studio

dotConnect for Salesforce Competitors

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

dotConnect for Salesforce Pricing

  • Has featureFree Trial Available?Yes
  • Does not have featureFree or Freemium Version Available?No
  • Does not have featurePremium Consulting/Integration Services Available?No
  • Entry-level set up fee?No
EditionPricing DetailsTerms
Standard Edition169.95
Professional Edition335.95

dotConnect for Salesforce Support Options

 Free VersionPaid Version
Live Chat
Email
Forum/Community
FAQ/Knowledgebase
Social Media

dotConnect for Salesforce Technical Details

Deployment Types:On-premise
Operating Systems: Windows
Mobile Application:No
Supported Languages: English