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

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

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

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.

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).