TrustRadius Insights
dotConnect is a versatile and user-friendly tool that serves a variety of use cases for integrating databases into different projects. …
Starting at $169.95
View PricingOverview
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…
Recent Reviews
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
Product Details
- About
- Tech 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
Devart dotConnect Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows |
| Mobile Application | No |
| Supported Languages | English |
Comparisons
Compare with
Reviews and Ratings
(47)
Community Insights
TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!
- Business Problems Solved
- Pros
- Cons
- Recommendations
dotConnect is a versatile and user-friendly tool that serves a variety of use cases for integrating databases into different projects. ASP.NET web developers rely on dotConnect to seamlessly perform database operations in their web projects. Users appreciate its ability to handle massive loads, allowing them to easily perform updates, deletions, and view all fields of a table in SugarCRM.
With dotConnect, users can connect to multiple SQL databases, making it an ideal choice for learning analytics, data analysis, and creating charts or graphs for projects and presentations. Its compatibility with different operating systems, such as Windows and Mac OS, enables users to access servers from various platforms without any hassle.
In addition, dotConnect streamlines business processes by saving time. For example, users can directly print data from NetSuite without the need to download information first. This feature proves especially beneficial for enterprises looking to optimize their workflow.
One notable advantage of dotConnect is its versatility when it comes to integration with other applications. It seamlessly integrates with popular platforms like Mailchimp, allowing users to send mass emails as part of their marketing campaigns. Furthermore, dotConnect's wide range of drivers, including one phase/2 phase commit and compatibility for Oracle exadata, provides users with extensive options while performing data queries.
Overall, dotConnect offers programmers and software developers an efficient and straightforward solution for connecting their applications to databases. Whether it's building custom apps or retrieving data from different SQL servers, dotConnect proves to be a reliable and preferred tool in various industries ranging from healthcare enterprises to marketing departments.
Comprehensive ADO.NET Support: Many users have praised the software for its comprehensive support of ADO.NET features, including connected and disconnected models, membership, and various databases such as PostgreSQL, SQL Server, MySQL, Oracle, and others.
Direct Access to MySQL Server: Several reviewers have mentioned that the software provides direct access to the MySQL server with compatibility with the latest versions. They appreciate that it performs well in both connected and disconnected models.
Time-saving Features: Users have highlighted the time-saving features of the software. They mention that it allows for easy creation of reports and bulk data insertion into tables. This feature saves a significant amount of time when creating records in SugarCRM.
Delays in receiving support: Several users have expressed frustration with experiencing delays when seeking assistance from the tech support team. They have mentioned that it takes a considerable amount of time to get their queries addressed or issues resolved, which can be a hindrance to their workflow.
Occasional compatibility issues: Some users have reported encountering occasional compatibility issues with the software. These compatibility issues may arise when working with other applications or systems, causing disruptions and requiring additional effort to resolve.
Steep learning curve for non-technical users: Users who are not well-versed in SQL and table relationships have highlighted that there is a steep learning curve associated with using the software effectively. This poses challenges for those who are new to databases and database networks, as it requires them to acquire technical knowledge before being able to utilize all features optimally.
Based on user reviews, here are the most common recommendations for the program:
- The program is fairly inexpensive and user-friendly, so it's worth giving it a try for hassle-free connections to data.
- Users find the program relatively cheap and easy to use, with the added benefit of being able to send up to 1,000 emails in the free version.
- Users suggest using MailChimp for porting over existing customer lists and setting up mail templates. They also recommend checking the firewall and ensuring the environment allows for connection to the outside world. It is advised to review the documentation and utilize additional online resources for better understanding and troubleshooting.
Reviews
(1-2 of 2)Companies can't remove reviews or game the system. Here's why
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
- Low-cost product for basic connectivity features
- Allows us to deliver applications for clients that requires MySQL as a database
- Allows us keep using our development tools and IDE due to integration capabilities (mainly Visual Studio)
- Easy to use
January 02, 2019
dotConnect: Easy to Use with Client-Friendly Reporting
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.
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
- Immediately positive due to it's being pretty straightforward to install for every level of database staff
- Immediately positive due to its extremely client-friendly reporting
- It can be slow, so we have learned to always check the FW first as a rule-out.
We had been using an outsourced company for such projects until we decided to hire our own team and do all of this DB work in-house. So this was our first year of experience with this product. So far, we're very pleased, as are our clients.