SAP IQ Competitors and Alternatives

The top SAP IQ competitors are
  • SAP Adaptive Server Enterprise
  • Apache Hadoop
  • SQL Server
  • Oracle Database
  • SAP HANA
  • Oracle Exadata
Read reviews of SAP IQ competitors and alternatives
SQL Server Logo
Microsoft
Aimee White
Real User
Website and EComm at a retailer with 1,001-5,000 employees
Jun 01 2017

What do you think of SQL Server?

Where to start? Great range of admin tools (far outnumbers MYSQL) - I like the database tuning tools  Nice BI tools and integration ability.  Evolves quickly due to the monster support from MS Integrates with the rest of MS products (this is a plus and a minus, of course) Scalable - a few MBs up to petabytes.  High availability/failover clustering makes DR straightforward. Own reporting services - if you can't report on it, it's hard to manage.  Problems include - is it an MS product? Then licensing can be a pain if they do an audit.  Also, with AWS's offerings becoming so easy to set up, scale, and work at great speed, MS SQL probably needs to up its game massively if they are ever going to keep up, let alone fully compete with Amazon's database suite.
seniordb30a3
Real User
Senior DBA at a tech services company with 1,001-5,000 employees
Nov 22 2016

What is most valuable?

Its most valuable feature is the smart scan functionality. It allows for the queries to work faster. It offloads the stuff to the cell server,... more»

How has it helped my organization?

I like the consolidation of all the components in one feature. I like the fact that it's very specialized and you can go ahead and utilize it,... more»

What needs improvement?

A lot of the extra features they're adding are wonderful, but they're always putting a price on it, for example, the in-memory thing. For... more»

Which other solutions did I evaluate?

We did not previously use a different solution. It's a data warehousing product. I know you can use it for online transaction processing, but... more»

What other advice do I have?

If a friend asked me about Exadata, I would encourage them to go with it.
Naveen Karnam
Consultant
Software Architect at a tech services company with 10,001+ employees
Mar 18 2018

What is most valuable?

High throughput and low latency. We start with data mashing on Hive and finally use this for KPI visualization.

How has it helped my organization?

We start with data mashing on Hive and finally use this for KPI visualization. This intermediate step not only mashes data in the form that we want through data Cube slicing, but... more»

What needs improvement?

At the beginning, MRs on Hive made me think we should get down to Hadoop MRs to have better control of the data. But later, Hive as a platform upgraded very well. I still think a... more»

What other advice do I have?

I rate it an eight out of 10. It's huge, complex, slow. But does what it is meant for.

Sign Up with Email