#1 most frequent
United States of America
70.5%227 installations of 322
What is SAP SQL Anywhere?
SAP®
SQL Anywhere® solutions aim to deliver enterprise-level data management and
synchronization capabilities. The solutions are designed to run in remote and
mobile environments on a wide range of small-footprint devices and in
real-world conditions.
Categories & Use Cases
Who Buys & Uses SAP SQL Anywhere
#2 most frequent
Canada
9.6%31 installations of 322
#3 most frequent
United Kingdom of Great Britain and Northern Ireland
3.4%11 installations of 322
Great workgroup RDMS at a fair price
Use Cases and Deployment Scope
We use SQL Anywhere with our GeoGraphix software for oil and gas exploration. It has been a workhorse RDMS for us for almost 25 years. It's fully ANSI SQL compliant, performs well, and handles relatively large data volumes (10,000,000 records per table). It also scales easily from a single consultant's desktop to an oil and gas major or NOC.
Pros
- 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
Cons
- Small user base makes finding information difficult.
- Third-party vendors don't support native connections to SQL Anywhere (TIBCO, ESRI). Although direct ODBC connections can be used successfully.
Most Important Features
- Powerful full-featured RDMS
- Little or no database administration required
- Scales well from the desktop to client/server installations with 50-100 users.
Return on Investment
- Satisfies our requirements
- Limited online support
- Price is fair
Alternatives Considered
Oracle Database
An affordable choice when you need a lightweight, robust RDBMS
Pros
- It is fast
- User friendly interface
- Affordable cost
Cons
- User interface is a little bit outdated
- May have some issues in connecting to different versions
- When syntax check enabled, the editor could be slow
Most Important Features
- It is cost effective
- It is fast
- Its interface is user-friendly
Return on Investment
- It had a positive impact on budget
Alternatives Considered
Oracle Database and MySQL
Other Software Used
Oracle Database, Amazon Web Services, Veeam Backup & Replication
Sybase SQL Anywhere - better than a kick in the pants
Pros
- SQL compliant
- ODBC drivers available
- Simple implementation
Cons
- Seems a lesser implementation of SQL than T-SQL / SQL Server
- Desktop version (vs. enterprise version) seems underpowered, like Access vs MS SQL rather than a desktop edition of an enterprise database
- Fewer experienced resources available with Sybase skills
Return on Investment
- 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
Alternatives Considered
Microsoft SQL Server, Oracle Database and MySQL
Other Software Used
Splunk Enterprise, NetSuite, Slack
A fair SQL database management software
Pros
- The ability to host network database services and the ability to manage them.
Cons
- Some features seem hard to use and do not have a clear reason what it is used for.
Return on Investment
- The software is considered essential for our own software to flourish in the current market.
SQL Anywhere
Pros
- It queries large set of data and has a speedy run time.
- With the rate at which data is going with Internet of All things, SQL Anywhere cuts across database applications outside of traditional data centers in which department data's are stored.
- The amazing thing about SQL Anywhere is the relational standard it maintains as a structured language that works across any DB. Yes, you might need to adopt some changes within the environment DB you are working; however, its important to know SQL itself to help archive data goals.
Cons
- 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.
