SAP IQ is a phenomenal relational big data database
SAP IQ is currently our bid data database. We have several schemas with billions of rows, and both Oracle and Sybase were a bit slower …
SAP IQ
SAP IQ (formerly SAP Sybase IQ)
Overview
Recent Reviews
Video Reviews
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of SAP IQ, and make your voice heard!
Pricing
View all pricingN/A
Unavailable
What is SAP IQ?
SAP IQ (formerly SAP Sybase IQ) is a columnar relational database management system (RDBMS) optimized for Big Data analytics.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
3 people want pricing too
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
What is SingleStore (formerly MemSQL)?
MemSQL is a NoSQL database offering from the company of the same name in San Francisco.
Features Scorecard
No scorecards have been submitted for this product yet.Start a Scorecard.
Product Details
What is SAP IQ?
SAP®
IQ software aims to deliver speed and power for extreme-scale enterprise data warehousing
and analytics. According to the vendor, its column-oriented,
grid-based massively parallel processing (MPP) architecture and patented data
compression and indexing technologies enable companies to exploit the value of
huge amounts of data at the speed of business.
SAP IQ Features
- Supported: Create a unified data store for all data types
- Supported: Accelerate data loading
- Supported: Reduce costs and improve performance
SAP IQ Competitors
SAP IQ Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
View all alternatives
Frequently Asked Questions
What is SAP IQ?
SAP IQ (formerly SAP Sybase IQ) is a columnar relational database management system (RDBMS) optimized for Big Data analytics.
What are SAP IQ's top competitors?
Oracle Database, Microsoft SQL Server, and Teradata Vantage - Enterprise Data Warehousing are common alternatives for SAP IQ.
Who uses SAP IQ?
The most common users of SAP IQ are from Enterprises (1,001+ employees) and the Financial Services industry.
Reviews and Ratings
 (11)
Reviews
(1-3 of 3)- Popular Filters
Companies can't remove reviews or game the system. Here's why
November 20, 2019
SAP IQ is a phenomenal relational big data database
SAP IQ is currently our bid data database. We have several schemas with billions of rows, and both Oracle and Sybase were a bit slower than we liked. Moving our Data to SAP IQ showed a distinct increase in performance when doing bulk inserts and aggregates of data. We only began implementing SAP IQ about a year ago, and in the first six months, we tested it more than used it. For the past six months, we have been using it and are happy with the results.
- Inserting millions of rows of data takes seconds.
- Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).
- Installation, specifically licensing, is a pain.
- Connectivity is a bit tricky given that the SQL Anywhere drivers aren't native anywhere.
March 22, 2018
SAP Sybase IQ - versatile for data warehousing
We use this columnar relational database software in the business for the purpose of having a data warehouse and also a data mart that would store business data and enable users to run leverage these for intelligent and informed business decisions on a day to day basis. This is the main database that supports our data warehouse.
- Superior performance in getting results for query
- Ability to scale up as data size/volume increase
- In memory solution and hence enhanced speed
- Initial set up can be more intuitive
- More documentation to help users who are ramping up on learning curve to get used to this product
December 06, 2017
IQ is good for us, it'd be good for you too!
We use it to warehouse data to log every customer action and call that flows through our network. It's also referenced for customer billing and is replicated across. We do have a mandated requirement to keep this data available for 7 years.
IQ itself solves the big issue of warehousing large amounts of data.
IQ itself solves the big issue of warehousing large amounts of data.
- It recovers nicely and with minimal downtime.
- It works well on the Linux OS.
- It's easy for our DBA to work with and maintain.
- The pricing schedule is a bit expensive and cumbersome.
- Licensing for a virtual machine is difficult to understand.