Manage, Synchronize and Exchange Data

SQL Anywhere Technical Specifications

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 17

Platforms supported for deployment:

  • Apple iOS
  • Android
  • Windows Phone
  • Windows Mobile
  • Windows X86, X64 and ARM
  • Linux X86, X64 and ARM
  • Apple OS X

Database features

  • Database memory footprint: only 300KB for mobile devices
  • Client synchronization (with background synchronization)
  • Strong encryption for both database files and client-server communication
  • Referential integrity, multiple tables join, UNION operation
  • BLOB (binary large object)
  • Event notification
  • Dynamic change cache size

Database capacity

  • Database size: only limited by storage space available (up to 2GB)
  • Row size: 16 KB, additional space for BLOB data
  • Table size: only limited by database size
  • Number of tables per database: only limited by storage space available
  • Number of lines per table: 16 millions
  • Number of columns per table: 65,535

SQL support

  • TIMESTAMP WITH TIMEZONE data type
  • INSERT, UPDATE, DELETE, SELECT
  • Multiple tables join
  • Subqueries
  • Wide range of SQL function
  • Aggregate functions
  • GROUP BY clause
  • UNION operation

Ultralite components by Platforms

Components  Microsoft Windows  Google Apple Linux
  x86/x64 Mobile Android  iOS  OS X Linux x6424 Linux ARM
UltraLite databases X X X X X X X
UltraLite engine X X          
Runtime APIs
UL embedded SQL X X     X X  
UL C++ component X X   X X X X
UltraLite.NET X X          
UltraLite WinRT X            
UltraLiteJ     X        
Synchronization
TCP/IP X X   X X X X
HTTP or HTTPS X X X X X X X
ActiveSync   X          
RSA Encrypted MobiLink Communications X X X X X X X
FIPS Approved Encrypted MobiLink Communications X            

SQL Anywhere 17

System requirements and supported platforms

  • Microsoft Windows x86 and X64
  • Linux X86, X64, and ARMv6
  • Oracle Solaris SPARC and X64
  • Apple OS X
  • IBM AIX
  • HP-UX Itanium
  • Minimum 512 MB RAM available on DB Server
  • Minimum 8 MB RAM available on the client (8 KB for Unix) + 4 KB for each client connection.

Client/Server communication protocol

  • TCP / IP
  • IPv6 support for Windows and Linux

Standards & Compliance

  • ANSI SQL-92 + extension
  • Few exceptions to the 2008 core specification
  • Transact-SQL (T-SQL)

Database features

  • Read-only scale-out database configuration
  • Web-based database server monitoring
  • Spatial data
  • Sequence generator
  • Row-level locking
  • Cost-based query optimization features with a self-tuning function in the high-performance
  • Advanced query execution algorithms
  • Dynamic cache size change
  • Materialized view
  • Snapshot isolation
  • Full-text search
  • Column compression
  • SQL and Java triggers and stored procedures
  • External ESQL, ODBC, Java, CLR ( .NET), Perl, of PHP stored procedures, JavaScript stored procedures
  • BLOB (binary large objects)
  • XML import / export and SQLX function
  • JSON support
  • Database mirroring and clustering
  • Online table and index defragmentation
  • Online backup
  • Event scheduling and processing
  • In-memory mode
  • support for Web services
  • Integrated HTTP / HTTPS server
  • Remote access and synchronization with other RDBMS and file systems
  • Support for OLAP queries
  • Integration with Windows performance monitor
  • Strong encryption of database files and network communications
  • Customizable audit, password policy, SHA-256 hash, Kerberos authentication
  • FIPS 140-2 Compliant
  • Role-based security
  • LDAP user authentication
  • Support for spatial data
  • Application profiling utility
  • Graphical schema design / reverse engineering tools
  • Graphical database management / browsing tools
  • Graphical query plan viewer, query editor, integrated stored procedure debugger, profiler, and synchronization monitoring tool, graphical spatial data viewer
  • Support for native data access (ADO.NET, OLE DB, ODBC3.5 ( level 2), JDBC 3.0, embedded SQL, via Open Client Sybase)
  • Support of a wide range of programming tool (SAP PowerBuilder® application development tools, Microsoft Visual Studio, Embarcadero Delphi, Eclipse, Node.js runtime environment, and many others)
  • Support for Microsoft .NET Framework Version 2.0 or later support
  • Support for a wide range of programming language (C #, VB.NET, C / C ++, ASP, ASP.NET, JSP, Java, PHP, Perl DBD, JavaScript) , etc.
  • TRY / CATCH error handling
  • OData server and OData producer

Database capacity

  • Max databases per Server: 255
  • Database size: only limited by storage space available (up to 2GB)
  • Row size: 16 KB, additional space for BLOB data
  • Table size: only limited by database size
  • Number of tables per database: only limited by storage space available
  • Number of indexes per table: up to 2,048
  • Field size: up to 2 GB
  • Number of rows per table: only limited by storage space available
  • Row size: only limited by storage space available
  • Number of columns per table: up to 4,000,000,000
  • Size of a stored procedure: up to 2 GB
  • Number of stored procedures per database: up to 4,000,000,000
  • Number of trigger per database: up to 4,000,000,000

SQL Anywhere components by Platforms

Components Microsoft Windows Linux Sun Solaris Apple OS X IBM AIXHPUX
  x86 x64 x86 x64 ARM SPARC x64 x86 x64 PPC IA64
Personal database server X X X X X X X   X X X
Network database server X X X X X X X   X X X
Remote data access X X X X   X X   X    
External stored procedures X X X X   X X   X X X
Dynamic cache sizing X X X X   X X   X X X
C++ development tools X   X X X X X   X X X
5.0 Compatibility DLLs X                    
International Resource Deployment Kit X X                  
Accessibility enablement X                    
Samples X X X X X X X   X X X
Sun JRE 1.7 X X X   X X          
RSA Encrypted Client-Server Communications X X X X X X X   X X X
Java in the database X X X X   X X   X X X
Kerberos clients X   X     X X   X X X
LDAP authentication X X X X   X X     X X
OData components X X X X              
Interfaces
ODBC X X X X X X X X X X X
OLE DB X X                  
ADO.NET X X                  
Embedded SQL X X X X X X X X X X X
Open Client X X X     X   X   X  
SQL Anywhere JDBC X X X X X X X X X X X
jConnect X X X X   X X X   X X
PHP X X X X X            
Perl DBD X X X X X X X X   X X
Database tools X X X X X X X X X X X
Database utilities
Histogram (dbhist) X X                  
Language (dblang) X X                  
Service creation (dbsvc) X X X X X            
All other utilities X X X X X X X X   X X
FIPS Approved Encrypted Client-Server Communications X X X X              
High availability X X X X   X X X   X X
Read-only scale-out X X X X   X X X   X X

Reference : http://scn.sap.com/docs/DOC-65219

MobiLink 17

Supported platforms

  • Windows x86 and X64
  • Linux X86 and X64
  • Linux ARMv6 (sync client only)
  • Solaris SPARC
  • Apple OS X
  • IBM AIX (synchronization server only)
  • HP-UX Itanium (synchronization server only)

Key features

  • Reliable, bidirectional synchronization between remote and enterprise systems including SQL Anywhere, Sybase Adaptive Server Enterprise, Oracle, Microsoft SQL Server, IBM DB2, application servers, ERP systems and Web services
  • Wizard-based synchronization configurations
  • Remote support for both SQL Anywhere and UltraLite databases
  • Multiple synchronization and network server-based protocols including TCP/IP, HTTP, HTTPS, Palm HotSync, Microsoft ActiveSync
  • Optional strong 128-bit encryption for synchronization communication, including SSL/TLS using RSA encryption compatible with HTTP server
  • Advanced conflict detection and programmable resolution
  • Optimized for wireless synchronization
  • Scalable to support thousands of remote databases from a single MobiLink server
  • Support for horizontal and vertical subsetting of data
  • Priority-based synchronization of multiple subsets of data
  • File transfer
  • Server-initiated synchronization and notifications
  • Broadcast downloads for bandwidth efficiency
  • Embeddable synchronization logic using SQL, Java or Microsoft Visual Studio .NET
  • Flexible user authentication logic
  • LDAP user authentication
  • Multi-threaded network processing
  • Offline OData
  • End-to-end communication encryption

MobiLink components by Platforms

Components Microsoft Windows Linux Sun Solaris Apple OS X IBM AIX HPUX
  x86 x64 x86 x64 ARM SPARC x64 x86 x64 PPC IA64
MobiLink Server
MobiLink synchronization server X X   X   X     X X  
.NET synchronization logic X X                  
Java synchronization logic X X   X   X     X X  
Notifier X X   X   X     X X  
RSA Encrypted MobiLink Communications X X   X   X     X X  
Samples
Samples X X   X   X     X    
Relay Server
Relay Server   X   X              
MobiLink Profiler
MobiLink Profiler X X X X   X     X    
MobiLink Client
MobiLink client for SQL Anywhere X X X X X X     X    
Listener X X                  
MobiLink ActiveSync provider X                    
RSA Encrypted MobiLink Communications X X X X X X   X X    
FIPS Approved Encrypted MobiLink Communications X X X X              

Reference : http://scn.sap.com/docs/DOC-65219

For a list of platforms that can run the Relay Server and a list operating systems that it was tested on, please refer to this document.


Consolidated databases Microsoft Windows Linux Sun Solaris Apple OS X IBM AIX HPUX
  x86 x64 x86 x64 SPARC x64 x86 x64 PPC IA64
SAP SQL Anywhere 12.0.1, 16.0 and17.0 X X   X X     X X  
SAP Adaptive Server Enterprise 15.5 and 15.7   X   X            
SAP IQ 15.4   X   X            
Oracle 11g and 12c X X   X X       X  
Microsoft SQL Server 2012 and 2014 X X                
IBM DB2 UDB LUW 9.7 and 10.1   X   X            
MySQL 5.1.3 and 5.5.16   X   X            

Reference : http://scn.sap.com/docs/DOC-65219

(For data synchronization with SAP HANA, MobiLink is now integrated into the HANA Platform as the SAP HANA remote data sync offering).