We just raised a $30M Series A: Read our story

SAP IQ OverviewUNIXBusinessApplication

What is SAP IQ?

SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. 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 is also known as Sybase IQ.

Buyer's Guide

Download the Relational Databases Buyer's Guide including reviews and more. Updated: September 2021

SAP IQ Customers

ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.

SAP IQ Video

Archived SAP IQ Reviews (more than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
JB
Snr DBA at a insurance company with 1,001-5,000 employees
Real User
An excellent column-based, enterprise relational database solution with good speed and compression

Pros and Cons

  • "Unbeatable speed and compression with a colummn-structured relational database."
  • "The organization who owns the product does not support it well and appears not to be doing significant development for the future."

What is our primary use case?

We use SAP IQ primarily for data warehousing and business intelligence.

What is most valuable?

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.

What needs improvement?

Actually, it is not the product that needs revision but the company itself. Sybase IQ was bought by SAP. They use it, but they don't really advertise and push it correctly. So SAP IQ — from a company standpoint — is not really supported correctly. If they did more to support the product, it would be a more popular solution.

SAP IQ has not introduced more integration with Hadoop so the two products would act in a more tightly coupled way. This would be one of the more important features that they might add. The integration with Hadoop is important because it seems everybody is going towards Hadoop for big data. You also need a system that works well. Hadoop is fast, but SAP IQ is even faster. They each have advantages, so if you can combine them, that would be good. It will work out better for cost and extra storage.

For how long have I used the solution?

I've actually used IQ from the earliest versions, so over 20 years.

What do I think about the stability of the solution?

My impression from using the product over its lifetime is a little different than it is now. For IQ 16, the latest, the stability is actually quite decent. It got very, very stable. In the beginning, our implementation was slightly unstable because I changed the network to something similar to Aarna, so there were some issues because of all those changes. It was slightly unstable, but after some adjustments, it's really stable.

What do I think about the scalability of the solution?

The product is very scalable. You can scale it upwards and sideways — that is by adding new hardware or working with software solutions. This is the only product I know which will allow you to do both.

Our company is slightly smaller than many with only about 100 users. Most probably there are more, but this is on average. It all depends on the business climate. 

How are customer service and technical support?

Technical support for the product has become almost nonexistent for this product. There are no real agents because SAP let all the people go who were dedicated to the IQ project. Actually, I used to work for SAP. They let us all go. That's why I say there are not a lot of real experts in the SAP organization available for SAP IQ support. As far as I am concerned, that is a problem for users.

Which solution did I use previously and why did I switch?

Personally, I've explored a lot of solutions. While it may not have been specifically for where I am working now, I stay aware of what is on the market. It only affects the current solution in that I am aware that there are other options, what their competitive advantages are, and features we might implement or emulate. 

For example, I've used Data Warehousing with Oracle, Dv2 also with Oracle and SQL Server. But I do not think that other products really have an advantage for warehousing over the SAP IQ solution. All of them that compete now seem to be Oracle Exadata, which is fast, but it is also very expensive. All the newer products seem to have columnized solutions as that is very advantageous for data warehousing. It is in order to compete with what SAP IQ already provided.

How was the initial setup?

IQ's initial setup is relatively easy and is not that complex. The actual installation and deployment is a day or two. The biggest bottle-necks are normally encountered with the storage and having people who can configure and set up the storage correctly. The storage needs to conform to the parameters of SAP IQ. So, in reality, the time-delay is due to setting up the storage which is the big bottleneck for deployment. We can't blame the product itself.

What about the implementation team?

We do our own setup and deployment.

What's my experience with pricing, setup cost, and licensing?

Pricing changes. In South Africa, it depends on how the pricing is obtained. The pricing is good and it is actually better now because they are realizing that they should price it correctly according to the market. The pricing improved especially with the partitioning because they used to charge too much for that feature. They have now lowered that because obviously data warehouses get huge so when you use partitioning that it would get very expensive. It benefits people who have big databases.

As far as actual cost, there's a standard licensing fee and then there are the add-ons. The most useful and most expensive add-on was the partitioning. That's the only real additional cost that I've found useful. They also have got a high-security encryption module, but that's something that's very, very niche. So beyond the standard licensing you also have to factor in the cost of modular enhancements. But there aren't a lot of additional things you need to pay for in order to enhance what the base system does.

The only other add on that you would need to pay for is if you scale sideways. That is the multiplex which requires additional hardware.

Which other solutions did I evaluate?

Being in this business for a long time — now as a data architect — I've had the opportunity to use a few solutions and there are many more to research. There is a long list of products that I've worked with and evaluated. You might say that evaluation is constant but I am an expert with SAP IQ. None of the other products have capabilities that would make me suggest a shift.

What other advice do I have?

In rating the product, I would give it at least an 8 out of ten. The only thing really needed to make it a ten out of ten for us and our usage is better support from the vendor. Well, I say better support but also better vision into the future. I do not think the company is doing sufficient work in development.

My advice for other people and companies considering this product as a solution is to find out if you can get proper support. I really think that's the biggest challenge facing people who use the product. The current company that owns the product, SAP, is very laid back about supporting the product.

It may be helpful to note that the solution does not require a lot of maintenance. We've really got only one or two DBAs looking after it and it is not even a full-time job. If you have a multiplex setup you may require more dedicated DBA staff for maintenance.

Once the setup is done correctly, the maintenance comes down to monitoring. There's not a lot of other effort involved in keeping things running.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
CN
MSSQL DBA,SAP IQ DBA/ASE at NuWare Systems LLP
MSP
Excellent Performance But Stability Issues Are A Concern

What is most valuable?

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

How has it helped my organization?

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

What needs improvement?

Concurrency and functional error messaging.

For how long have I used the solution?

Five years.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

Average.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

Straightforward.

What's my experience with pricing, setup cost, and licensing?

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

Which other solutions did I evaluate?

SSAS and Oracle.

What other advice do I have?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
Find out what your peers are saying about SAP, Microsoft, Oracle and others in Relational Databases. Updated: September 2021.
540,984 professionals have used our research since 2012.
it_user727509
Technology Lead at a tech services company with 10,001+ employees
Consultant
A column-based solution with the highest performance on query

Pros and Cons

  • "The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
  • "The room for improvement would be the marketing of the product, because this product is much better than advertised."

What is most valuable?

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:

  1. 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.
  2. 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.

How has it helped my organization?

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.

What needs improvement?

Yes. The room for improvement would be the marketing of the product, because this product is much better than advertised.

One of my colleagues was working with Adobe, where the Product Management team was using Hadoop. Hadoop was doing a performance test, let's say excessive performance, and X plus X was the performance improvement of the SAP IQ. Thus, SAP really has to really market this product very well because of its patented indexes. Because it's patented, the compression is even far better than SAP HANA. So, they have to improve it and its use, the RLV in memory solution. The RLV is there so they are currently using it just for keeping delta data. Instead, what I would recommend is, you have to take it into the next level and include it in memory data space and in memory database.

For how long have I used the solution?

Almost six years.

What do I think about the stability of the solution?

Very stable. It is an excellent product. We are running it for one of the banks for the last six years. So, in there are the P&L, securities, lending, and borrowing for those business, and we are running it in SAP IQ. No stability issues last I checked.

What do I think about the scalability of the solution?

No issues. It's ultimately a very good product.

How are customer service and technical support?

Yeah. The support needs much improvement.

I would rate them a six out of 10.

Which solution did I use previously and why did I switch?

Yeah, I was using a business solution SAP SD. SAP IQ is more powerful than SAP SD, and the customer service has to be much improved. It didn't have the radical help I am looking for nor the documentation.

How was the initial setup?

It's too complex. This is concerning something that will change immediately. I have to search for a very long time to obtain something if I need it. It's like a big dictionary. But, in the end, I don't get anything. If you go to infocenter.sybase.com, there is only a very small search. You have a lot of information, but it's not useful for me. The data coming with the SAP planning portal is not user-friendly. That is one of the major issues, which I'm facing at this point of time.

Which other solutions did I evaluate?

Yes, definitely. We were evaluating the other products but when I came to SAP IQ, SAP IQ was the first column-based solution across the world. So, we moved to IQ, and IQ gave us the ASE performance. We have faced some issues, a little here and there, but with SAP IQ Information Lifecycle Management, we fixed all those problems, and it's still running and giving business to my bank in last 10 years. We are customers of SAP for this product and still this year we have renewed the product again.

What other advice do I have?

Save for a 100% guarantee, you will get the performance you are looking for with SAP IQ. It is just not for a normal solution, but I recommend it if you have performance issues and you have a huge database of data, for that it is the best product. For these type of issues, I would operate SAP IQ, over even SAP HANA.

I would go for SAP IQ. I am a HANA person, but I will still recommend IQ over HANA.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user719802
Senior Database Administrator & BigData Administrator at a financial services firm with 10,001+ employees
Vendor
Robust For Ad Hoc DW Queries But Multiplex Has Metadata Consistency Issues

Pros and Cons

  • "It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
  • "Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."

What is most valuable?

It is very robust for ad hoc DW queries and its columnar compression is unique and valuable.

How has it helped my organization?

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.

What needs improvement?

They should improve the backup options. There is no backup software support for Sybase IQ. You have to implement your own backup system. For large databases, you need to use disk backup solutions and it is very expensive.

Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups.

It is very hard to find which sessions cause a performance problem. It also has no resource manager to manage resources between consumers.

For how long have I used the solution?

Over 15 years.

What do I think about the stability of the solution?

Early versions crashed frequently. Crashes (IQ freezes for no apparent reason and you have to restart it to resolve it) with the latest versions are rare.

What do I think about the scalability of the solution?

Multiplex has some limitations and bugs. Although implementing MPX is easy, I cannot say it results in the expected scalability.

How are customer service and technical support?

Six out of 10.

Which solution did I use previously and why did I switch?

We used a different solution and then we switched to Sybase IQ. Now, because we are having some difficulties in terms of scalability, stability and performance, our DW system is being switched to a new solution again.

How was the initial setup?

Both simplex and multiplex installation are very straightforward.

What's my experience with pricing, setup cost, and licensing?

Negotiation is very important.

What other advice do I have?

Data, and getting insight from data, is very important when it comes to competing with your competitors. You have to be fast and agile, in terms of implementing a system and development, in order to get that data insight.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user705720
Senior SAP SYBASE/SQL SERVER DBA at a financial services firm with 10,001+ employees
Vendor
Valuable features include compression, speed, and easy object maintenance

Pros and Cons

  • "Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
  • "I think the universe should be part of the Sybase IQ tool set."

What is most valuable?

Valuable features for us include the compression, speed, fast response time, and easy object maintenance.

How has it helped my organization?

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

What needs improvement?

I think the universe should be part of the Sybase IQ tool set.

For how long have I used the solution?

We have been using the solution for about 10 years.

What do I think about the stability of the solution?

Sybase IQ is very stable. However, during earlier stages when the server crashes, you need Sybase technical support to help you out.

What do I think about the scalability of the solution?

We did not encounter any issues with scalability.

How are customer service and technical support?

The experts on Sybase IQ were very few in number, but they were really knowledgeable.

Which solution did I use previously and why did I switch?

I guess it is the price competition offered by other vendors that causes companies to migrate to other data warehouse databases.

How was the initial setup?

This is one of the simplest tools to install and it is very easy to scale.

What's my experience with pricing, setup cost, and licensing?

Negotiate based on the features required.

Which other solutions did I evaluate?

I was not involved with product evaluation. However, this was the tool I normally would recommend for Sybase archive solutions.

What other advice do I have?

Evaluate, carry out benchmarks, and do an ROI before buying.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
RP
Lead Technical Specialist at a financial services firm with 10,001+ employees
Real User
While queries with previous products could run for hours, with SAP IQ, they run in a matter of minutes or seconds

What is most valuable?

Compression Column-based, indexes Speed with large queries Large amounts of data

How has it helped my organization?

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

What needs improvement?

There could be more documentation and training.

What do I think about the stability of the solution?

In earlier versions, yes, but not in the past two-three versions.

What do I think about the scalability of the solution?

None, scales to VLDB status.

How are customer service and technical support?

An eight out of 10.

Which solution did I use previously and why did I switch?

OLTP databases, but there's no comparison in terms of reporting and warehousing.

How was the

What is most valuable?

  • Compression
  • Column-based, indexes
  • Speed with large queries
  • Large amounts of data

How has it helped my organization?

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

What needs improvement?

There could be more documentation and training.

What do I think about the stability of the solution?

In earlier versions, yes, but not in the past two-three versions.

What do I think about the scalability of the solution?

None, scales to VLDB status.

How are customer service and technical support?

An eight out of 10.

Which solution did I use previously and why did I switch?

OLTP databases, but there's no comparison in terms of reporting and warehousing.

How was the initial setup?

Straightforward, very easy.

What's my experience with pricing, setup cost, and licensing?

Know what you are getting for your money.

Which other solutions did I evaluate?

No, I did not evaluate other options before choosing this product.

What other advice do I have?

Do the research. This is an excellent product.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Database Senior Manager at a financial services firm with 201-500 employees
Vendor
​Columnar storage allows high compression, high load rates and high query performance​.

What is most valuable?

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

How has it helped my organization?

Allows creation of highly functional DW.

What needs improvement?

Concurrency and functional error messaging.

For how long have I used the solution?

6 years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

Average.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

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

What is most valuable?

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

How has it helped my organization?

Allows creation of highly functional DW.

What needs improvement?

Concurrency and functional error messaging.

For how long have I used the solution?

6 years.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

No.

How are customer service and technical support?

Average.

Which solution did I use previously and why did I switch?

No.

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

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

Which other solutions did I evaluate?

Yes, Teradata and Oracle.

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user288369
Data Architect, Enterprise Data Warehouse at a healthcare company with 1,001-5,000 employees
Vendor
Query response and data loading times are fast, but we ran into stability issues involved server crashes when attempting to answer legal SQL queries.

What is most valuable?

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

How has it helped my organization?

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!

What needs improvement?

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

For how long have I used the solution?

I've been using it for five years.

What was my experience with deployment of the solution?

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.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are customer service and technical support?

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.

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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.

What about the implementation team?

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

What was our ROI?

We haven't calculated it.

Which other solutions did I evaluate?

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Senior Engineer with 1,001-5,000 employees
Vendor
We can now have over one billion rows in a table for semi-real trans-national querying., but the admin UI could use some improvements.

What is most valuable?

  • 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.

How has it helped my organization?

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.

What needs improvement?

  • Admin UI
  • Tuning parameters
  • Maintenance tool
  • UI

For how long have I used the solution?

I've used it for over five years.

What was my experience with deployment of the solution?

There weren't many issues.

What do I think about the stability of the solution?

Aborts happen, and we don't know why.

What do I think about the scalability of the solution?

There aren't many issues.

How are customer service and technical support?

Customer Service:

5/10.

Technical Support:

5/10.

Which solution did I use previously and why did I switch?

We also have an Oracle solution, and these it runs in parallel with Sybase IQ.

How was the initial setup?

We set it up in multi node mode, and it wasn't too complex.

What about the implementation team?

We implemented with a vendor who were 6/10.

What was our ROI?

It's at about 60%.

What's my experience with pricing, setup cost, and licensing?

They should simplify the classification of licenses, especially the core/store number.

Which other solutions did I evaluate?

  • Oracle
  • PostgreSQL

What other advice do I have?

Take into consideration your multiplex environment and storage IOPS balance.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user288348
Senior Consultant at a financial services firm with 1,001-5,000 employees
Vendor
We've used this data-warehousing solution exclusively for reporting, with the only issue being that support in Turkey was short-staffed at the time we needed it.

Valuable Features

Sybase IQ is the only data warehousing (DWH) solution we use for reporting.

Use of Solution

I've used it for eight years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service: 7/10. Technical Support: 6/10 because at the time I was using it, Sybase Turkey were short on staff and not very experienced.

Other Advice

The product is very good as a DWH & Reporting tool. It is performing well on large tables for DML operations and queries.

Valuable Features

Sybase IQ is the only data warehousing (DWH) solution we use for reporting.

Use of Solution

I've used it for eight years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

7/10.

Technical Support:

6/10 because at the time I was using it, Sybase Turkey were short on staff and not very experienced.

Other Advice

The product is very good as a DWH & Reporting tool. It is performing well on large tables for DML operations and queries.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user263406
Freelancer at a consultancy with 51-200 employees
Consultant
The deployment is a bit complex compared to other databases, but its column-based storage is very high performance.

What is most valuable?

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.

What needs improvement?

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

For how long have I used the solution?

I've used this product for almost five years.

What was my experience with deployment of the solution?

The deployment is a bit complex compared to other databases.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical

What is most valuable?

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.

What needs improvement?

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

For how long have I used the solution?

I've used this product for almost five years.

What was my experience with deployment of the solution?

The deployment is a bit complex compared to other databases.

What do I think about the stability of the solution?

No issues encountered.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

It's good.

Which solution did I use previously and why did I switch?

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

How was the initial setup?

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.

What was our ROI?

It's worth investing in.

What other advice do I have?

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
VP at a financial services firm with 1,001-5,000 employees
Vendor
It allows us to centrally store data, but DR capabilities need improving.

What is most valuable?

  • Ability to load data from flat files very quickly
  • Data compression
  • Fast querying for aggregations

How has it helped my organization?

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.

What needs improvement?

DR capabilities need to be improved. For instance, unlike SAP ASE, there is no ability to replicate from IQ to IQ.

For how long have I used the solution?

I've used it for 10 years.

What was my experience with deployment of the solution?

No issues were experienced during deployment, however, we hit performance issues on Solaris which were eliminated when we migrated to the Linux platform.

What do I think about the stability of the solution?

With various patches of v15.4 and v16.0, we had instances where the IQ server crashed under certain circumstances. The vendor has addressed most of the issues though.

What do I think about the scalability of the solution?

None product-related and we were able to get around by tuning. Though as we add more data and more users we may have to consider IQ multiplex in the future.

How are customer service and technical support?

Customer Service:

7/10.

Technical Support:

9/10.

Which solution did I use previously and why did I switch?

We used ASE to store the data in IQ. We switched as IQ now allows us to centrally store the data in one place and in a compressed format.

How was the initial setup?

It's straightforward; IQ is one of the easiest DBMS to install.

What about the implementation team?

For our initial IQ server we had Sybase consultants, and we used them again for our migration to Linux. Their expertise was 7/10.

What was our ROI?

Hardware cost was the biggest savings, in the tens of thousands of dollars.

Which other solutions did I evaluate?

No, as since we had Sybase ASE we took their IQ product without evaluating any other options.

What other advice do I have?

IQ is a niche product and is good for data storage with it's massive compression ability and adhoc querying. With the emergence of in-memory databases and MPP platforms (like Cassandra, HANA, Greenplum,etc.). I see IQ being used as more of a data store than interacting with the end users or apps if shops chose to use these new technologies.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user261621
Sybase Tower Lead - DBA CoE at a marketing services firm with 1,001-5,000 employees
Vendor
The installer is very easy to understand, but the training available needs improvement.

Valuable Features

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

Improvements to My Organization

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.

Room for Improvement

Training and marketing are two areas where improvements are needed.

Use of Solution

I've used it for eight years.

Deployment Issues

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

Stability Issues

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

Scalability Issues

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 and Technical Support

Customer Service:

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

Technical Support:

It's good, 7/10.

Initial Setup

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.

Implementation Team

It's been in-house.

Pricing, Setup Cost and Licensing

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.

Other Advice

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.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
it_user257172
President at a tech consulting company with 51-200 employees
Consultant
​Sales and marketing need improving, but the product itself is the best in the industry.

What is most valuable?

The column architecture.

How has it helped my organization?

Analytical reporting has improved.

What needs improvement?

Sales and marketing – I just want to elaborate on this a little bit more. The product itself is the best in the industry, which I liked and would like to work with again. IT has a lot less maintenance to support the database and query performance is best; it's very easy to use.

For how long have I used the solution?

Around 13+ years.

What was my experience with deployment of the solution?

In older version of Sybase IQ we had a few issues, just like any other product, but as the maturity of the product has grown, we have had really good success with this product.

What do I think about the stability of the solution?

Not in the recent versions of Sybase IQ.

What do I think about the scalability of the solution?

No issues encountered.

How are customer service and technical support?

Customer Service:

Customer service is great, as we have global support for this product from Asia, when we are working nights to fix problems or troubleshoot issues. They are with us all the time and it is a very good transition from US support to Asia and back as we try to solve the problems round the clock.

Technical Support:

10/10.

Which solution did I use previously and why did I switch?

I used Sybase ASE and Microsoft SQL server heavily as Microsoft started off based on Sybase ASE, I was really comfortable with it. In between we tried DB2 and Teradata in different occasions and we went back to Sybase IQ for our operational and Analytical needs

How was the initial setup?

The initial setup at the very beginning of the early versions was a little complex but as time went on, it got better and better and very easy. As a DBA, supporting this system is the best.

What about the implementation team?

All my implementations are in-house for our company and we had group of DBA’s and Unix Administrators who helped us along. Our implementation was on Sun Solaris.

What was our ROI?

Very high, cost of implementing and maintain is very low and once installed and up and running, things will be just fine.

What's my experience with pricing, setup cost, and licensing?

This product is rightly priced, or even under priced, for what it can do and for sure costs much less than other RDBMS products and licensing. They have more than one model which could fit your organization size and they are more than happy to work with you on this.

Which other solutions did I evaluate?

  • Oracle
  • DB2
  • Teradata

What other advice do I have?

Come up with clear requirements and a problem statement and see what you are trying to solve with this new implementation. Look beyond current problems by at least three to five years and be proactive and addressing them. You also need your senior management to buy into your approach and budget constraints, otherwise it will be challenging to make it successful.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
ITCS user
Consultant at a tech services company with 51-200 employees
Consultant
I've used other RDBMS's in BI systems like MSSQL and Oracle. ASIQ has the best performance in data retrieval.

What is most valuable?

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

How has it helped my organization?

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.

What needs improvement?

Real Time.

What was my experience with deployment of the solution?

No.

What do I think about the stability of the solution?

No.

What do I think about the scalability of the solution?

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

How are customer service and technical support?

Customer Service: GoodTechnical Support: Good

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

The initial setup was straightforward.

What was our ROI?

Excellent

What other advice do I have?

Is the best choice when used as DW data repository because it combines high speed queries and lower TCO.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Relational Databases Report and find out what your peers are saying about SAP, Microsoft, Oracle, and more!