DBArtisan vs. Devart ODBC Driver

DBArtisan is excellent for large institutions with multiple mission-critical databases. It works especially well for cross-platforms RDBMS support. I am mostly familiar with Oracle, but less familiar with SQL Server and Sybase. So I certainly appreciate having a similar interface that allows me to manage those less familiar RDBMS, as this will mean a smaller learning curve. DBArtisan is mostly for DBAs, it is not suitable for developers, I believe the vendor has a separate tool for that

Incentivized

We are using it mainly for automation. We are using HP Quality Center as our automation tool and started using Devart ODBC for connectivity to Oracle DB. We have a lot of queries in our scripts that make several connections to the db for a particular user scenario. Devart ODBC has improved the overall runtime needed for the scripts.

Incentivized

• The free trial offer was great for me to test the software before purchasing it.
• It monitors queries well and shows resource allocation, as well as detailed stats for each running query.

Incentivized

• It is available for variety of OSs like Windows, Mac, Linux, etc.
• Speed of data transfer is great.
• It supports SSH and SSL.
• It supports HTTPS tunneling.
• Almost no connection failures makes it very reliable.
• It is available for 32-bit and 64-bit both.

Incentivized

• DBArtisan lacks a utility that does schema or object comparisons, which is a feature in Toad. I find this useful in some situations where I need to find out all differences between Prod and QA for a given schema, for example. DBArtisan doesn't seem to have the capacity to do this.
• I wish there was a way for the tool to warn me before performing a long-running task. For example if I want to re-organize a large table or rebuild an index for a table with millions of rows, it should warn me before executing it, so that I may choose to do it in a different way. Sometimes if I let these long operations run for too long, it freezes the program and crashes DBArtisan. I would rather run it on the DB server, and run it in background so that it doesn't time out, if DBArtisan gave me a warning before execution.
• Idera has taken over Embarcadero. I never heard of or dealt with Idera for support. I don't know if they have same the quality support as before.

Incentivized

• It would be good if the connection details are stored on the cloud based on the user login so that even if the software is corrupted, it can be pulled in automatically from the cloud upon reinstallation.
• It would great if video demos were available for the key features of the tool. That would make it a lot simpler for the user when using it the first time.
• User friendliness can be improved.

Incentivized

I have never tried their support so the number above is meaningless

Incentivized

Support has been great so far but still, it could be better.

Incentivized

DBArtisan does not have an in-depth performance analyzer for databases.

Incentivized

Devart Driver ODBC for MySQL is best with no known issues. It is stand-alone. It supports SSH/SSL communication. supports HTTP / HTTPS tunneling. It is available for a variety of operating systems like Windows, Mac, and Linux. It is available for 32-bit and 64-bit environments. It supports all renowned programming languages. it supports multiple languages. It allows various data types.

Incentivized

• While it is expensive, it saves us a great deal of time in getting a lot of DB work done.
• The front end is reasonably powerful and significantly more polished than any of the free alternatives

Incentivized

• Performance of the transactions has improved.
• It meets our business objectives.

Incentivized