SAP SQL Anywhere 17 – Features

SQL Anywhere has hallmarks in the area of embeddability, interoperability, performance out of the box, web operation, mobility, and security.

Embeddability

SQL Anywhere can be easily embedded inside other applications. It combines high performance with very small memory footprint. SQL Anywhere contains a range of features to enable self-management and maintenance in frontline environments, including features that enable optimization of computer resources, self-tuning for improved performance, and simplification of remote installation and support.

Interoperability

SQL Anywhere is available on many platforms, including Linux, Oracle Solaris, HP-UX, IBM AIX, and Mac OS X. Unique to SQL Anywhere, its database files can be copied between platforms. In addition, SQL Anywhere provides support for many smartphones using its UltraLite database technology for small devices. SQL Anywhere includes support for many common database interfaces, including ODBC, JDBC, ADO.NET, JavaScript, PHP, and Perl. Many popular application development tools can be used, including: Microsoft Visual Studio, SAP PowerBuilder, Eclipse, and various web tools. Stored procedures can be written in C/C++, Java, .NET, or Perl.

Performance out of the box

SQL Anywhere is designed to deliver outstanding performance, without ongoing tuning and administration. Features such as dynamic cache sizing, auto generation of statistics, a sophisticated query optimizer, parallel query processing, and materialized views mean that SQL Anywhere is ideal for environments that demand high performance but which have no on-site database administrator. By offering, On-Line Analytical Processing (OLAP) SQL Anywhere offers the ability to perform complex data analysis within a single SQL statement, increasing the value of the results, while improving performance by decreasing the amount of querying on the database.

Web operation

With a built-in HTTP server and web service support, XML features, full text search, and a PHP interface, SQL Anywhere is an ideal database for use in a web-based environment behind a web server.

Mobility

SQL Anywhere provides enterprise-caliber databases that operate on frontline systems and devices whether connectivity with enterprise systems is available or not. Its synchronization technologies ensure data can be exchanged efficiently over wireless and wired networks with backend databases, application servers, and messaging systems.

Data encryption and security

SQL Anywhere provides full end-to-end data security with 128-bit strong encryption of database tables, files, and communications streams between the application and the database, and the MobiLink synchronization stream. SQL Anywhere can audit data access, offers built-in user authentication, and can integrate with third-party authentication systems. SQL Anywherealso offers a FIPS-certified version of encryption via a separately licensed component.

Links | Documents | Downloads

Introducing SQL Anywhere 17 (New 2015): SAP Video
– SAP SQL Anywhere 17 Product Manual (New 2015)
– SAP SQL Anywhere Release 17 Facts
– Supported Platforms
– Technical Information
– Manuals

Feature SQL Anywhere 16

Click HERE for more information about SQL Anywhere 16.