SAP IQ vs SAP SQL Anywhere

Likelihood to Recommend

Does data compression very well, produces query results very quickly, ability to scale up as data volume/size grow in an organization, row level versioning is in memory and hence the speed. It is a very stable product for large enterprises. More detailed documentation on how to use this product in the initial stages would be really welcome.

Read full review

Verified User

Executive in Information Technology

Computer Software Company, 1001-5000 employees

View all 3 answers on this topic

SAP SQL Anywhere is better than not using a database, let's be clear there! However, I wouldn't pick it as my first or even second or third choice. I'd recommend looking at other options. Largely, it appears less powerful both in terms of its robustness and general performance and in its implementation of SQL. The standard Sybase utilities provided are lacking in basic features, and the interactive SQL utility is quite horrendous. However, the great thing is it is an ODBC-compliant SQL-compliant relational database.

Read full review

David Williams

Chief Information Officer

Pacific Smiles GroupHealth, Wellness and Fitness, 501-1000 employees

View all 6 answers on this topic

Pros

Inserting millions of rows of data takes seconds.
Aggregating billions of rows of data is insanely fast (compared to Oracle, Sybase, and SQL Server).

Read full review

Zhann Goloborodko

Senior Programmer/Analyst

Investment Company InstituteFinancial Services, 51-200 employees

View all 3 answers on this topic

Good performance with relatively large data sets - its cost-based query optimizer is particularly robust
ANSI SQL compliant
Supports T-SQL
Scales well between the desktop (single user) and client/server installations supporting 50-1000 users

Read full review

Scott Oelfke

Vice President Product Management

LMKROil & Energy, 51-200 employees

View all 6 answers on this topic

Cons

The pricing schedule is a bit expensive and cumbersome.
Licensing for a virtual machine is difficult to understand.

Read full review

Eirik Toft

Systems Administration Spec IV

XO CommunicationsTelecommunications, 10,001+ employees

View all 3 answers on this topic

I think it should be more user friendly for non-technical users.
More functional functionalities should be added to the object explore when working with a table to transform data/manipulate data.

Read full review

Nosa W.I

Sr. SAP SD Project Lead / Consultant /

PollockWholesale, 201-500 employees

View all 6 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Starting Price

—

Likelihood to Renew

No score

No answers yet

No answers on this topic

SAP SQL Anywhere 10.0

Based on 1 answer

Ease of use, relationship to existing software's used in house and familiarity with the product

Read full review

Jeff Hieber

Director Information Tech

J Hieber ConsultingComputer Software, 11-50 employees

View all 1 answers on this topic

Support Rating

SAP IQ 10.0

Based on 2 answers

SAP IQ support is top-notch. I prefer starting all my SAP IQ support tickets with their Instant Messenger, where the majority of our issues are resolved. If it makes it to their ticketing system, they are very prompt at responding and very knowledgeable in the platform.

Read full review

Zhann Goloborodko

Senior Programmer/Analyst

Investment Company InstituteFinancial Services, 51-200 employees

View all 2 answers on this topic

No score

No answers yet

No answers on this topic

Alternatives Considered

SAP IQ is perhaps an under-marketed product in the sense that it is able to scale up very well and perform much faster and more efficiently than other products such as Oracle - when we ran multiple large queries on both Sybase IQ and Oracle, we found that that results were much faster in Sybase IQ and this gave the confidence to go for this product.

Read full review

Verified User

Executive in Information Technology

Computer Software Company, 1001-5000 employees

View all 3 answers on this topic

I worked with Oracle for years during my career. I wouldn't select SQL Anywhere to implement a global ATM system with tens of thousands of concurrent connections, but SQL Anywhere is much easier to use and deploy and works very well in workgroup settings. Query performance often exceeds some Oracle versions without having to rely on database tuning.

Read full review

Scott Oelfke

Vice President Product Management

LMKROil & Energy, 51-200 employees

View all 6 answers on this topic

Return on Investment

The ROI over a number of years has been good. Seeing as how we use it for billing, it has an obvious ROI to us.
As they have been modifying their licensing structure, it's been difficult to keep up and understand how they work.

Read full review

Eirik Toft

Systems Administration Spec IV

XO CommunicationsTelecommunications, 10,001+ employees

View all 3 answers on this topic

Skilled/experienced resources are less prominent than Microsoft SQL Server or even Oracle, or MySQL, so finding solutions and assistance, if needed, takes more time than it would with other platforms
You will need to find a good SQL query tool by yourself because the Sybase Central / Interactive SQL utilities are lacking in many basic features, and just generally have a bad user interface

Read full review

David Williams

Chief Information Officer

Pacific Smiles GroupHealth, Wellness and Fitness, 501-1000 employees

View all 6 answers on this topic

SAP IQ vs SAP SQL Anywhere

SAP IQ

SAP SQL Anywhere

Attribute Ratings

Likelihood to Recommend

SAP IQ

SAP SQL Anywhere

Likelihood to Renew

SAP IQ

SAP SQL Anywhere

Support Rating

SAP IQ

SAP SQL Anywhere

Pros

Cons

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Starting Price

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Starting Price

Likelihood to Renew

Support Rating

Alternatives Considered

Return on Investment

Add comparison