Skip to end of metadata
Go to start of metadata

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:

  1. Databases
  2. Synchronization, Messaging and Replication
  3. Administration Tools
  4. 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 WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64ARMSPARCx64x86x64PPCIA64
Personal database serverXXXXXXX
XXX26
Network database serverXXXXXXX
XXX26
Remote data accessXXXX
XX
X

External stored proceduresXX2XX
XX
XXX
Dynamic cache sizingXXXX
XX
XXX
C++ development toolsX
XXXXX
XXX
5.0 Compatibility DLLsX









International Resource Deployment KitXX








Accessibility enablementX









SamplesXXXXXXX
XXX
Sun JRE 1.7XXX
XX




RSA Encrypted Client-Server CommunicationsXXXXXXX
XXX
Java in the databaseXXXX
XX
XXX
Kerberos clientsX
X

XX
XXX
LDAP authenticationXXXX
XX

XX
OData componentsXXXX






ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64ARMSPARCx64x86x64PPCIA64
Interfaces
ODBC 3XXXX23XX23X23XXX23X23
OLE DBXX








ADO.NETXX








Embedded SQLXXXX23XX23X23XXX23X23
Open ClientXXX

X23
X
X23
SQL Anywhere JDBC 5XXXX23XX23XXXX23X23
jConnectXXXX23
X23XX
X23X23
PHPXXXXX





Perl DBDXXXXXXXX
XX
Database toolsXXXX23XX23X23X
X23X23
Database utilities
Histogram (dbhist)XX








Language (dblang)XX








Service creation (dbsvc)XXXXX





All other utilitiesXXXXXXXX
XX
ComponentsMicrosoft WindowsLinuxSun Solaris
Apple OS X
IBM AIXHP-UX
x86x64x86x64ARMSPARCx64x86x64PPCIA64
FIPS Approved Encrypted Client-Server CommunicationsXXXX






High availabilityXXXX
XXX
XX
Read-only scale-outXXXX
XXX
XX

UltraLite


ComponentsMicrosoft WindowsGoogleApple

x86/x64MobileAndroidiOSOS XLinux x64 24Linux ARM
UltraLite databasesXXXXXXX
UltraLite engineXX




Runtime APIs
UL embedded SQLXX

XX
UL C++ componentXX
XXXX
UltraLite.NETXX10




UltraLite WinRTX





UltraLiteJ

X



Synchronization
TCP/IPXX
XXXX
HTTP or HTTPSXXXXXXX
ActiveSync 8
X




RSA Encrypted MobiLink CommunicationsXXXXXXX
FIPS Approved Encrypted MobiLink CommunicationsX





Synchronization, Messaging and Replication



ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64ARMSPARCx64x86x64PPCIA64
MobiLink Server
MobiLink synchronization serverXX15
X
X27,34

XX
.NET synchronization logicXX15








Java synchronization logicXX15
X
X

XX18

Notifier 28

XX15
X
X

XX18
RSA Encrypted MobiLink CommunicationsXX15
X
X

XX
Samples
SamplesXX
X
X

X

Relay Server
Relay Server
X
X






MobiLink Profiler
MobiLink ProfilerXXXX
X

X

MobiLink Client
MobiLink client for SQL AnywhereXXXXXX

X

Listener

XX4








MobiLink ActiveSync provider 22

X









RSA Encrypted MobiLink CommunicationsXXXXXX
XX

FIPS Approved Encrypted MobiLink CommunicationsX

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 WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64SPARCx64x86x64PPCIA64
SAP SQL Anywhere 16.0 and 17.0XX15
XX

XX
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 19cXX15
XX


X
Microsoft SQL Server 2012, 2014, 2017, and 2019XX15







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


ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64SPARCx64x86x64PPCIA64
SQL Anywhere Message Agent (dbremote)XXX
X4
XX4

SQL Anywhere extraction utility (dbxtract)XXX
X4
XX4

File sharing message systemXXX
X4
XX4

FTP message system 17XXX
X4
XX4

SMTP/POP message system 17XXX
X4
XX4

HTTP/HTTPS message systemXXX
X4
XX4

SA encoding (dbencod)XXX
X4
XX4

Administration Tools


ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64x86x64ARMSPARCx64x86x64PPCIA64
Administration Tools
SQL CentralXXX21X
X

X16

Interactive SQLXXX21XX7XX7
X16X7X7
Database network server connections monitor (dbconsole) 30XXX21X
X

X16

Database and synchronization server monitor (SQL Anywhere Monitor)XXX21X






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 running on a version 17 database server.
  • 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.

  • No labels