Manage, Synchronize and Exchange Data
Spécifications techniques
SQL Anywhere
Base de données relationnelle fournissant de nombreuses fonctionnalités avancées
En savoir plus
Ultralite 17
Plateforme supportées pour le déploiement :
Apple iOS
- Android
- Windows Phone
- Windows Mobile
- Windows X86, X64 andet ARM
- Linux X86, X64 andet ARM
- Apple OS X
Fonctionnalité de la base de données
- Empreinte la mémoire de base de données: seulement 300 KB pour les appareils mobiles
- Synchronisation du client (avec synchronisation d'arrière-plan)
- Cryptage fort pour les fichiers de base de données et la communication client-serveur
- Intégrité référentielle, plusieurs tables join, opération UNION
- BLOB (binary large object)
- Notification d'événement
- Changement dynamique taille du cache
Capacité de base de données
- Taille de la base de données : seulement limité par l'espace de stockage disponible (jusqu'à 2GB)
- Taille de ligne : 16 KB, espace supplémentaire pour les données BLOB
- Taille de la Table : seulement limité par la taille de la BDD
- Nombre de tables par base de données : seulement limité par l'espace de stockage disponible
- Nombre de lignes par table : 16 millions
- Nombre de colonnes par 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
Composants Ultralite par Plateformes
| Composants | Microsoft Windows | Apple | Linux | ||||
|---|---|---|---|---|---|---|---|
| x86/x64 | Mobile | Android | iOS | OS X | Linux x6424 | Linux ARM | |
| Base de données UltraLite | X | X | X | X | X | X | X |
| Moteur UltraLite | X | X | |||||
| Runtime APIs | |||||||
| UL SQL embarqué | X | X | X | X | |||
| UL composant C++ | X | X | X | X | X | X | |
| UltraLite.NET | X | X | |||||
| UltraLite WinRT | X | ||||||
| UltraLiteJ | X | ||||||
| Synchronisation | |||||||
| 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).