SAP IQ Reviews

• Performance
• Scalability
• Ease of deployment
• Usability
• Administration

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.

Training and marketing are two areas where improvements are needed.

I've used it for eight years.

SAP Sybase IQ is a product which can be deployed very easily on commodity hardware.

Not really. In normal functioning SAP Sybase IQ is extremely stable.

No. I have seen deployments of datawarehouses with tens of TB's in used space and they scaled very easily to multiple applications.

Customer Service:

It has been good, but more can be done in this area.

Technical Support:

It's good, 7/10.

It's straightforward in the hands of a junior level DBA. The installer is very easy to understand as long as the user has a understanding of architecture and layout of the database server.

It's been in-house.

Understand your requirements well in terms of performance, backup, and space requirements before picking the number of licenses. If IQ is being used in a virtual environment then probably a good understanding of licensing options in a virtual environment is needed. Recently SAP has introduced some new license options, but new users should review those options with the sales team.

Estimate the storage requirements, performance requirements, and the number of users during the planning phase. Review the documentation related to hardware sizing and best practices available on the SAP website. There is a hardware estimation guide too which helps in estimating the hardware requirements. Lastly, review the multiplexing option too and understand the implication of columnar storage in a database server.

Columnar storage allows high compression, high load rates and high query performance.

Allows creation of highly functional DW.

Concurrency and functional error messaging.

6 years.

No.

No.

Average.

No.

It is straightforward, but the documentation is confusing at times.

Evaluate all options; check to see if you need expensive add-ons.

Yes, Teradata and Oracle.

Make sure you can back it up, load data from local host, and do real load tests.

Column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts.

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

Concurrency and functional error messaging.

Five years.

A production database server should never crash in response to user input, but Sybase IQ has repeatedly done that for us, over multiple revisions of the product.

No.

Average.

No.

Straightforward.

Simplify the classification of licenses, especially the core/store number.

SSAS and Oracle.

Make sure you can back it up, load data from a local host and do real load tests. The performance is amazing, but the stability issues, and the expense of the product, coupled with less than top-tier technical support, should be considered when evaluating the product for your specific environment.

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.

Very few people are familiar with this technology, as training programs are very expensive.

I've used this product for almost five years.

The deployment is a bit complex compared to other databases.

No issues encountered.

No issues encountered.

It's good.

I switched because of its column-based architecture and optimal storage.

It has two types of setup, Simplex, and Multiplex. Simplex is straightforward, while Multiplex is a bit complex. but once you get to grips with it, that's straightforward too.

It's worth investing in.

Good luck with it, putting in hard work will give you good returns.

Query Speed, Data Compression, Not restricted schema design, Fast Loading, Zero administration, Easy to learn and use.

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.

Real Time.

No.

No.

No – ASIQ has ability to scale by adding CPUs or nodes with no need to re-organize the data.

Customer Service: GoodTechnical Support: Good

I have used other traditional RDBMs in Business Intelligence systems like MSSQL and Oracle but the performance was not so good when increasing the data volumes. In order to achieve the ASIQ performance, we had to spent a lot of time configuring properly the database.

The initial setup was straightforward.

Excellent

Is the best choice when used as DW data repository because it combines high speed queries and lower TCO.