Informix

Informix

(27)
4.6 out of 5 stars

Informix enables you to store, access and query all your data with first-rate efficiency and agility. Real-time analytics, always-on transactions and seamless data integration get you to answers faster and speed time to market. And with the exception of Informix Warehouse Accelerator, this database includes all Informix features on all supported platforms to provide you easier app development and deployment with unlimited scalability. Full grid and replication capabilities ensure always-on data access, and optional storage compression helps maximize resources.

Work for Informix?

Learning about Informix?

We can help you find the solution that fits you best.

Informix Reviews

Ask Informix a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 35 Informix reviews
LinkedIn Connections
Informix review by Kenny Alexander B.
Kenny Alexander B.
Validated Reviewer
Review Source

"My experience with Informix"

What do you like best?

Informix is a great engine. It's fairly straightforward to learn. I have taken 2 sysads and had them be effective at the end of a day of training. Always requires less headcount to support. As far as being able to take advantage of ALL system resources, Informix can do it. Have seen other db's hit limits, but not Informix. Also, the user community is very strong. Those who use Informix are usually very passionate about it and believe in it.

What do you dislike?

Although I have not installed a version 12 and above, installation was a little odd from time to time. It's serious software so it needs to be done correctly but IBM could do a better job there. SQL support can also be a little more up to date. The big editions can be pricey and powerful servers, even if you do not need all this power.

What business problems are you solving with the product? What benefits have you realized?

I have used it for mission-critical OLTP financial services and have found it very robust and stable.

Required minimum maintenance and uptime is great.

Provides multiple HA options/technologies

Sign in to G2 Crowd to see what your connections have to say about Informix
Informix review by Spokey W.
Spokey W.
Validated Reviewer
Verified Current User
Review Source

"Always a pleasure "

What do you like best?

I like the performance, the ease of use and maintenance and generally very talented and helpful support team. Setting it up is easy. Performance out of the box is great. Tuning it is very easy and the latest versions have outstanding diagnostics. It also has a remarkable feature set, especially if you look at the ease of a grid implementation compared to other vendors. And then there's the extensibility.

What do you dislike?

IBM does very little to market Informix. I can't blame them, they have thousands of software products, but it means the product has a lot less market awareness than it deserves. Security is a bit of a grey area, but it's no more of an issue than it is for any other vendor.

The documentation for TimeSeries is not up to par with the rest of the product set. The people designed and built the various DataBlades are some of the smartest people I know, sadly the documentation doesn't really get the rest of the world up to speed. I'd definitely recommend some consultancy if you're going to implement TimeSeries.

Recommendations to others considering the product

Do it. IBM's marketing is terrible, but the product is superb: easy to install and configure, easy to administer and incredibly powerful and fast.

What business problems are you solving with the product? What benefits have you realized?

Over the years, I've solved pretty much every kind of business problem, whether ERP, logistics, telco, retail, financial, medical... whatever, really. Lately I'm using Informix to help solve time series problems in the energy and utilities market.

Benefits include blistering performance, outstanding uptime, incredibly light-touch admin and integration with pretty much every development platform.

What Relational Databases solution do you use?

Thanks for letting us know!
Informix review by Administrator in Gambling & Casinos
Administrator in Gambling & Casinos
Validated Reviewer
Verified Current User
Review Source

"High volume OLTP database"

What do you like best?

We get direct support from IBM experts and are closer to the development team as a large customer that we would be if we ran Oracle or SQL Server, for example. We manage high OLTP volumes running a site turning over in excess of £1bn+ annually and the product is scalable and by and large very reliable. We find the replication and high availability features and are very good and priced very competitively compared to other offerings.

What do you dislike?

There could always be more features and a faster development roadmap. I am hoping that the new HCL partnership will go some way to address this.

What business problems are you solving with the product? What benefits have you realized?

It provides us with a reliable high-availability ACID-compliant database product capable of scaling to both large transaction volumes with databases 10s of Tbs. Amongst other things it has facilitated the rapid growth of our business.

Informix review by Peter M.
Peter M.
Validated Reviewer
Verified Current User
Review Source

"Extremely durable, powerful, reliable and fast db engine"

What do you like best?

Informix is a great engine. It's fairly straightforward to learn. I have taken 2 sysads and had them be effective at the end of a day of training. Always requires less headcount to support. As far as being able to take advantage of ALL system resources, Informix can do it. Have seen other db's hit limits, but not Informix. Also, the user community is very strong. Those who use Informix are usually very passionate about it and believe in it.

What do you dislike?

IBM seems to promote their db2 product line in all of their marketing. There aren't as many third party tools or commercial off the shelf software out there written to use Informix as the underlying db, which can be very frustrating.

Recommendations to others considering the product

I consider Informix to be the Humvee of the database world. It's extremely stable, powerful, and flexible. IBM has recently changed it's licensing/cost model to be a little more like Oracle in that there are extra pieces you can buy to enhance the experience (enterprise replication being one). The biggest knock against Informix is that no one outside of the existing user base seems to know it's still heavily used. Look on any job board, and you'll see at least a 10:1 ratio of any other db to informix. I've seen informix in use at numerous locations and the informix teams are always smaller and handling more activity. I've used MSSQL, Oracle, MySQL, and db2. I simply prefer Informix.

What business problems are you solving with the product? What benefits have you realized?

Have only used it for OLTP type activity. I can't speak to the warehousing aspect. For OLTP it can provide continuous uptime for many different types of applications.

Informix review by Art S. K.
Art S. K.
Validated Reviewer
Verified Current User
Review Source

"Informix. The best database. Period."

What do you like best?

Performance.

Features.

Innovation.

Reliability (5 9's++).

Zero unplanned downtime.

Best DR/HA features and performance.

Scalability both up and out.

Ease of maintenance and tuning.

Multiple workload capable (OLTP & Data Warehouse on the same server).

Relational and NoSQL capable.

Native REST access.

Informix offers six different types of data replication, distributed database, sharding, central master database, and other schemes for scaling and customizing the location and availability of your data. It offers load balancing tied to disaster recovery/high availability and the ability to very quickly bring additional servers online to handle unusual load. Data can be distributed and/or replicated across homogeneous or heterogeneous server farms. Server version upgrades can be applied to a cluster of servers while permitting users to connect to the database and continuously access their data with no downtime. Servers and client connections can be configured to guarantee that no transactions are lost, even if the primary server or its host goes offline. This combination of features ensures that Informix is always on and always available.

What do you dislike?

That IBM cannot manage to get over the fact that the best database system they sell was not originally invented at IBM.

Recommendations to others considering the product

Just do it. Informix users are all fanatical in their love for this database system.

What business problems are you solving with the product? What benefits have you realized?

Banking systems. Securities systems. Medical/health systems. Retail systems. Retail logistics systems. Retail warehouse systems. Manufacturing systems. Wholesale products systems. Data analytics systems.

Informix review by Eric V.
Eric V.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Best customer loyalty rate in the "for charge" area"

What do you like best?

* Reliability and stability: the identified record uptime is more than 6 years uptime

* Scalability: real multithread architecture allows smooth horizontal and vertical scalability

* Best rate for performance / hardware sizing: amazing performance level achieved with very moderate size hardware

* Best rate for staffing: no need for an army of DBA. Some companies handle 30,000+ informix servers with a team of 6 DBA's 24/7/365

* Replication functionality is very complete, although very simple to admin

* the Informix Warehouse Accelerator is a software appliance that you plug into Informix, that can turn BI/DS queries by 700+ times faster, with no necessity to rewrite the DS applications not replug them anywhere else

* Works great on ARM/Quark processors, making it a great asset for IOT

What do you dislike?

* Some of the SQL language is not yet as rich as other DBMS vendors

* IBM poorly promoting one of their best assets, although this is changing for better now

Recommendations to others considering the product

Informix has poor visibility on the market. Make your own idea with user companies and you will see that a company that uses Informix does not want anything else, when speaking on technical terms.

Best way to achieve to register to the International Informix User Group http://www.iiug.org and or attend the Annual IIUG Conference www.iiug2015.org

What business problems are you solving with the product? What benefits have you realized?

Speaking for customers in Health and Finance:

* reliabilty: server not shutdown since 20010

* staffing: 1/7 of a DBA for a 4000 users Informix system, 4 DBAs for smaller Oracle systems

* hardware: 4000 users working

* hybrid possibilities: Informix is ready for NoSQL and works better than MongoDB. My customer will

develop new applications in MongoDB client, accessing Informix Database Server, and mix SQL data with NoSQL data.

Informix review by Andrés R.
Andrés R.
Validated Reviewer
Review Source

"Informix is unfairly the unknown best data manager"

What do you like best?

To explain what I like best, I am going to refer to two aspects: A) NoSQL vs RDBMS and B) Freeware and Licensed Engines

A) Distributed data is based on replication, and data partitioning lets you not only to scale your overall performance up, but also improve availability. There are two streams, one that is based on Hadoop and the other one is based on Sharding, the first one requires a huge amount of disk space, another invisible cost, and that initially none is caring about, as the storage costs drops, no need to worry or concern about data duplication and wasting space. In addition to the space issue, it is that the data is open, and there are not many security tools yet to hide the data and secure it. I am not sure everyone shares or knows these things…, so again this is confronting people with different ways of thinking. On the other hand maintaining replication in Hadoop is not a plug and play thing, it also has its challenges and requires complex java scripting. At last if we use Hadoop we are going towards a NoSQL or unstructured DB, and again, this is where many people get confused with…, so why turning the wheel to the opposite direction!, whilst we can use distributed data implemented in RDBMS (sharding)…, we have to have in count that NoSQL sacrifies consistency mainly by a very bad space consumer optimistic locking method to avoid dealing with atomicity and isolation.

Definitely NoSQL can’t replace RDBMS, as the BASE model is for some specific use cases, and for companies that defined their own solutions no other in the market was able to do…, but at that time!, RDBMS have now also powered up their engines, and in one case have even started to integrate and improve the unstructured model integrating it with the structured one, in the same data repository combining the best of both worlds, this is keeping up with the performance and capacity, without scarifying consistency, atomicity and isolation at the same time!.

There’s just one company that understood this problem and started working in a new paradigm, and this is to support the unstructured data model together with the structured one. This company is IBM, and its powerful INFORMIX engine. In any of the scenarios, either if by sharding or doing data partitioning required to scale out horizontally, a database engine has needs a very strong replication technology.

INFORMIX deployment has been driven by its strengths in replication – Informix employs one of the industry’s most scalable and efficient replication architectures – and data management. It also combines strengths in embedded data management with low administrative overhead, highly effective use of server resources and enterprise-class resilience.

INFORMIX is oriented to solving the massive change that is occurring in computing environments around the world. Specifically, unstructured data is flooding into organizations and companies are struggling to choose between a relational or NoSQL database to handle it. While NoSQL offers the ability to have dynamic elasticity with data and its organization, these databases lack essential elements such as scalability, security, flexible deployment, transaction support and full data integration. INFORMIX offers a solution that can natively handle NoSQL and structured data simultaneously providing a single system with the seamless integration of all data within the enterprise. It is meant to help developers use native JSON and BSON data types as well as other NoSQL functions (including sharding) for complete plug-and-play compatibility with MongoDB and other NoSQL databases. Application developers can access structured and unstructured data in a single statement and join them together as needed. NoSQL applications can use the enterprise-level capabilities of a structured database system including transaction support, backup and recovery, H/A, compression, enhanced scalability, security and access control. All these last features are not minor and characteristic of any other NoSQL engine.

I think that the hybrid development capability of INFORMIX-NoSQL to manage and present both structured and structured data repositories, is going to be very important as organizations realize that 1) there is value in the new flexible schema paradigms like JSON, 2) existing apps can benefit from being able to present this data, 3) JSON based applications could benefit from access to the relational data that is already in the organization's relational databases, 4) NO new hires will be required to work in the NoSQL/JSON space, simplifying the complex, expensive, slow, and error prone daily ETL, from multiple data sources.

B) This is TCO (Total Cost Ownership). This is to do with how easy an engine is to be maintained, this is then to do with TBF (Time Between Failures) or unplanned downtime, and the much the technology allows you to avoid the downtime or plan downtime to reduce it. All this at the light of the incurring expenses to maintain it, support it vs licensing costs.

I always like to call these as DIRECT and INDIRECT COSTS.

DIRECT COSTS is very simple, it is represented by the licenses cost.

INDIRECT COSTS are the ones that NONE seems to sees, it is incredible!. This is why one platform needs more resources than others…, it is simple math, if a platform is all the time requiring an engineer to touch here, and there, today, next month again the same thing in the same place, in one word REDOING!. This is consuming most of te DBA time, that could be used to grow the business. If the DBA spends most of his time in recurrent fixes!..., then it is simple, another DBA is required. It is not just what we redo, but also what we can't do because we are stuck fixing. INDIRECT COSTS are invisible!, incredible, but real.

There are also many aspects to consider as INDIRECT COSTS, such as performance, capacity, how much an engine can do with it…, and I am talking about using the same h/w, same data, but how much it is able to process is key…, so HOW MUCH THE ENGINE CAN DO WITH LESS!.

What do you dislike?

The bad marketing there is around INFORMIX. I hate ppl when they talk about INFORMIX as an OLD technology.

Recommendations to others considering the product

Run a ROI and TCO, benchmark it, you'll love it.

What business problems are you solving with the product? What benefits have you realized?

-

Informix review by Grey P.
Grey P.
Validated Reviewer
Verified Current User
Review Source

"Informix"

What do you like best?

very good .. as it is a database management system very avansado data, and is one of the most popular. It is very fast and efficient

What do you dislike?

nothing dislike this manager .. everything is excellent .

Recommendations to others considering the product

100 % recommended for all who seek speed and confidence when making your BDD

What business problems are you solving with the product? What benefits have you realized?

many benefits with this manager as his fluency helped me build a database for my project it engineering

Informix review by Jean Georges P.
Jean Georges P.
Validated Reviewer
Review Source

"I don't like databases, I love Informix"

What do you like best?

During most of my career, I was involved with software projects and products. I was managing developers and system administrators. The reason we picked Informix was clearly because of its legendary & proven reliability, which brought an awesome TCO to the projects. I like that it follows the business needs: extensibility, XML, NoSQL, and now IoT. It really makes sense for me. I like that there are a lot of editions so it fits your needs pretty well.

What do you dislike?

Although I have not installed a version 12 and above, installation was a little odd from time to time. It's serious software so it needs to be done correctly but IBM could do a better job there. SQL support can also be a little more up to date. The big editions can be pricey and powerful servers, even if you do not need all this power.

Recommendations to others considering the product

The community is one of the biggest asset of Informix, discover the community on the IIUG web site at http://www.iiug.org and through its yearly conference.

What business problems are you solving with the product? What benefits have you realized?

The benefits iInformix brought is mainly a great TCO.

Informix review by Omer Saeed K.
Omer Saeed K.
Validated Reviewer
Verified Current User
Review Source

"I have loved working with Informix, I think it has all the necessary features and very stable"

What do you like best?

High availability is great (HDR, RSS, Connection Manager)

What do you dislike?

It doesn't support materialized views. And also SQL query language should be further enhanced to add functionality like "minus" operator and bit more sql enhancements that other databases do provide.

Recommendations to others considering the product

Informix has great potential to be one of the top databases in the market but I think, IBM is not putting much efforts in the marketing and development of Informix.

But, still Informix can compete with any databases in the current market and its comparatively low cost of ownership could make it suitable for a lot of organizations as well.

What business problems are you solving with the product? What benefits have you realized?

I have used it for mission-critical OLTP financial services and have found it very robust and stable.

Required minimum maintenance and uptime is great.

Provides multiple HA options/technologies

Informix review by Francesco V.
Francesco V.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"The fastest and more reliable database ever used for business application"

What do you like best?

Informix provides great features for every kind of use: do you need to setup an high-availability environment? grant simultaneous access to a broad mix of applications? manage terabytes of data? spread your production database on different nodes? use physical and virtual servers with different OSs? Just a very few examples about what you can achieve using Informix.

What do you dislike?

The IBM price list uses the Processor Value Unit concept - aka "PVU", which is quite difficult to calculate and manage by the customers. Unfortunately for complex installations the PVU pricing also become very expansive.

Recommendations to others considering the product

Consider the worldwide market of Informix: telco, healthcare, industries, public administrations, finance and many others. Each market segment can find with Informix a very good and agile friend, helping to minimize technical problems... and increase business. Also evaluate TCO for complex environments: Informix allows to save time in the administration and have a very strong support all around the world.

What business problems are you solving with the product? What benefits have you realized?

Every application have peculiar features. This means that normally everytime you have to setup new applications to cover new business needs, you have to think about what development language has been used, what is the target platform, what is the way to connect the application to the backend/data, what level of integration do you need and of course how many users you need to keep concurrently online. All these questions can reflect an impact (or problems) on the database side. Using Informix you have "powerful weapons to fight new business needs" and lots of knowledge (articles, blogs, tech-notes) on how to implement exactly what you need. In my experience I did complex installations using Informix Connection Manager - aka "CM", which is the way to separate the application layer from the database layer and to give to the applications a list of rules about how to connect to the right server, the right database and get the best performance possible to the production environment. This always allows customers to implement very secure and fast architectures, and schedule servers management with no application block and data loss. With a few people in my team, I can manage hundreds of installations, avoiding to loose time to manage Informix instances, and having time to continuosly implement new solutions for new needs.

Informix review by <span ue="safe-name" data-safe-name-id="253b2aa1-da59-4f9b-b874-1f973f2bf050">John C.</span>
John C.
Validated Reviewer
Review Source
" itemprop="name" />

"I have used Informix in multiple business environements over many platforms. 20+ years using it."

What do you like best?

With all of the turmoil that Informix has had to go thru it still shines as an amazing RDBMS that can handle any type of application that is thrown at it. Every new feature introduced is usable in about every real world situation. My current job is running with Informix containing a 5TB database and is still performing at top levels.

What do you dislike?

It sometimes seems that Informix has been thrown to the back burner under IBM ownership but we do still see new releases so it has gotten better.

Recommendations to others considering the product

If you want a robust system, Informix is the only way to go for ease of admin and setup.

What business problems are you solving with the product? What benefits have you realized?

Serving results of clinical trials to a worldwide customer base with only one server. The benefits of not having to deploy across multiple servers just to get performance increases is huge savings in the long run.

Informix review by Rubén D.
Rubén D.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Informix is powerfull and easy administration"

What do you like best?

Informix is best database for OLTP, Enterprise Replication & High Availability

It is Solid & Stable, Best performance, Minimun administration

It runs without problems with almost all versions of Linux, Unix & Windows (even android)

It is Mulituser, Multiprocesing, Multithreading, Parallel Procesing, MultiServer.

Informix is true 24x7 services.

Informix is true Oriented Object Database

Free Support Groups of Informix (They are friendly and open mind)

Now Informix have new technology like Nosql & Json

Development is easy with 4gl & Eclipse (Java)

What do you dislike?

When IBM don't see true value of Informix

Sometimes There is not enough technical support in my country

Recommendations to others considering the product

This database have the best ROI

The performance is the best

The maintenance & administration is minimum

Exists a version of informix for any plataform even for android

You can Use Enterprise Replication with hundred servers without problems

You have on-line documentation

You have free groups for support the database. These groups are friendly like a family

What business problems are you solving with the product? What benefits have you realized?

Implementation of 4GL-ERP Solution. This ERP solution is used in OLTP environment

Data Distributed and High Available using Enterprise Replication and High Data Replication. We have many servers interconnect. We have almost one hundred servers on-line with ER (Enterprise Replication)

Heterogenous environment using Linux, Unix & Windows

Work with documents and images, We have a repository of XML and PDF files inside of database.

Web Solution: The users enter the customer orders with control of portafolio of products and budget by departament.

Electronic invoice using WebServices

Development with free tools like java & Aubit 4gl.

Informix review by Mike W.
Mike W.
Validated Reviewer
Verified Current User
Review Source

"Informix - tough as nails"

What do you like best?

A robust database product that is way ahead of the competition. The incredible feature set and versatility makes it ideal as a back end workhorse supporting huge ERP systems and data warehouses, or as a small footprint database for Internet of Things applications, and everything in between. The Informix Warehouse Accelerator produces is a game changer in terms of fast reporting against enormous data sets. This database is everywhere, and you likely never even knew it - telecommunications, utilities, banking, retail...

What do you dislike?

Not well known or publicized, despite its use around the world. Small user community. Incorrectly perceived as older technology.

What business problems are you solving with the product? What benefits have you realized?

Data warehousing, and recently Internet of Things installations using TimeSeries on ARM processors.

Informix review by Jennifer W.
Jennifer W.
Validated Reviewer
Review Source

"Informix Family Products"

What do you like best?

Informix products are reliable & stable. Since 1998, I've worked with a variety of their products and have only had a handful of problems that required intervention from Informix/IBM to help correct.

What do you dislike?

In comparison to other databases, it is harder to find resources with much Informix experience at least in our area.

Recommendations to others considering the product

I have limited experience with other major databases as primarily worked with Informix but I've not ran into features in others that were not option (may be handled differently) in Informix.

What business problems are you solving with the product? What benefits have you realized?

We are providing a customized financial system for our client. Informix is both flexible enough to allow us to easily do Ad Hoc reporting & make changes to our software as needed to meet client's needs. Informix has built in lots of updated features from the first version that I was using that was only an online database.

Informix review by Ivan V.
Ivan V.
Validated Reviewer
Review Source

"Users love it, competitors hate it because it is too good"

What do you like best?

Easy to install, very easy to use, powerful, versatile and easy to manage and configure

What do you dislike?

It lacks built-in functions for hierarchycal recursive trees building, querying and traversal

Recommendations to others considering the product

I believe this is one of the best commercial RDBMS. Version 12 supports SQL and NoSQL paradigms in the same database. It also has a very good interaction with the Java platform and if you are a user of the 4GL programming language or its competitors such as Querix Lycia, using either is way easy and straightforward.

One of the best tools I have ever used is onstat. This command is like talking to the database engine on a one to one basis.

What business problems are you solving with the product? What benefits have you realized?

Very large information systems with a huge database. Data history of more than 10 years in a single database

Informix review by Industry Analyst / Tech Writer
Industry Analyst / Tech Writer
Validated Reviewer
Review Source

"Informix Database"

What do you like best?

The performance and the ease of using it. The setup was fairly easier then others. Maintenance is minimal and so is downtown

What do you dislike?

lack of roadmap and lack of features . Not many software out there that uses Informix as db.

Recommendations to others considering the product

Just do it. Been working with Informix for about years now. There is no indirect cost to use it which is great

What business problems are you solving with the product? What benefits have you realized?

reliability - Zero shutdown in last 2 years

Hardware - Current application is housing over 4000 users

The NoSQL is a great plus

In house data analytics systems

Informix review by Hamza Z.
Hamza Z.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Informix IDS is simply the best RDBMS I ever know"

What do you like best?

I definitely like it's architecture especiallly disk soace, memory and proces management. It implements a trully multithereading feature and you can see the parallelism in action. You can see also how Informix IDS deals with it's best friends, Unix and Linux systems.

What do you dislike?

Most of clients using Informix are not aware of the benefits they can get from a well configured IDS engine, since it's works without the need of doing administrave tasks on it, I think that Informix developpers must focus on administration tools like OAT that wil make it easy to Informix users to know more about their RDBMS.

What business problems are you solving with the product? What benefits have you realized?

I am working as a Consultant and all what I k,ow is that Informix has been deployed on huge companies around the world. I have seen for example a bank in Dubai with 600 users working on a database server with only 2GB of mamory.

Informix review by Philippe B.
Philippe B.
Validated Reviewer
Verified Current User
Review Source

"A boot and forget, fast and reliable database management system "

What do you like best?

Informix offers a state of the art database management system, which is fast, reliable and very easy to maintain. At least for small to mid size databases like ours (< 1Tb) you barely have to do any administrative task.

What do you dislike?

Language support for web development could be improved, with first class support and documentation for languages other than java and C/C++

Recommendations to others considering the product

Don't pay too much attention to marketing (informix sucks at this) go for the technical aspects.

Minimal configuration, extended capabilities, performance.

Check revues for feedback on reliability.

What business problems are you solving with the product? What benefits have you realized?

Informix powers our electronic health record product

Informix review by Keith S.
Keith S.
Validated Reviewer
Verified Current User
Review Source

"Simple to Install, Configure and Maintain"

What do you like best?

Ease of administration, built in replication for Business Continuity and for different schema for Data Warehousing. Ability to 'setup and forget'. Runs on any platform I choose: Unix (preferable), Linux or Windows.

What do you dislike?

The last windows install I undertook was not easy, but that was 3 versions (of Informix) ago.

What business problems are you solving with the product? What benefits have you realized?

Fundamentally the entire business runs on Informix. Sales Order placement and fulfilment, product warehousing (receipt and despatch). Purchase Order generation and all Ledgers.

Informix review by Sérgio F.
Sérgio F.
Validated Reviewer
Verified Current User
Review Source

"Awesome. No need for a lot of dba work"

What do you like best?

It just works, and have a lot of functionality

What do you dislike?

IBM don't promote it as it should. This does Informix a less used database with decreasing number of professionals

Recommendations to others considering the product

Consider to understand all the features that implement because you can save a lot of developing time. Excellent ROI among commercial databases.

What business problems are you solving with the product? What benefits have you realized?

Business oriented software, web based

Informix review by Administrator in Marketing and Advertising
Administrator in Marketing and Advertising
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Informix is "The Best" product available on the planet. "

What do you like best?

Maintenance free database in the market, just set it correctly and it will serve you for ever. Runs mostly on all the Operating Systems available in the market.

What do you dislike?

Less work for DBAs, managers think if they really need any administrators. Cost factor and marketing which is not done properly. Also need to give free software to new vendors who implement their application on this database.

Recommendations to others considering the product

Honestly try Informix at least once to compare results with other competitor, and you should able to make a decision. If you don't have liberty of this test, just go for Informix and you will thank me for making this decision.

What business problems are you solving with the product? What benefits have you realized?

I support multiple clients from different industries in their business flow, assist them reduce cost and keep the instance stable and online. Also time to time suggest them of various new features available with the new versions.

Informix review by Alexandre M.
Alexandre M.
Validated Reviewer
Review Source

"A full featured, low cost, low administration, reliable and flexible database engine"

What do you like best?

Its confidence, availability, low cost, low adninistration, and wide range of hardware architectures to install and run.

What do you dislike?

Lack of IBM sources for cases and ads about Informix.

Recommendations to others considering the product

Ask IBM for a certified and specialized Informix partner near you, to talk and discuss. You will not believe a single product has such wonderful features, that can boost your needs in a vrry ease process. Do not discard your hardware in each new product version.

What business problems are you solving with the product? What benefits have you realized?

We have several customers from mid size to VLDB,. Informix is doing well in all of them, but companies that do not invest in development trainings make poor quality software.

Informix review by Paul W.
Paul W.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Informix - Simply the best"

What do you like best?

Ignoring the class leading replication technologies, the virtually no effort administration, scalebility, the TimeSeries functionality puts Informix well ahead of all of the competition.

What do you dislike?

IBM's sales force inability to release they have the Swiss Army knife of databases.

Recommendations to others considering the product

Believe the hype - it is the best

What business problems are you solving with the product? What benefits have you realized?

Currently, the problem is the storage of timestamp data. With the TimeSeries functionality I see significant performance improvements and reduced storage requirements when compare to tradition access/storage methods

Informix review by Internal Consultant in Aviation & Aerospace
Internal Consultant in Aviation & Aerospace
Validated Reviewer
Review Source

"Easy to use with plenty of potential."

What do you like best?

The database and tools are extremely easy to learn and to use. It can be used to build large scale applications with minimal resources. The compilers are great, catching the compilation and run time errors with explanations. The forms and reports builders are handy and convenient for fast growing customers demands.

What do you dislike?

The product we use lacks the diagnostic tools. In many cases we need to build the own testing procedure to trace the problem with the application.

Unfortunately, we are locked in to the 24x80 window, which sometimes require to program additional screens.

Recommendations to others considering the product

I recommend using of this product. It is easy, convenient and brings results fast.

What business problems are you solving with the product? What benefits have you realized?

We use Informix for the total ERP application. Data warehousing, manipulation, full blown reporting. The in house grown system can be quickly customized for any accounting or manufacturing requirements.

Informix review by Brian G.
Brian G.
Validated Reviewer
Verified Current User
Review Source

"Can't be beat"

What do you like best?

It's fast, simple to install and configure, and very versatile.

What do you dislike?

I dislike the bad rap and bashing it gets from other databases.

Recommendations to others considering the product

Give it a test. You will like the results.

What business problems are you solving with the product? What benefits have you realized?

Reliable as back-end database for enterprise website.

Informix review by Scott O.
Scott O.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Small footprint, great performance, excellent uptime"

What do you like best?

The latest versions of IDS require minimal DBA time, it just sits there and runs. The database servers has only a small footprint, yet is packed full of features and is a very fast OLTP server indeed.

What do you dislike?

Not as well known as some of the other big name databases.

Recommendations to others considering the product

Give Informix a go when considering other databases - you'll be pleasantly surprised!

What business problems are you solving with the product? What benefits have you realized?

Informix is an excellent OLTP engine, and now with IWA can also solve data warehouse problems too.

Informix review by Firoz M.
Firoz M.
Validated Reviewer
Review Source

"Database Manager"

What do you like best?

- Best for OLTP

- Cheapest and robust High Available solutions.

- Can segregate OLTP and Data warehouse queries.

What do you dislike?

Not enough market awareness of this amazing product.

Recommendations to others considering the product

Compare the actual product and do not get into marketing hype of the competitors.

What business problems are you solving with the product? What benefits have you realized?

I have used this product in previously and I was super happy about it.

Informix review by Jeff F.
Jeff F.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Informix - Database of Choice"

What do you like best?

Informix is a rock solid database that I recommend to my clients.

It is a stable product with many features for any size company.

What do you dislike?

Not much to dislike, just keep adding new features for improving functionality.

Recommendations to others considering the product

Informix is an excellent database for its reliability and scaleability.

What business problems are you solving with the product? What benefits have you realized?

Working with clients in minimizing downtime and improving availability.

Informix review by Yunyao Q.
Yunyao Q.
Validated Reviewer
Review Source

" Informix is a great tool!!"

What do you like best?

Great performance

Easy management

Enterprise Replication

Reliability

What do you dislike?

No much idea what is dislike

NOnononono

nono

no thing

Recommendations to others considering the product

Try it and you will see how amazing it is.

What business problems are you solving with the product? What benefits have you realized?

Use Informix to manage all weather data related all online data search

Informix review by David W.
David W.
Validated Reviewer
Review Source

"Fast and well supported."

What do you like best?

Extendable, fast and multi-threaded, stack traces are easy to read if you hit a bug.

What do you dislike?

Less well known and until IBM bought it less well funded.

What business problems are you solving with the product? What benefits have you realized?

Benefits, easy to upgrade, fast to start.

Informix review by Alfredo B.
Alfredo B.
Validated Reviewer
Review Source

"Informix reliability"

What do you like best?

Informix is a reliability and easy to admin tool. I would recommend it

What do you dislike?

I don't see any issue that could cause concern or negative feedback

What business problems are you solving with the product? What benefits have you realized?

many

Informix review by Administrator
Administrator
Validated Reviewer
Review Source

"Fast and trustworthy"

What do you like best?

Fast and trustworthy database server based on solaris

What do you dislike?

Some complex to administrate if you dont have knowledge and experience

What business problems are you solving with the product? What benefits have you realized?

Main program database

Informix review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Informix is rock solid"

What do you like best?

we have used informix RDBMS for the last 15+ years. rock solid database

What do you dislike?

sometimes the documentation can be a bit cryptic and IBM is difficult to get answers from

Recommendations to others considering the product

patience with IBM

What business problems are you solving with the product? What benefits have you realized?

storing large amounts of text and person information

Informix review by Jeff M.
Jeff M.
Validated Reviewer
Review Source

"Under-Appreciated, Great Database"

What do you like best?

Excellent response times and low overhead. The syntax is mostly compatible with SQLServer, so there isn't a big learning curve for a developer.

What do you dislike?

It isn't widely used, so it doesn't help your resume very much to say you have Informix experience.

Recommendations to others considering the product

Don't let the small user community scare you off. There are resources out there with years of Informix experience.

Learn more about Informix

Informix Videos

Kate from G2 Crowd

Learning about Informix?

I can help.
* We monitor all Informix reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.
Informix
(27)