Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
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
  1. Administration Tools
  2. Documentation

 

 

 


 

 

 

Databases

 

SQL Anywhere

 

Note: SQL Anywhere 16 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 16 database server.

Components

Microsoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64ARMSPARCx64x86x64PPCIA64
Personal database serverXX XXXXX XXX26
Network database serverXXXXXXXX XXX26
Remote data accessXX XX XX X  
External stored proceduresXX2 XX XX XXX
Dynamic cache sizingXXXXX XX XXX
C++ development toolsX  XXXXX XXX
5.0 Compatibility DLLsX           
International Resource Deployment KitXX          
Accessibility enablementX           
SamplesXXXXXXXX XXX
Sun JRE 1.7XX X XX     
RSA Encrypted Client-Server CommunicationsXXXXXXXX XXX
Java in the databaseXX XX XX XXX
Kerberos clients 32X  X  XX XXX
LDAP authenticationXX XX XX  XX
OData componentsXX XX       
ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64ARMSPARCx64x86x64PPCIA64
Interfaces
ODBC 3XXXXX23XX23X23XXX23X23
OLE DBXXX         
ADO.NETXXX         
Embedded SQLXXXXX23XX23X23XXX23X23
Open ClientXX X  X23 X X23 
SQL Anywhere JDBC 5XX XX23XX23XXXX23X23
jConnectXX XX23 X23XX X23X23
PHPXX XXX      
Perl DBDXX XXXXXX XX
Database toolsXXXXX23XX23X23X X23X23
Database utilities
Histogram (dbhist)XX          
Language (dblang)XX          
Service creation (dbsvc)XX XXX      
All other utilitiesXX XXXXXX XX
ComponentsMicrosoft WindowsLinuxSun Solaris Apple OS X IBM AIXHP-UX
x86x64Mobilex86x64ARMSPARCx64x86x64PPCIA64
Separately licensed components            
FIPS Approved Encrypted Client-Server CommunicationsXX XX       
High availabilityXX XX XXX XX
Read-only scale-outXX XX XXX XX

UltraLite

 

ComponentsMicrosoft WindowsRIMGoogleApple 
x86/x64MobilePPC 2003BlackBerryAndroidiOSOS XJava ME/SELinux x64 24Linux ARM
UltraLite databasesXXX  XX XX
UltraLite engineXXX     X 
UltraLiteJX  X33X  X  
Runtime APIs
UL embedded SQLXXX   X X 
UL C++ componentXXX  XX XX
UltraLite.NETXX10X10       
Synchronization
TCP/IPXXX  XX X 
HTTP or HTTPSXXXXXXXXX 
ActiveSync 8 XX       
RSA Encrypted MobiLink CommunicationsXXX XXX X 
Separately licensed components
FIPS Approved Encrypted MobiLink CommunicationsXX        

Synchronization, Messaging and Replication

 

 

ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64ARMSPARCx64x86x64PPCIA64
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 ProfilerXX XX X  X  
MobiLink Client
MobiLink client for SQL AnywhereXXXXXXX  X  

Listener

XX4          

MobiLink ActiveSync provider 22

X           
RSA Encrypted MobiLink CommunicationsXXXXXXX XX  
Separately licensed components
FIPS Approved Encrypted MobiLink CommunicationsX

X15

XX

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 databasesMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64SPARCx64x86x64PPCIA64
SAP SQL Anywhere 12.0.1 and 16.0XX15  XX  XX 
SAP HANA 

X15

  X      
SAP Adaptive Server Enterprise 15.5 and 15.7 X15  X      
SAP IQ 15.4 X15  X      
Oracle 10g, 11g, and 12cXX15  XX   X 
Microsoft SQL Server 2008 and 2012XX15         
IBM DB2 UDB LUW 9.7 and 10.1 X15  X      
MySQL 5.1.3 and 5.5.16 X15  X      

SQL Remote for SQL Anywhere

 

ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64SPARCx64x86x64PPCIA64
SQL Anywhere Message Agent (dbremote)XXXX X4 XX4  
SQL Anywhere extraction utility (dbxtract)XX X X4 XX4  
File sharing message systemXXXX X4 XX4  
FTP message system 17XXXX X4 XX4  
SMTP/POP message system 17XXXX X4 XX4  
HTTP/HTTPS message system 17XXXX X4 XX4  
SA encoding (dbencod)XX X X4 XX4  

Administration Tools

 

ComponentsMicrosoft WindowsLinuxSun SolarisApple OS XIBM AIXHP-UX
x86x64Mobilex86x64ARMSPARCx64x86x64PPCIA64
Administration Tools
Sybase CentralXX X21X X  X16  
Interactive SQLXX X21XX7XX7 X16X7X7
Database network server connections monitor (dbconsole) 30XX X21X X  X16  
Database and synchronization server monitor (Web-based SQL Anywhere Monitor) 1XX X21X       
PowerDesignerX           

 

Compatibility with existing Sybase Central software

 

  • Full support - The SQL Anywhere plug-in for Sybase Central fully supports any database created by version 11 or later software running on a version 11 or later server. For example, version 11 databases running on version 11, 12, or 16 servers; version 12 databases running on version 12 or 16 database servers; and version 16 databases running on a version 16 database server.
  • Unload/reload-only support - For databases created by version 5, 6, 7, 8, 9, or 10 software running on a version 6, 7, 8, 9, or 10 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 16 database.
    • Unload and reload the database into an existing version 16 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
  • MobiLink 11.0.0 with at least the first EBF applied, 11.0.1, 12.0.0, 12.0.1, 16.0
  • Relay Server 12.0.0, 12.0.1, 16.0

 

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

 

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.

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 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 platform:

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

32 A list of Kerberos clients tested with SQL Anywhere is available here: http://scn.sap.com/docs/DOC-35935.

33 BlackBerry OS 4.1 or higher (except BB10).

34 64-bit Solaris SPARC only.

  • No labels