TrustRadius: an HG Insights company

SAP SQL Anywhere

Score7 out of 10

12 Reviews and Ratings

Get a Demo

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

Reviews

What users are saying about SAP SQL Anywhere.
View all reviews

Great workgroup RDMS at a fair price

Scott OelfkeView profile
Vice President Product Management in Corporate at LMKR (51-200 employees employees)

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

Orhan OrsView profile
Head Of Information Technology in Information Technology at Caffè Nero (1001-5000 employees employees)

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

Incentivized
David WilliamsView profile
Chief Information Officer in Information Technology at Pacific Smiles Group (501-1000 employees employees)

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

Incentivized
Kishion GuyahView profile
Supervisor, Application Support in Information Technology at Progeny Genetics, LLC (11-50 employees employees)

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

Incentivized
Nosa W.IView profile
Sr. SAP SD Project Lead / Consultant / in Information Technology at Pollock (201-500 employees employees)

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.

Related Products

Products similar to SAP SQL Anywhere that may also meet your needs.
All comparisons
Microsoft SQL Server
CompareLearn more
Oracle Database
CompareLearn more