TrustRadius: an HG Insights company

Devart ODBC Driver

Score5.2 out of 10

58 Reviews and Ratings

What is Devart ODBC Driver?

Devart ODBC Driver for Oracle provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, both 32-bit and 64-bit. Its full support for standard ODBC API functions and data types implemented in their driver makes the interaction of database applications with Oracle faster, easier and handy.

Categories & Use Cases

Media

Top Performing Features

  • Version control tools

    Version control tools ensure code integrity is maintained in a team coding environment

    Category average: 7.9

  • Test data generation

    Generation of randomized or real-world test data

    Category average: 6.8

  • Performance optimization tools

    Performance optimization tools measure and maintain overall responsiveness and efficiency of queries, database structures, etc.

    Category average: 8.1

Areas for Improvement

  • Database security

    Security maintenance such as authorization management, log analysis, database auditing

    Category average: 8.2

  • Database status reporting

    Detailed reports on database performance, configuration, security, vulnerabilities, etc.

    Category average: 8.2

  • Change management

    Automated scripts for implementing database changes

    Category average: 7.8

The best ODBC Driver for MySQL

Use Cases and Deployment Scope

In my organization, it is being used for the connectivity of locally deployed data-entry applications to the database. It is enabling the application for two way data transportation. It is also being used for connectivity of another desktop application to the database that transports the new data and updates the amended data to the web database.

Pros

  • 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.

Cons

  • For each user, it is necessary to purchase a license.
  • Prices are still high.
  • Processing and delivery of license shall be instant.
  • How-to and FAQs about functionality seeks addition.

Return on Investment

  • Almost no connection failure occurs.
  • Fast data transportation.
  • No connectivity errors.
  • Stand-alone hence nothing else required in addition to function.

Alternatives Considered

Devart ODBC Driver for SQL Server and ODBC Driver for SQL Azure

Other Software Used

WhatsApp Business, Apache OpenOffice, MySQL

Hands on review by an automation tester

Pros

  • Far less connection failures. We had a lot of failures with the tool that we were using before.
  • High performance and new features are really useful. Direct mode connectivity seems to make the difference that was very much needed.
  • Works very well with Oracle Database 10g.

Cons

  • 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.

Return on Investment

  • Our organization has been largely moving into agile development life cycle and continuous integration is a key towards agile success. Automation is the first step towards continuous integration. We are really happy using Devart as a part of our automation engineering. It definitely contributes towards overall success.
  • We are trying to extend the usage. The development team has also shown interest towards the usage.
  • This is a cost effective tool. It is worth the price.

Other Software Used

IBM Rational Team Concert, Enterprise Single Sign-On Manager, IBM CICS

My experience with ODBC Driver

Pros

  • Performance.
  • Reliable.
  • Deployment.

Cons

  • User Interface could be better.
  • Error Messages and error handling could be improved to be more relevant and specific.
  • Availability.

Return on Investment

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