SAP IQ Benefits

it_user719802 - PeerSpot reviewer
Senior Database Administrator & BigData Administrator at a financial services firm with 10,001+ employees

My organization was using different RDBMs for data warehouse systems. There were obvious problems in terms of performance. Sybase IQ resolved all the performance problems we had at that time.

View full review »
RP
Lead Technical Specialist at a financial services firm with 10,001+ employees

While queries with previous products could run for hours, with SAP IQ, they run in a matter of minutes or seconds. Disk costs.

View full review »
it_user329433 - PeerSpot reviewer
Senior Engineer with 1,001-5,000 employees

We can now have over one billion rows in a table for semi-real trans-national querying. In quarterly or monthly report from billions of records, it supports and provides, stable performance.

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.
it_user271569 - PeerSpot reviewer
VP at a financial services firm with 1,001-5,000 employees

IQ has enabled our company to load data from our data vendors in under one hour and eliminated multiple copies and hours of processing time.

View full review »
it_user257172 - PeerSpot reviewer
President at a tech consulting company with 51-200 employees

Analytical reporting has improved.

View full review »
it_user705720 - PeerSpot reviewer
Senior SAP SYBASE/SQL SERVER DBA at a financial services firm with 10,001+ employees

It has provided us with cube query and faster data upload time.

View full review »
it_user727509 - PeerSpot reviewer
Technology Lead at a tech services company with 10,001+ employees

Instead of having a PNO process at the end of the day, which was running forever (six hours) I moved the process into SAP IQ. Now, I am giving real time, or near real time, PNO. The portal runs for four minutes, rather than running for six hours, which is a performance improvement.

View full review »
it_user261621 - PeerSpot reviewer
Sybase Tower Lead - DBA CoE at a marketing services firm with 1,001-5,000 employees

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. It delivers performance and enormous scalability.

View full review »
it_user288369 - PeerSpot reviewer
Data Architect, Enterprise Data Warehouse at a healthcare company with 1,001-5,000 employees

It’s the central component of our enterprise data warehouse. Queries and reports that would require hours or days from the original source systems are now available in minutes or seconds. It’s really fast!

View full review »
it_user155730 - PeerSpot reviewer
Database Senior Manager at a financial services firm with 201-500 employees

Allows creation of highly functional DW.

View full review »
CN
MSSQL DBA,SAP IQ DBA/ASE at NuWare Systems LLP

My client is a into agri business, so it helps them get the best analysis.

View full review »
it_user133989 - PeerSpot reviewer
Consultant at a tech services company with 51-200 employees
ASIQ offers a query engine where you can design a fully denormalized schema depending on business needs. It has the best performance in data retrieval compared to other database engines and reduces HW cost, achieving up to 70% less storage; Database is smaller than input data, even with all the indexes. 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.