We performed a comparison between IBM Informix and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."This solution has made financial reporting possible by allowing financial people the opportunity to set Informix to "Auto Pilot" so that they can attend other duties."
"The stability is incredible. I have customers with uptimes of several years."
"It supports multiple applications and business intelligence tools."
"So far, we do not have a lot of issues. It's pretty problem-free."
"The solution's stability, performance, enhanced functionality, and replication are all great features."
"The initial setup is pretty easy."
"The most valuable feature is concurrency and locking because my customers usually use databases in OLTP mode. So, for a large number of competitive users. Other features that are well valued are quick large-scale data types. It is better than Oracle."
"For IoT business cases, having Informix Enterprise Edition work on edge computers, like Raspberry Pi and using Informix replication, makes complex situations simple to build and maintain."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The product's initial setup phase is extremely simple."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"I would like to see backups from secondary servers."
"This solution is in need of more current tools."
"This product could be made easier to use for beginners."
"It would be helpful to have IBM salespeople know that Informix exists, and sell it. Currently, it is completely ignored by IBM."
"The technical support services need substantial improvement."
"The solution lacks some functionality."
"I experienced poor input/output (IO) performance."
"I really would love to have a QT plugin."
"Limitations in group by projections is where I would like to see an improvement."
"Suboptimal projection design causes queries to not scale linearly."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"We faced some challenges when trying to use the temporary tables feature."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"The geospatial functionality could be designed better."
"Support is an area where it could get better."
IBM Informix is ranked 6th in Embedded Database with 16 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. IBM Informix is rated 8.6, while Vertica is rated 8.2. The top reviewer of IBM Informix writes "Quite stable and flexible but not very innovative". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". IBM Informix is most compared with Oracle Database, SQL Server, IBM Db2 Database, MySQL and MariaDB, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Embedded Database reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.