SQL Anywhere

SQL Anywhere
Developer(s)SAP
Stable release
17.0
TypeDatabase
Licenseproprietary license
Websitewww.sap.com/products/sql-anywhere.html

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.

Features

[edit]

SQL Anywhere can be run on Windows, Windows CE, Mac OS X, and various UNIX platforms, including Linux, AIX, HP-UX and Solaris. Database files are independent of the operating system, allowing them to be copied between supported platforms. The product provides several standard interfaces (ODBC, JDBC, and ADO.NET) and a number of special interfaces such as PHP and Perl. 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). Strong encryption is supported for both database files and client-server communication.

Uses

[edit]

SQL Anywhere is used in several contexts, including as an embedded database, particularly as an application data store. For example, it is used in Intuit QuickBooks,[1] in network management products, and in backup products. Its ability to be used with minimal administration is a distinguishing feature in this role. It can be used as a database server for work groups or for small or medium-sized businesses. It can also function as a mobile database. It includes scalable data synchronization technology that provides change-based replication between separate databases, including large server-based RDBMS systems.

Technologies

[edit]

SQL Anywhere Server is a high performing and embeddable relational database-management system (RDBMS) that scales from thousands of users in server environments down to desktop and mobile applications used in widely deployed, zero-administration environments.

Ultralite: UltraLite is a database-management system designed for small-footprint mobile devices such as PDAs and smart phones.

Mobilink: MobiLink is a highly-scalable, session-based synchronization technology for exchanging data among relational databases and other non-relational data sources.

QAnywhere: QAnywhere facilitates the development of robust and secure store-and-forward mobile messaging applications.

SQL Remote: SQL Remote technology is based on a store and forward architecture that allows occasionally connected users to synchronize data between SQL Anywhere databases using a file or message transfer mechanism.

History

[edit]

References

[edit]
  1. ^ "QuickBooks replaces its flat file system with SQL Anywhere from Sybase iAnywhere". Sybase.
  2. ^ "Sybase iAnywhere Announces the Release of SQL Anywhere 10". Sybase press release. August 7, 2006.
  3. ^ "Sybase iAnywhere Announces Availability of SQL Anywhere 11". Sybase press release. August 5, 2008.
  4. ^ "Sybase Advances its Mobile and Embedded Database Leadership Position with SQL Anywhere 12". Sybase press release. June 29, 2010.
  5. ^ "SAP Software Solutions | Business Applications and Technology". SAP.
  6. ^ "Archived copy" (PDF). Archived from the original (PDF) on 2014-02-11. Retrieved 2013-07-01.{{cite web}}: CS1 maint: archived copy as title (link)
  7. ^ "Announcing SQL Anywhere 17! | SAP Blogs". blogs.sap.com.
[edit]