SAP SQL Anywhere Features

Supports different database platforms and data types. Typically integrates with a variety of existing databases.

Administrators can access and organize data related to incidents to produce reports or make data more navigable.

Provides required reports to manage business. Provides adequate logging to troubleshoot and support auditing.

Application Programming Interface - Specification for how the application communicates with other software. API's typically enable integration of data, logic, objects, etc. with other software applications.

Supports compliance with PII, GDPR, HIPPA, PCI, and other regulatory standards.

Allows administrators to set user access privileges to permit approved parties to access sensitive data.

Requires a second level of authentication, such as sms messaging or customized tokens, to access data.

Documents the actions related to the database. Alerts users of incidents and abnormal activities and documents the access point.

Protects database and sensitive information from a variety of attacks and malware threats.

Protects sensitive data by disguising or encrypting data, keeping it usable by the organization and approved parties.

Perform ad-hoc or ongoing IT audits at different levels of the company.

Provides support for international character sets and full text search.

Supports multiple data types like primitive, structured, document etc.

Supports multiple procedural programming languages like PL/PGSQL, Perl, Python etc.

Available on multiple operating systems like Linux, Windows, MacOS etc.

Prevents other users and applications from accessing data while it is being updated to avoid data loss or update.

Allows permissions to be granted or revoked in the database, schema or table levels.

Built-in native encryption with enterprise key management.

Provides multi-factor authentication with certificates.

Provides data recovery functionality to protect and restore data in a database.

Allows multi-version concurrency control.

Handles workloads, from single machines to data warehouses or web services with many concurrent users.

Allows users to quickly retrieve data through various types of indexing like B-tree, hash table etc.

Helps interpret SQL queries and determine the fastest method of execution.

Data is organized as a set of tables with columns and rows like a table structure.

Allows users to create, update and retrieve data in a database.

Adheres to ACID (atomicity, consistency, isolation, durability), a set of database transaction properties.

Provides log-based or/and trigger-based replication.