SAP IQ Competitors and Alternatives

Read reviews of SAP IQ competitors and alternatives
Microsoft
Real User
IT Director at a construction company with 501-1,000 employees
Jun 05 2017

What is most valuable?

Apart from the standard SQL database-related features, the 2012 version enables the AlwaysOn functionality which enables two or more SQL Servers that can be clustered, with heartbeat across geographic locations along with high availability... more»

How has it helped my organization?

We have deployed three instances of the SQL Server, i.e., two at the primary datacenter and one at the disaster recovery facility. The AlwaysOn feature has ensured 100% database availability, even when one of the servers is down without any... more»

What needs improvement?

The Always ON (High Availability) functionality is support only with the MS SQL enterprise edition. It would be beneficial to many if this feature were also made available in the Standard Edition.
Real User
IT Manager / Chapter Lead for DEV Content BE at a insurance company with 5,001-10,000 employees
Nov 03 2016

What is most valuable?

I like the fact it works the most. It's reliable; it works well in Solaris in a UNIX system; that’s the most valuable feature.

What needs improvement?

The price is where it can be improved. It should be cheaper. Then, it would be more accessible to everybody because right now, it's actually only accessible for big corporations. If you want to try and do it yourself, it's not very easy. I know there is the free version, but it's very limited with the amount of memory and CPU power that you can use, which is,... more»
Real User
Senior Associate at a financial services firm with 10,001+ employees
Sep 17 2017

What do you think of Apache Hadoop?

Valuable Features Impala. As compared to Hive on MapReduce, Impala on MPP returns results of SQL queries in a fairly short amount of time, and is relatively fast when reading data into other platforms like R (for further data analysis) or QlikView (for data visualisation). • Improvements to My Organization The quick access to data enabled more frequent data backed decisions. • Room for Improvement The key shortcoming is its inability to handle queries when there is insufficient memory. This limitation can be bypassed by processing the data in chunks. • Use of Solution Two-plus years. • Stability Issues Typically instability is experienced due to insufficient memory, either due to a large job being triggered or multiple concurrent small requests. • Scalability...

Sign Up with Email