In the organizations I have worked with, SAP Sybase IQ has been used successfully as a datawarehouse solution and as data store for ad hoc querying, and it delivers performance and enormous scalability.
SAP IQ leverages columnar storage for high compression, load rates, and query performance, making it ideal for data warehouses. Scalability is enhanced by a flexible multi-server setup. However, buyers should note issues like limited documentation, metadata consistency risks, high costs in some regions, and lack of support for integrated backup. Functional error messaging can also be a concern. Despite its unmatched speed, these challenges require consideration.
