Devart ODBC Driver vs. Sequel Pro

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

• Super easy for quick development and investigation
• The interface of exporting tables to SQL can be made better, it's not easy to manually check
• Not suitable for designing your DB
• Connections over SSH to vagrant and Docker hosted DBs
• Auto suggestion can be better

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

• Editing existing data. Editing record contents is trivial in Sequel Pro, while not nearly as easy in MySQL Workbench or phpMyAdmin.
• Deleting data - even simpler than editing data.
• Inserting new data - using "Duplicate row" then making needed changes is very simple.

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

• Improving the way we create new connections to remote databases
• I couldn't find any way to configure my local server (MySQL), so I need to make changes on server outside the application. I know that there are other tools that integrate it, so you don’t have to leave the workflow
• It could have a feature to integrate our databases or connections (favorites) with other devices, like using Google Drive or Dropbox. It would be really useful!

Incentivized

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

Incentivized

It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.

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

MySQL workbench is good to work with MySQL databases, but Sequel Pro gives us the ability to work with any SQL databases. It's open-source, lightweight and solves the problem that I am required to solve to run the DDL and DML queries.

Incentivized

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

Incentivized

• Unreliability has lead to wasted time and frustration among staff.
• The ease of testing database changes and modifying test data WHEN IT WORKS theoretically makes testing quick and easy but in reality, this is far outweighed by the wasted time and frustration involved with it not being reliable.
• The ease of seeing the relations between tables is very nice and saves time when trying to see how unfamiliar tables are connected.

Incentivized