Manage, Synchronize and Exchange Data

SQL Anywhere Main Components

UltraLite

The lightened version of SQL Anywhere

Learn More

SQL Anywhere

Relational database providing multiple advanced features

Learn More

Mobilink

Synchronization Components of SQL Anywhere solution

Learn More

Ultralite

Ultralite is a lightened version of SQL Anywhere, easy to use and with a very small memory footprint. It contains the main features necessary for mobile devices (smartphones, navigation systems, handheld devices, ATMs…) and support for standard interfaces (ODBC, ACO.NET, JDBC…).

Application development and integration

Ultralite includes multiple SDK that support multiple languages, APS, and programming languages and tools:

  • PowerBuilder
  • Visual Studio .NET
  • Visual Studio C++
  • MetroWerk Codewarrior
  • JDBC
  • Embedded SQL
  • PHP
  • Perl
  • Etc.

In a .NET environment, Ultralite integrates easily into C# code or VB.NET, as well as applications using .NET Compact Framework.

Taking into account Ultralite from the first phases of development, there’s no need to plan a specific installation for the database: a few files just need to be copied into a folder, which will then be deployed with the other application files.

Deployment: low resources and high performances

Ultralite inherits very high performances from SQL Anywhere and optimizes resource management thanks to its lightness. It supports devices without hard-drives, with limited memory and low speed CPUs: smartphones, handheld devices, ATMs, consumer electronics,  embedded systems, IoT…

Synchronization

With MobiLink technology, Ultralite can easily synchronize with a third-party database server: SQL Anywhere, Oracle, Microsoft SQL Server, IBM DB2, MySQL, SAP Adaptive Server Enterprise as well as databases compatible with ODBC such as SAP IQ.

Security

Ultralite encrypts data files with a 128 bit algorithm. Also, the communication flow between the Ultralite client and the server synchronization Mobilink are encrypted in HTTPS, which guarantees process synchronisation security

Ultralite or file system?

A possible alternative to Ultralite is the development of a system to manage proprietary files, to manage data on mobile devices.

Here’s a comparison of the advantages and disadvantages of the 2 solutions:

File System

Ultralite

Development Cost

High

Low (1 license to buy). No other effort needed, as Ultralite is a ready to use tool.

Maintenance Cost

High. Requires manual, recurring and costly tasks.

Low - Ultralite automates maintenance and administrative operations.

Security

Requires third party technology and tools.

Standard: Encrypts data in 128 bits and encodes communication with the server.

High availability
Failover

Requires extra development.

The High availability features of SQL Anywhere and Ultralite are proven and benefit from more than 20 years of expertise.

Integration and API

Requires the development of a  specific logic.

Support of ADO.NET and ODBC simplifies integration with other programs, in particular with data drive applications.

Synchronisation of data with the server

Manual synchronizations, or extra developments.

Ultralite can synchronize dozens of thousands of clients with the same server, thanks to excellent conflict management. The synchronization is configurable and adapts to most database server, Oracle or others.

Compare features by components

SQL Anywhere

SQL Anywhere is a relational database providing multiple advanced features such as: integrated referentials, stored procedures, proxy tables, row-level security, high availability, system event and user management, in-memory mode, intra-query parallelism, database mirroring, integration with LDAP directories, strong encryption, support of multiple interfaces, etc.

It can work as a local server for work-groups, small and medium enterprises, application distribution on a large scale and support zero-administration environments.

Easy installation

SQL Anywhere easily installs in 15 minutes, without impacting other applications and databases. A silent installation is possible when SQL Anywhere is embedded in the application.

Low consumption of resources and high performances

The genetic code of SQL Anywhere is issued from high performance products developed in the 90s by the Canadian company Watcom, such as the Watcom C++ compiler.

From the first versions of SQL Anywhere, the code optimisation translated into very high performances, associated to very low RAM and hard-drive consumption. This low usage of material resources allows for the use of existing machinery with limited performances and strongly reduces material investment needs when the system is scaled.

Another advantage of low consumption of resources is the capacity for SQL AAnywhere to work with all sorts of mobile handheld devices which facilitate the distribution of information on local databases and guarantees access to data anywhere and anytime, no matter the quality or the nature of the network’s environment.

On the other side of the needs spectrum, there are high performance systems. SQL Anywhere represents an excellent solution with low costs for medium and large businesses.

Facilitate deployment to multiple OS

SQL Anywhere is compatible with numerous operating systems: Windows x86 / x64, Windows CE / Mobile, Linux x86 / x64, UNIX, Mac OS…

SQL Anywhere easily allows for moving from one OS to another, or deploying one base on multiple OS - as it’s as simple as copying database files!

This allows, for example, to develop a Windows application, then to deploy it in a different production environment, or to scale later to another OS.

It’s also an excellent solution for software vendors that need to install their solution in various client environments.

More information on supported platforms can be found on this page.

Automatic Administration

SQL Anywhere automates the majority of administrative tasks to minise intervention needs from the administrator, while guaranteeing stable performances.

The administration efforts and operation costs are heavily lowered. It’s particularly important for SMEs, as well as for remote site administration or distributed systems for which the administrator is not always available but that have to guarantee the proper full-time functioning of the system.

Of course, performance tuning remains available at all moments.

Feature Description
Automatic Query Optimizer Selects automatically a productive execution plan for SQL queries in an efficient amount of time, and finds the best compromise between optimization and execution time.
Automatic DB Space management When the size of the data to be stored in the database increases, the size of the database is automatically adjusted. SQL Anywhere will free up space and reuse it whenever possible.
Automatic start / stop The database will automatically start & stop whenever needed. As a result, applications and users do not have to care if the database is already running or not.
Task scheduling and event handling Administrators can schedule tasks that will be performed automatically. Events will also be handled automatically.
Automatic recovery In case of unexpected interruption, for instance after a power issue, the system will automatically recover at the next database startup.
Dynamic cache sizing Performances will be automatically optimized by adjusting the size of the cache, based on previous usage statistics.
Table and Index defragmentation Table and Index defragmentation is automatically lowered while the database is in production.

Graphical exploration of the database and performances

Graphical exploration of the database and performances

With the SQL Anywhere console, explore the database structure and its main objects: stored procedures, functions, events.

It shows the execution map of SQL requests, the number of calls and the execution time of triggers, and the execution time of each line of code in a procedure; this facilitates their tuning and performance optimisation.

Architecture flexibility and scalability

Architecture flexibility and scalability

With SQL Anywhere easily evolve the system architecture, to go, for example, from a standalone application to a client/server application, then to a distributed system composed of multiple synchronised databases between them.

These evolutions don’t necessitate any codification of the database or applications that they use, which simplifies the scalability of enterprise applications as well as the deployment of packaged sales applications that need to automatically adapt to various client environments.

Security

To prevent data leakage or malicious access, SQL Anywhere includes a series of security features.

  • Data encryption with a 128 bit algorithm
  • To optimise resources and response time, encryption can be activated at file/table/column level.
  • Communication flows between the client and server are encrypted in HTTPS

Supported development tools, languages and interfaces

SQL Anywhere supports a large variety of development technologies:

  • PowerBuilder
  • Delphi
  • Visual Studio .NET
  • Visual C++
  • ASP.NET
  • PHP
  • JSP
  • Perl
  • ODBC / ODBC .Net
  • OLE DB / OLE DB .Net
  • JDBC
  • Sybase Open client
  • Etc.

Silent Installation

In Windows, you can call the setup of SQL Anywhere (InstallShield) from your application’s setup. In this case, SQL Anywhere installs at the same time as the application in a completely transparent way for the user, strongly simplifying deployment.

SQL Anywhere is the ideal solution for sales applications where the installation is automated to lower the effort needed by end users.

HTTP server and XML support

SQL Anywhere can act as a HTTP/HTTPS server. It also supports SOAP queries.

Enterprise-level performance and scalability

SQL Anywhere can process extremely quickly large volumes of data, using Enterprise level features such as snapshot isolation or materialized views.

SQL Anywhere also supports intra-query parallelism and 64 bit mode in Windows and Linux to optimise the use of multiple CPU. It thereby allows for scaling up to high performance systems such as parallel saves for rapid archiving of large volumes of data.

It’s also optimised for OLAP calls, thereby facilitating viewing, reporting and analysis of voluminous databases.

SQL Anywhere therefore supports thousands of users consulting multiple Terabyte databases, containing billions of records.

You can also consult this page, the results obtained by the TPC-C benchmark: where SQL Anywhere is classed first in terms of performance/price.

High availability

SQL Anywhere has mirroring features and clustering to guarantee database high availability. More information concerning SQL Anywhere’s high availability can be found here.

SQL Anywhere's high availability

Read-only scale-out

SQL Anywhere supports Read-only scale-out configurations, discharging the production database of reporting and consulting operations (read-only).

Migration from other databases

SQL Anywhere provides a tool to simplify the migration from Oracle, Microsoft SQL Server, IBM DB2 or SAP Adaptive Server Enterprise, etc.

SQL Anywhere Database Migration Wizard

Compare features by components

SQL Anywhere Features by Components

Feature Edge "Workgroup"1 Advanced
General
Maximum number of cores 8 Not limited
SQL Anywhere Server
Operating systems2 Windows
Linux
OS X
Windows
Linux
OS X
Solaris
AIX
HP-UX IA64
Options
High Availability n/a X
Monitoring Tool - development & testing X X
Monitoring Tool - production deployment n/a X
Read-Only Scale-Out n/a X
In-Memory Runtime n/a X
RSA Security X X
FIPS Security O X
MobiLink Synchronization Server
Operating systems2 Windows
Linux
OS X
Windows
Linux
OS X
Solaris SPARC
AIX


1 The Workgroup Edition has been renamed the Edge Edition
2 Please consult this page for a comprehensive listing of platforms supported for specific SAP SQL Anywhere components

Legend

  • X - Included feature
  • O - Paid option
  • U - Option included in User License model. Options not included in Core License model but available separately as per device licenses.
  • n/a - Option not available in this edition