SAP SQL Anywhere Reviews & Insights

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.

Workhorse RDMS that performs well for workgroup installations (50-100 users). Works equally well in standalone and client/server scenarios.

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.

If you have a rather small amount of data, SAP SQL Anywhere is a good choice. It is fast and easy to use and it has a good user interface.

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.

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.

It is very good for managing SQL databases as well as hosting them for network-level access. I know there are many other types of services that it can be used to host but for the personal and network services, this software is efficient.

Our company uses the software to host our own database program where multiple users in an organization can connect to the database. This is very useful as our own database is commonly used by multiple individuals to make changes.

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.

It is well suited if an organization does not currently have a DB they are running. They can procure and run with SQL Anywhere. It is not suited if an organization currently runs a licensed DB such as MS, Oracle etc. except if they want to sync the DB's to have a more robust data center.

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.

This is a great database for small to mid-sized organizations looking for a powerful SQL database not looking to break the bank. Easy to use toolset and transact SQL.