SAP IQ Valuable Features
The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required.
ME
Mohamed-Abdalla
IT Manager at PCWORLD Egypt
When a customer tries to change to business intelligence, they acquire a lot to orient the business with stakeholders, which is an important key and the decision maker in an entity.
View full review »It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.
View full review »Buyer's Guide
SAP IQ
March 2024
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.
RP
Richard Pitsnogle
Lead Technical Specialist at a financial services firm with 10,001+ employees
- Compression
- Column-based, indexes
- Speed with large queries
- Large amounts of data
Sybase IQ is the only data warehousing (DWH) solution we use for reporting.
View full review »The most valuable features of the product are the column structure, speed, and compression. Partitioning is one of the most useful features with SAP IQ. It was something that they used to charge a lot for but it costs less now.
- Data compression ratio
- Mass query speed
Sybase IQ, it's high compressed ratio and large query are attractive. In data warehouse experience that is a good tool and normal C/P.
- Ability to load data from flat files very quickly
- Data compression
- Fast querying for aggregations
The column architecture.
View full review »Valuable features for us include the compression, speed, fast response time, and easy object maintenance.
View full review »The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution.
It's two things:
- Highest performance on query. This is very notable. Let's say, yesterday I was doing some of the performance improvements on the SAP AC, where the query was running for one and a half hours. I am told the query is a one-store procedure while running for six hours, but in IQ the same thing is running for just four minutes. Also, in AC, if I'm having any raw base of solutions, the data is around 100GB. Yet with IQ's compression it will be 20GB. So, you have all savings on your disk.
- Your performance is ultimate, and you have a column-based solution to solve all these problems. IQ has its own patented index. It has seven patented indices. It gives you the ultra performance. In the latest version of SAP IQ, you have an in memory solution called RLV (Raw Level Versioning). You can run your query, whatever you are running on the ASP, this will be also be on the IP, so no code changes are required. These are the ultimate performances I have seen on the SAP IQ.
- Performance
- Scalability
- Ease of deployment
- Usability
- Administration
The speed of the tool - both of the query response and the loading of data.
View full review »Columnar storage allows high compression, high load rates and high query performance.
View full review »CN
Chetan Niloor
MSSQL DBA,SAP IQ DBA/ASE at NuWare Systems LLP
Column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.
View full review »Sybase IQ is a column based database, used for business intelligence, data warehousing, and data marts. It is optimized for BI/Analytics and ad-hoc queries. Since it is column based it uses optimal storage space and very high performance.
View full review »
Query Speed, Data Compression, Not restricted schema design, Fast Loading, Zero administration, Easy to learn and use.
View full review »
Buyer's Guide
SAP IQ
March 2024
Learn what your peers think about SAP IQ. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,578 professionals have used our research since 2012.