Its ability to be used with minimal administration is a distinguishing feature in this role. For example, it is used in Intuit QuickBooks, in network management products, and in backup products. SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store.
Strong encryption is supported for both database files and client-server communication.
The engine supports stored procedures, user functions (using Watcom SQL, T-SQL, Java, or C/ C++), triggers, referential integrity, row-level locking, replication, high availability, proxy tables, and events (scheduled and system events). The product provides several standard interfaces ( ODBC, JDBC, and ADO.NET) and a number of special interfaces such as PHP and Perl. Database files are independent of the operating system, allowing them to be copied between supported platforms. SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX and Solaris. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.
SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP.
