The following tables list components that are available across each platform supported by SAP SQL Anywhere. Note that, with a few exceptions, components that are available in all supported platforms are not listed. For ease of reading, the platforms are grouped by operating system vendor, operating system name and processor architecture.
Information about support for a specific operating system version is located at SAP SQL Anywhere Supported Platforms and Engineering Support Status.
The following tables are available:
- Databases
- Synchronization, Messaging and Replication
- Administration Tools
- Documentation
Databases
SQL Anywhere
Note: SQL Anywhere 17 database servers support connections from client applications using software from version 6.0.0 or later. Version 5 and earlier clients cannot connect to a version 17 database server.
Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | |||||
| x86 | x64 | x86 | x64 | ARM | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| Personal database server | X | X | X | X | X | X | X | X | X | X26 | |
| Network database server | X | X | X | X | X | X | X | X | X | X26 | |
| Remote data access | X | X | X | X | X | X | X | ||||
| External stored procedures | X | X2 | 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 | |||||||
| Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | |||||
| x86 | x64 | x86 | x64 | ARM | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| Interfaces | |||||||||||
| ODBC 3 | X | X | X | X23 | X | X23 | X23 | X | X | X23 | X23 |
| OLE DB | X | X | |||||||||
| ADO.NET | X | X | |||||||||
| Embedded SQL | X | X | X | X23 | X | X23 | X23 | X | X | X23 | X23 |
| Open Client | X | X | X | X23 | X | X23 | |||||
| SQL Anywhere JDBC 5 | X | X | X | X23 | X | X23 | X | X | X | X23 | X23 |
| jConnect | X | X | X | X23 | X23 | X | X | X23 | X23 | ||
| PHP | X | X | X | X | X | ||||||
| Perl DBD | X | X | X | X | X | X | X | X | X | X | |
| Database tools | X | X | X | X23 | X | X23 | X23 | X | X23 | X23 | |
| 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 | |
| Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | |||||
| x86 | x64 | x86 | x64 | ARM | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| 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 | ||
UltraLite
| Components | Microsoft Windows | Apple | |||||
| x86/x64 | Mobile | Android | iOS | OS X | Linux x64 24 | 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 | X10 | |||||
| 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 8 | X | ||||||
| RSA Encrypted MobiLink Communications | X | X | X | X | X | X | X |
| FIPS Approved Encrypted MobiLink Communications | X | ||||||
Synchronization, Messaging and Replication
MobiLink
| Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | |||||
| x86 | x64 | x86 | x64 | ARM | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| MobiLink Server | |||||||||||
| MobiLink synchronization server | X | X15 | X | X27,34 | X | X | |||||
| .NET synchronization logic | X | X15 | |||||||||
| Java synchronization logic | X | X15 | X | X | X | X18 | |||||
Notifier 28 | X | X15 | X | X | X | X18 | |||||
| RSA Encrypted MobiLink Communications | X | X15 | 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 | X4 | |||||||||
MobiLink ActiveSync provider 22 | X | ||||||||||
| RSA Encrypted MobiLink Communications | X | X | X | X | X | X | X | X | |||
| FIPS Approved Encrypted MobiLink Communications | X | X15 | X | X15 | |||||||
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.
The MobiLink server communicates with the consolidated databases through an ODBC driver. The ODBC driver may not be available for some consolidated databases on some platforms. The consolidated database and MobiLink server are not required to run on the same platform. Provided the consolidated database is running on a supported platform as specified by the database vendor, and the MobiLink server is communicating with the consolidated database using a supported ODBC driver, this is considered a supported MobiLink server configuration. The following table lists the platforms that can run the MobiLink server for supported consolidated databases.
For more details about the ODBC drivers, please refer to the document Recommended ODBC Drivers for MobiLink.
Consolidated databases | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | ||||
| x86 | x64 | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| SAP SQL Anywhere 16.0 and 17.0 | X | X15 | X | X | X | X | ||||
| SAP HANA 1.0 and 2.0 | X | X | ||||||||
| SAP Adaptive Server Enterprise 15.7 and 16.0 | X15 | X | ||||||||
| SAP IQ 15.4 and 16.0 | X15 | X | ||||||||
| Oracle 11g, 12.1, 18c, and 19c | X | X15 | X | X | X | |||||
| Microsoft SQL Server 2012, 2014, 2017, and 2019 | X | X15 | ||||||||
| IBM DB2 UDB LUW 9.7, 10.5, and 11.5 | X15 | X | ||||||||
| MySQL 5.5.16 and 5.6.20 | X15 | X | ||||||||
SQL Remote for SQL Anywhere
| Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | ||||
| x86 | x64 | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| SQL Anywhere Message Agent (dbremote) | X | X | X | X4 | X | X4 | ||||
| SQL Anywhere extraction utility (dbxtract) | X | X | X | X4 | X | X4 | ||||
| File sharing message system | X | X | X | X4 | X | X4 | ||||
| FTP message system 17 | X | X | X | X4 | X | X4 | ||||
| SMTP/POP message system 17 | X | X | X | X4 | X | X4 | ||||
| HTTP/HTTPS message system | X | X | X | X4 | X | X4 | ||||
| SA encoding (dbencod) | X | X | X | X4 | X | X4 | ||||
Administration Tools
| Components | Microsoft Windows | Linux | Sun Solaris | Apple OS X | IBM AIX | HP-UX | |||||
| x86 | x64 | x86 | x64 | ARM | SPARC | x64 | x86 | x64 | PPC | IA64 | |
| Administration Tools | |||||||||||
| SQL Central | X | X | X21 | X | X | X16 | |||||
| Interactive SQL | X | X | X21 | X | X7 | X | X7 | X16 | X7 | X7 | |
| Database network server connections monitor (dbconsole) 30 | X | X | X21 | X | X | X16 | |||||
| Database and synchronization server monitor (SQL Anywhere Monitor) | X | X | X21 | X | |||||||
Compatibility with existing SQL Central (formerly Sybase Central) software
- Full support - The SQL Anywhere plug-in for SQL Central fully supports any database created by version 12 or later software running on a version 12 or later server. For example, version 12 databases running on version 12, 16 or 17 servers; version 16 databases running on version 16 or 17 database servers; and version 17 databases built with the current or earlier versions of your version 17 database server. For example, a database built with version 17.0.10 is not supported by a version 17.0.9 database server.
The SQL Anywhere plug-in for SQL Central fully supports any version of the database server that is at the same version as the plugin or an earlier release of 17, 16 or 12. Newer versions of the database server may not be supported. For example, version 17.0.10 is newer than version 17.0.9. - Unload/reload-only support - For databases created by version 5, 6, 7, 8, 9, 10 or 11 software running on a version 6, 7, 8, 9, 10 or 11 database server, you can connect to the database from the SQL Anywhere plug-in temporarily to do one of the following tasks:
- Unload the database into a reload file.
- Unload and reload the database into a new version 17 database.
- Unload and reload the database into an existing version 17 database.
- The files for the database being unloaded must be located on the local computer.
- No support - There is no support in the SQL Anywhere plug-in for databases created by version 4 or earlier software running on a version 5 or earlier server.
SQL Anywhere Monitor Supported Versions
You can use the Monitor to collect metrics about the following versions of SQL Anywhere databases, MobiLink servers, MobiLink server farms, and Relay Server farms:
- SQL Anywhere 11.0.0, 11.0.1, 12.0.0, 12.0.1, 16.0, 17.0
- MobiLink 11.0.0 with at least the first EBF applied, 11.0.1, 12.0.0, 12.0.1, 16.0, 17.0
- Relay Server 12.0.0, 12.0.1, 16.0, 17.0
Documentation
The complete SQL Anywhere documentation is available in three formats:
- SAP Help Portal The most up to date version of the SQL Anywhere documentation can be found at https://help.sap.com/viewer/product/SAP_SQL_Anywhere/17.0/en-US.
- HTML Help On Windows platforms, the HTML Help contains the complete SQL Anywhere documentation, including the books and the context-sensitive help for SQL Anywhere tools.
- To access the documentation, choose Start » Programs » SQL Anywhere » Documentation » HTML Help (English).
- PDF The complete set of SQL Anywhere books is provided as a set of Portable Document Format (PDF) files. You must have a PDF reader to view information.
- To access the PDF documentation on Windows operating systems, choose Start » Programs » SQL Anywhere » Documentation » PDF (English).
- To access the PDF documentation on Linux, Unix and OS X operating systems, use a web browser to open /documentation/en/pdf/index.html under the SQL Anywhere installation directory.
Footnotes
2 The older interface to external stored procedures is available only in 32-bit software.
3 ODBC driver manager may not be available. May have to link directly to ODBC driver.
4 32-bit software.
5 Requires JRE 1.6 or higher.
7 Does not include certain features, compared to the admin tools provided on other operating systems.
8 Requires Microsoft Windows Mobile Device Center or ActiveSync 3.1 or higher.
10 Requires .NET Compact Framework version 2.0 or 3.5.
12 Requires Windows Mobile 5 or later.
15 Only 64-bit MobiLink server components are supported on 64-bit operating systems.
16 You must install Java if you want to use this component. It is available from http://www.oracle.com/technetwork/java/index.html.
17 For all systems other than the file or http sharing system, you must have purchased and installed the appropriate message system software for SQL Remote to function over this system. SQL Remote does not include the underlying message system software.
18 Set LIBPATH to include the directory containing an installed JRE.
21 Only 64-bit administration tools supported on 64-bit Linux.
22 Requires Microsoft Windows Mobile Center or ActiveSync 3.5 or higher.
23 32-bit and 64-bit clients.
24 Tested on the following platforms: Ubuntu 12.04, kernel 3.2.0-23-generic, glibc 2.15
26 Requires HP Transport Optional Upgrade Release (TOUR) 3.1 or higher, available from http://software.hp.com.
28 Requires JRE 1.7 or higher
30 For Windows CE, Solaris x64, AIX, HP-UX, and Linux Itanium: On these platforms you can use the connection, database, and server properties to obtain information or you can monitor your server from a computer running an operating system that supports the SQL Anywhere Console (such as Windows XP/200x, OS X, or Linux).
33 BlackBerry OS 4.1 or higher (except BB10).
34 64-bit Solaris SPARC only.