SAP IQ Reviews

The column architecture.

Analytical reporting has improved.

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.

Around 13+ years.

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.

Not in the recent versions of Sybase IQ.

No issues encountered.

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.

10/10.

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

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.

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.

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

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.

• Oracle
• DB2
• Teradata

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.

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

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

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

We have been using the solution for about 10 years.

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

We did not encounter any issues with scalability.

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

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

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

Negotiate based on the features required.

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

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

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.

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.

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.

Almost six years.

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.

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

Yeah. The support needs much improvement.

I would rate them a six out of 10.

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.

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.

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.

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.

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

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

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.

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.

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

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.