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
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
Personal database server | X | X | X | X | X27 | X | X | X19 | X26 | ||
Network database server | X | X | X | X | X | X27 | X | X | X19 | 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 | X | |
C++ development tools | 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.6.0 | X | X | X | X | |||||||
RSA Encrypted Client-Server Communications | X | 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 32 | X | X | X | X | X | X | X | ||||
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
Interfaces | |||||||||||
ODBC 3 | X | X | X | X | X23 | X23 | X23 | X | X | X23 | X23 |
OLE DB | X | X | X | ||||||||
ADO.NET | X | X | X | ||||||||
Embedded SQL | X | X | X | X | X23 | X23 | X23 | X | X | X23 | X23 |
Open Client | X | X | X | X23 | X | X23 | |||||
iAnywhere JDBC 5 | X | X | X | X23 | X23 | X | X | X | X23 | X23 | |
jConnect | X | X | X | X23 | X23 | X | X | X23 | X23 | ||
PHP | X | X | X | X | |||||||
Perl DBD | X | X | X | X | X | X | X | X | X | ||
Database tools | X | X | X | X | X23 | X23 | X23 | X | X23 | X23 | |
Database utilities | |||||||||||
Histogram (dbhist) | X | X | |||||||||
Language (dblang) | X | X | |||||||||
Service creation (dbsvc) | X | X | X | X | |||||||
All other utilities | X | X | X | X | X | X | X | X | X | ||
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
Separately licensed components | |||||||||||
ECC Encrypted Client-Server Communications | 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 |
UltraLite
Components | Microsoft Windows | RIM | Apple | ||||||
x86/x64 | Mobile | PPC 2003 20 | BlackBerry | Android | iOS | Mac OS X | Java ME/SE | Linux x86 24 | |
UltraLite databases | X | X | X | X | X | X | |||
UltraLite engine | X | X | X | X | |||||
UltraLiteJ | X | X33 | X | X | |||||
Runtime APIs | |||||||||
UL embedded SQL | X9 | X | X | X | X | ||||
UL C++ component | X9 | X | X | X | X | X | |||
UL for M-Business Anywhere | X9 | X12 | |||||||
UltraLite.NET | X9 | X10 | X10 | ||||||
Synchronization | |||||||||
TCP/IP | X | X | X | X | X | X | |||
HTTP or HTTPS | X | X | X35 | X | X | X | X | X | X |
ActiveSync 8 | X14 | X14 | |||||||
RSA Encrypted MobiLink Communications | X | X | X35 | X | X | X | X | ||
Separately licensed components | |||||||||
ECC Encrypted MobiLink Communications | X | X | X | ||||||
FIPS Approved Encrypted MobiLink Communications | X | X |
Synchronization, Messaging and Replication
MobiLink
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
MobiLink Server | |||||||||||
MobiLink synchronization server | X | X15 | X | X15 | X27,34 | X | X19 | ||||
.NET synchronization logic | X | X15 | |||||||||
Java synchronization logic | X | X15 | X | X15 | X | X | X18 | ||||
Notifier 28 | X | X15 | X | X15 | X | X | X18 | ||||
RSA Encrypted MobiLink Communications | X | X15 | X | X15 | X | X | X | ||||
Samples | |||||||||||
Samples | X | X | X | X | X | X | |||||
Relay Server | |||||||||||
Relay Server | X | X | X | X | |||||||
MobiLink Monitor | |||||||||||
MobiLink monitor | X | X | X | X | X | X | |||||
MobiLink Client | |||||||||||
MobiLink client for SQL Anywhere | X | X | X | X | X | X | X | ||||
Listener 29 | X | X4 | X | ||||||||
MobiLink ActiveSync provider 22 | X | ||||||||||
RSA Encrypted MobiLink Communications | X | X | X | X | X | X | X | X | |||
Separately licensed components | |||||||||||
ECC Encrypted MobiLink Communications | X | X15 | X | X | X15 | X | X | ||||
FIPS Approved Encrypted MobiLink Communications | X | X15 | X | 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 Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
SAP SQL Anywhere 11 and 12 | X | X15 | X | X15 | X | X | X | ||||
SAP Adaptive Server Enterprise 15.0 and 15.5 | X | X15 | X | X15 | |||||||
SAP IQ 15.2 | X15 | X15 | |||||||||
Oracle 10g and 11g | X | X15 | X | X15 | X | X | |||||
Microsoft SQL Server 2005 and 2008 | X | X15 | |||||||||
IBM DB2 UDB LUW 9.5 and 9.7 | X | X15 | X | X15 | |||||||
MySQL 5.1 | X | X15 | X | X15 |
QAnywhere21
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
MobiLink synchronization server with Messaging enabled | X | X15 | X | X15 | X27 | X | X18, 19 | ||||
Agent | X | X | |||||||||
.NET API | X | X | |||||||||
C++ API | X | X | |||||||||
Java API | X | X25 | |||||||||
Samples (client) | X | X |
SQL Remote for SQL Anywhere
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
SQL Anywhere Message Agent (dbremote) | X | X | X | X | X4 | X | X4 | ||||
SQL Anywhere extraction utility (dbxtract) | X | X | X | X4 | X | X4 | |||||
File sharing message system | X | X | X | X | X4 | X | X4 | ||||
FTP message system 17 | X | X | X | X | X4 | X | X4 | ||||
SMTP/POP message system 17 | X | X | X | X | X4 | X | X4 | ||||
SA encoding (dbencod) | X | X | X | X4 | X | X4 |
Administration Tools
Components | Microsoft Windows | Linux | Sun Solaris | Apple Mac OS X | IBM AIX31 | HP-UX | |||||
x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | x64 | PPC | IA64 | |
Administration Tools | |||||||||||
Sybase Central | X | X6 | X | X6 | X | X | |||||
Interactive SQL | X | X6 | X | X6 | X | X7 | X | X7 | X7 | ||
Database network server connections monitor (dbconsole) 30 | X | X6 | X | X6 | X | X | |||||
Database and synchronization server monitor (Web-based SQL Anywhere Monitor) 1 | X | X | X | X | |||||||
PowerDesigner | X | ||||||||||
InfoMaker | X |
Compatibility with existing Sybase Central software
- Full support - The SQL Anywhere plug-in for Sybase Central fully supports any database created by version 10 or later software running on a version 10 or later server. For example, version 10 databases running on version 10, 11, or 12 servers; version 11 databases running on version 11 or 12 database servers; and version 12 databases running on a version 12 database server.
- Unload/reload-only support - For databases created by version 5, 6, 7, 8, or 9 software running on a version 6, 7, 8, or 9 database server, you can connect to the database from the SQL Anywhere plug-in temporarily to do one of the following tasks:
The files for the database being unloaded must be located on the local computer.
Documentation
The complete SQL Anywhere documentation is available in four formats:
- DocCommentXchange DocCommentXchange is a community for accessing and discussing SQL Anywhere documentation on the web. To access the documentation, go to http://dcx.sybase.com.
- 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).
- Eclipse On Unix platforms, the complete Help is provided in Eclipse format. To access the documentation, run sadoc from the bin32 or bin64 directory of your SQL Anywhere installation.
- 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 Unix operating systems, use a web browser to open /documentation/en/pdf/index.html under the SQL Anywhere installation directory.
Footnotes
1 The SQL Anywhere Monitor can be installed under Windows and Linux. The Web-based interface can be accessed on any platform with a JavaScript-enabled browser and the latest version of Adobe Flash Player.
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.
5 Requires JRE 1.4 or higher on Itanium chips. Requires JRE 1.3 or higher on other chips.
8 Requires Microsoft ActiveSync 3.1 or higher.
10 Requires .NET Compact Framework version 2.0 or 3.5.
11 Requires SQL Anywhere 11.0.1 build #2255 or higher.
12 Requires Windows Mobile 5 or later.
14 Not supported for M-Business Anywhere.
15 Only 64-bit MobiLink server components are supported on 64-bit operating systems.
18 Set LIBPATH to include the directory containing an installed JRE.
19 AIX 5.3 TL07 or higher required for IPv6 support. Only 64-bit software is supported.
20 Pocket PC 2003 support requires EBF #3484 or later.
21 QAnywhere does not support MySQL.
22 Requires Microsoft ActiveSync 3.5 or higher.
24 Tested on the following platforms:
- MontaVista Linux 4.0.1 (Linux version 2.6.10_mvl401-pc_target (gcc version 3.4.3 (MontaVista 3.4.3-25.0.70.0501961 2005-12-17)))
- SUSE Linux 10.0 (Linux version 2.6.13 (gcc version 4.0.2))
25 Requires IBM J9 Java virtual machine.
26 Requires HP Transport Optional Upgrade Release (TOUR) 3.1 or higher, available from http://software.hp.com.
27 Requires the following patches (or superseding ones). For Solaris 8: 109322-02, 108434-22, 108435-22, 111721-04. For Solaris 9: 111711-16, 111712-16, 111722-05. Please note that although we list patches for the specific issues that we encounter, it is not an exhaustive list and we recommend that you always install the OS patches suggested by the OS vendor. Only 64-bit software is supported.
28 Requires JRE 1.4.1 or higher
29 For a list of operating systems that the Listener was tested on, please refer to this document.
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, Mac OS X, or Linux).
32 A list of Kerberos clients tested with SQL Anywhere is available here: http://www.sybase.com/detail?id=1096369.
33 BlackBerry OS 4.1 or higher. BlackBerry OS 7 support requires EBF #3531 or later.
35 RSA TLS and HTTPS for Pocket PC 2003 requires EBF #3584 or later.