Great workgroup RDMS at a fair price
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. …
Overview
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.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Pricing
N/A
Unavailable
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.
Entry-level set up fee?
- No setup fee
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Would you like us to let the vendor know that you want pricing?
15 people also want pricing
Alternatives Pricing
What is Microsoft SQL Server?
Microsoft SQL Server is a relational database.
N/A
Unavailable
What is Amazon RDS?
Amazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.
Product Details
- About
- Competitors
- Tech Details
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.
SAP SQL Anywhere Features
- Supported: Enhanced data synchronization
- Supported: Extended mobility
- Supported: Improved security with data encryption
SAP SQL Anywhere Competitors
SAP SQL Anywhere Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Comparisons
Compare with
Reviews and Ratings
(12)Attribute Ratings
Reviews
(1-5 of 5)Companies can't remove reviews or game the system. Here's why
December 11, 2021
Great workgroup RDMS at a fair price
Score 9 out of 10
Vetted Review
Verified User
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.
- 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
- 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.
- Powerful full-featured RDMS
- Little or no database administration required
- Scales well from the desktop to client/server installations with 50-100 users.
- Satisfies our requirements
- Limited online support
- Price is fair
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.
Score 9 out of 10
Vetted Review
Verified User
SAP SQL Anywhere is used across our organization. It is the database for our Point of Sale system. We have a rather small amount of data coming from 70 stores. SQL Anywhere helps us organize POS data, analyze and share. We find it fast and usually problem-free. It is also easy to get data through ODBC.
- It is fast
- User friendly interface
- Affordable cost
- 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
- It is cost effective
- It is fast
- Its interface is user-friendly
- It had a positive impact on budget
- Oracle Database and MySQL
SAP SQL Anywhere is well-suited when compared with cost/benefit ratio.
October 08, 2018
Sybase SQL Anywhere - better than a kick in the pants
We use SAP SQL Anywhere as the database for our core line-of-business application. We have both stand-alone and multi-user (enterprise) installations of this application. It is the repository of all our major transactional data, and as such is also the source for our data warehouse, which is a separate platform and environment.
- SQL compliant
- ODBC drivers available
- Simple implementation
- 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
- 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
Ultimately, a vendor chose SQL Anywhere as their database of choice for their application. I would go with Microsoft SQL Server instead, personally. Largely this is because the tools and support are far better. However, SQL Anywhere is an ODBC-compliant database and as such it is infinitely superior to the situation where app developers roll their own crummy proprietary data store.
April 03, 2018
SQL Anywhere
SQL is a global platform for any DB machine, and my ability to use SQL Anywhere across all DB platforms gives me the edge to get real time data, fast and deliverable, and easy to use when you understand your requirement as a function analyst to leverage such skills across all databases. I have used SQL Anywhere across MS, Oracle, Postgres and MySQL platforms, and I will say its a great skill to have and use.
I recently consulted for a company that already used MS DB and were thinking of switching its DB to SQL Anywhere. One of the challenges was the migration of stored procedures. These procedures will have to be evaluated and validated and probably re-written to suit current needs that they serve.
I recently consulted for a company that already used MS DB and were thinking of switching its DB to SQL Anywhere. One of the challenges was the migration of stored procedures. These procedures will have to be evaluated and validated and probably re-written to suit current needs that they serve.
- 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.
- 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.
There are several DB's services out there, it all depends on organization and process needs.
March 19, 2018
SQL anywhere!
This database is used organization-wide as the back end to an ARM solution we use as well as a data warehouse for BI and reporting.
- Easy to use
- Interfaces well with third-party tools
- No complaints
- It provides us the ability to make fluid business decisions based on real-time data.
- Oracle and MS SQL
Easier to use and implement than Oracle. Offers similar abilities to MS SQL with a lower cost of ownership. Small foot print to manage with powerful results.
30
Our ARM solutions is built on top of a SQL Anywhere database, so our users interact with the product through that application as well as other such as Crystal reports. On the admin side we not only support and use it with the aforementioned applications but with Crystal Server as well as utilizing the default SAP tools to are provided with the database.
1
I'd say that a basic understanding of TSQL is all you need to get started, obviously having at least some SQL experience is a plus but if your willing to learn and examine the many online training materials SAP offers you can use this product.
- ARM software, it's the heart of our operation and relies extensively on the database, thus we need a stable and reliable solution. We've run the solution on SQL anywhere for the better part of 12 years and had (knock on wood) no major issues.
- We utilize SQL anywhere to draw data out of the database to provide to clients and business associates, the built in tools not only allows us easy export capabilities but easy access to import data into tables.
- We utilize the database for data warehousing to meet all of our reporting needs, it meets or exceeds all of our needs.
- I like to use SQL anywhere as a Data transformation tool, inserting data into temporary tables, transforming it and then exporting it out. Its fast, easy and allows me a ton of flexibility.
Yes
We've had no real issues when upgrading for release to release, we've done a few and all have gone as smooth as one could ask.
- Continued SAP support
- from a feature stand point, we are still new into this release so we haven't found all the benefits as of yet.
No
No