Overall Satisfaction with SAP SQL Anywhere
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
- 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.
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.