What users are saying about
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
1150 Ratings
7 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.5 out of 101

Microsoft SQL Server

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
1150 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101

Likelihood to Recommend

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 profile photo

Microsoft SQL Server

With Microsoft SQL Server I can quickly develop a data storage solution for a .NET web application. The built in Visual Studio tool makes choosing Microsoft SQL Server an easy choice for getting up and running quickly. However it does require a large footprint, and would not be well suited for small applications where a NOSQL or static database solution would be more efficient.
No photo available

Pros

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 profile photo

Microsoft SQL Server

  • If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye
  • If you're just starting with relational databases, you would probably be fine with opting for an open source solution. However, if you need a solution that can handle an enormous number of requests and return results with considerable speed, SQL is worth researching to see if it fits your needs.
  • Managing database using SQL Server Management studio provides very good flexibility
No photo available

Cons

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 profile photo

Microsoft SQL Server

  • The latest implementation of SSIS does not work as well as the previous versions when it comes to importing datasets from Access or Excel files. Rather than using the datatypes in those source files, it tried to figure out the datatypes by looking at the first few columns. This has been frustrating for us.
  • It would be good if SQL Server came equipped code checking. We currently use SQL Enlight to ensure that our code meets certain standards.
No photo available

Likelihood to Renew

IBM Informix

IBM Informix 10.0
Based on 1 answer
Informix is the best RDBMS on the market. Period.
Art S. Kagel profile photo

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 5 answers
We are a Microsoft Gold partner and are very in depth with our SQL server development with out software and it would take too many resources to try and switch to another database product, not to mention all of our clients run SQL Server so we would then have to support SQL and another product which is fiscally irresponsible.
Bill Starling profile photo

Usability

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 profile photo

Microsoft SQL Server

Microsoft SQL Server 9.8
Based on 8 answers
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Andy Erickson profile photo

Reliability and Availability

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 1 answer
Its does not have outages.
Srikanth S profile photo

Performance

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
SSAS data cubes may some time slow down your Excel reports.
Srikanth S profile photo

Support

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 profile photo

Microsoft SQL Server

Microsoft SQL Server 8.8
Based on 18 answers
Support is a mixed bag. It works so well you really don't need support except for some edge cases. However, you also are going to be hiring experts in databases, specifically with SQL Server experience, in order to setup and maintain your product. Luckily, SQLServer has the largest user group and most responsive out of all technologies. You just need to put in the effort.
No photo available

In-Person Training

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
It was good
Srikanth S profile photo

Online Training

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
very hands on and detailed training
Srikanth S profile photo

Implementation

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.7
Based on 4 answers
As mentioned before, the implementation of SQL Server in a company that is beginning to use a new structure, which does not require any type of data migration, do not requires particular comment to make.
If you must to do a porting of databases from a different platform, definitely you need to consider the situation in detail depending on your needs.
Luca Campanelli profile photo

Alternatives Considered

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 profile photo

Microsoft SQL Server

Microsoft SQL is so much easier to use. Getting data in and out of the RDS was so difficult we stopped using it. Microsoft SQL Server was so much faster and user friendly that we exclusively move all new databases to these servers instead of using services like RDS. With RDS we had a familiar interface in that we could use Microsoft SQL Studio Manager to access it but there was just way too many restrictions that we don't have in Microsoft SQL Server
John Glenn profile photo

Scalability

IBM Informix

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
SQL server does handle growing demands of a mid sized company.
Srikanth S profile photo

Return on Investment

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 profile photo

Microsoft SQL Server

  • Our company's tools are based on SQL Server (mostly), so the name recognition and integration has certainly been useful to align with customer goals.
  • The easy integration of .NET tools has meant that we can easily build features for our systems without much effort on understanding APIs or connectivity.
  • The security integration with AD, and the Azure AD, means that we can extend our authentication to remote users without much effort or development time.
  • The costs of SQL Server have gone up over time, and these certainly impact ROI, especially for smaller applications.
  • I'm sure most platforms have bugs, and there are certainly some in SQL Server. The limited fixes or issues we've seen in a few cases of implementing certain database features have meant we needed to implement workarounds. We have also had some tuning issues with plan regressions, however these are likely to occur in many systems.
Steve Jones profile photo

Pricing Details

IBM Informix

General

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

Microsoft SQL Server

General

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

Add comparison