What users are saying about
33 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.3 out of 100
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.2 out of 100

Likelihood to Recommend

Devart ODBC Driver for Oracle

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.
Charanya Rajagopalan | TrustRadius Reviewer

IBM Informix

  • Like most RDBMS servers, Informix is strong in OLTP so it is a good choice for any high volume transaction systems including retail, banking, online gambling, etc.
  • Because its memory and storage footprints are relatively small and its installation footprint can be adjusted by deselecting unneeded features during installation, and also in large part to the autonomic tuning features of Informix, it is ideal for embedded systems and is used as the embedded database engine for several mainstream products in telecommunications, environmental management, and similar systems.
  • Its ability to integrate timeseries data with relational data make it ideal for monitoring and for the analytical processing of time oriented data such as utility supply, weather tracking, logistics and warehouse management, etc.
  • Informix's support for JSON/BSON data types and for the MongoDB API and wire listener protocol, in addition to the extensions Informix adds to the MongoDB API to support relational data, generic SQL statements, and multi-step transactions make it an ideal drop in replacement for MongoDB and other document oriented databases when application requirements exceed the capabilities and performance characteristics of these NoSQL database systems.
  • The Informix Warehouse Accelerator (IWA) feature of the Informix Advanced Enterprise Edition can accelerate data warehouse queries several hundred times over the speed of the base Informix and other RDBMS servers. In addition, IWA provides this acceleration with no modifications to applications and analytical tools and without the need to create additional indexes, cubes, or pre-calculated summary tables. Further, queries accelerated with IWA do not affect the performance of simpler queries running in the base Informix engine allowing IWA to provide an analytical query engine on top of a operational data store without complex ETL/ELT data migrations/conversions.
Art S. Kagel | TrustRadius Reviewer

Feature Rating Comparison

Database Development

Devart ODBC Driver for Oracle
7.6
IBM Informix
Version control tools
Devart ODBC Driver for Oracle
7.0
IBM Informix
Test data generation
Devart ODBC Driver for Oracle
7.0
IBM Informix
Performance optimization tools
Devart ODBC Driver for Oracle
8.0
IBM Informix
Schema maintenance
Devart ODBC Driver for Oracle
8.0
IBM Informix
Database change management
Devart ODBC Driver for Oracle
8.0
IBM Informix

Database Administration

Devart ODBC Driver for Oracle
7.3
IBM Informix
User management
Devart ODBC Driver for Oracle
7.0
IBM Informix
Database security
Devart ODBC Driver for Oracle
7.0
IBM Informix
Database status reporting
Devart ODBC Driver for Oracle
7.0
IBM Informix
Change management
Devart ODBC Driver for Oracle
8.0
IBM Informix

Pros

Devart ODBC Driver for Oracle

  • Performance.
  • Reliable.
  • Deployment.
Anonymous | TrustRadius Reviewer

IBM Informix

  • Informix since its conception has a distinct multi-threading architecture no other engine has, it is unique of its kind. This is precisely how the engine is able to scale up like no other, with the lowest footprint, without killing the host and profiting each bit of the hardware. The threads are sub-proceses like any other one, but the difference is that they are are not controlled by the OS process dispatcher. This is why you will never be able to see these threads running at OS level. Informix is an OS itself, on top of the OS.
  • Informix has the best replication techniques. Not many ppl know that MongoDB (the NoSQL engine) scales out because of its data sharding replication technology, and Informix is able to store Mongo BSON documents using the same data partitioning as MongoDB does. This way Informix extends the SQL or structured data with the unstructured data natively, together within the same data repository. This means that it is not only able to store JSON/BSON documents, but the engine is able to behave as it would be the MongoDB engine itself. Any application using MongoDB can be redirected to the Informix Mongo wire listener transparently. What´s more, it also improves the NoSQL (BASE) characteristic, making it ACID by allowing transactions to the CRUD operations. This last is something MongoDB is working on, promised to be delivered next year.
  • As described previously, MongoDB's sharding concept relies on data partitioning, this is how it scales out, and as I also described previously Informix scales up given the described multithreading unique architecture! It implements the data sharding with one of its best replication technologies called Enterprise Replication. This is an Active-Active replication technology that allows replicating even between different platforms. This is actually how I managed to migrate the whole Informix platform from Solaris to Linux, with just a DNS change. There was almost ZERO downtime nor application change - this was really amazing!.
Andrés Repossi | TrustRadius Reviewer

Cons

Devart ODBC Driver for Oracle

  • 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.
Charanya Rajagopalan | TrustRadius Reviewer

IBM Informix

  • The name of Informix is almost invisible on the market, which is very frustrating. This give the feeling that IBM is not interested in Informix without providing any reasons for why IBM makes no effort to sell Informix.
  • The pricing policy is very complex
Eric Vercelletto | TrustRadius Reviewer

Likelihood to Renew

Devart ODBC Driver for Oracle

No score
No answers yet
No answers on this topic

IBM Informix

IBM Informix 10.0
Based on 1 answer
Informix is the best RDBMS on the market. Period.
Art S. Kagel | TrustRadius Reviewer

Usability

Devart ODBC Driver for Oracle

No score
No answers yet
No answers on this topic

IBM Informix

IBM Informix 10.0
Based on 1 answer
Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.
Art S. Kagel | TrustRadius Reviewer

Support Rating

Devart ODBC Driver for Oracle

Devart ODBC Driver for Oracle 6.0
Based on 1 answer
Support has been great so far but still, it could be better.
Anonymous | TrustRadius Reviewer

IBM Informix

IBM Informix 10.0
Based on 1 answer
The Informix product support team has won awards and is appreciated by the entire Informix user community.
Art S. Kagel | TrustRadius Reviewer

Alternatives Considered

Devart ODBC Driver for Oracle

Devart is more feature rich and the direct connectivity to the DB beats out the tool provided by easysoft. We tested both of the software with the freeware version on a trial project. The project team gave a demo of both the tools to the project owner and development manger. Devart got the votes even though it was a little costlier than easysoft.
Charanya Rajagopalan | TrustRadius Reviewer

IBM Informix

You could use any other relational database, but they will be either expensive to maintain or won't scale as much.
Jean Georges Perrin | TrustRadius Reviewer

Return on Investment

Devart ODBC Driver for Oracle

  • Performance of the transactions has improved.
  • It meets our business objectives.
Anonymous | TrustRadius Reviewer

IBM Informix

  • As I have explained earlier, Informix has had along the past 15 years, the lowest number of vulnerability defects reported in NVD. Informix allows you to disregard the vulnerability defects, and spend your time building and growing your business instead of wasting it in patching and fixing every quarter! This to me is the best example I can empirically prove that Informix is definitely one of the best return of investment and so that any CDO or CIO should pay attention at the time to consider what platform to chose, to build on top!
  • The other return of investment any CDO or CIO should pay attention to, is the number of DBAs a DB platform should be required to support it! Informix with the SELF-everything, is getting chosen by companies as the best suited engine given its low footprint and little maintenance to get it embedded in their hardware.
  • Given its uptime and minimum planned outages Informix allows you to have, it is yet another reason Informix is not means an investment and not a money waste!
Andrés Repossi | TrustRadius Reviewer

Screenshots

Devart ODBC Driver for Oracle

IBM Informix

Pricing Details

Devart ODBC Driver for Oracle

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

IBM Informix

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

Devart ODBC Driver for Oracle
7.0
IBM Informix
9.5

Likelihood to Renew

Devart ODBC Driver for Oracle
IBM Informix
10.0

Usability

Devart ODBC Driver for Oracle
IBM Informix
10.0

Support Rating

Devart ODBC Driver for Oracle
6.0
IBM Informix
10.0

Add comparison