SAP IQ Reviews

The speed of the tool - both of the query response and the loading of data.

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!

The stability needs improvement. We’ve upgraded through multiple minor revisions because of issues where the database server would crash when attempting to answer a perfectly legal SQL query.

We're

I've been using it for five years.

The client side of the package is a bit monolithic. We'd like to be able to roll out just the ODBC driver to client workstations through our managed desktop solution, but SAP/Sybase apparently doesn't have that capability, so we have to manually visit every workstation and install the complete client package from the DVD image.

Just the stability issues referenced above. 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.

Not yet. We haven’t had a need to expand our Sybase IQ system yet, but their multiplex architecture seems like a useful approach if/when we need to do so.

Customer Service:

We have to go through our systems integrator (Telus).

Technical Support:

Technical support is not good, although we actually have to go through our systems integrator (Telus), not directly to SAP/Sybase. However, the feedback from our systems integrator (Telus), is that the technical support is not great. Their first level help desk at SAP/Sybase is generally of no value for the problems we encounter, and the process of escalation to the appropriate level takes longer than it should.

This was our first solution for our enterprise data warehouse project.

The initial setup was complex, because Sybase IQ is architecturally very different from Sybase ASE, which we’ve been using for over 20 years. They share the “Sybase” name, but otherwise are very different products, requiring a different approach to database administration and tuning.

We used our vendor team, whose expertise was acceptable, but not outstanding.

We haven't calculated it.

Caveat emptor. It’s a frustratingly excellent product. When it works, 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.

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.