Back to SQL Anywhere Studio for Mac OS X.

Communications
SQL Anywhere Studio’s Adaptive Server Anywhere provides Web-service support native to the database server. Introduced in Version 9.0, Adaptive Server Anywhere provides an HTTP server for exposing Web services increasing accessibility and reducing development efforts.  CodeXchange includes samples of using the HTTP server on Mac OS X. The client/server support includes automatic server discovery.

Synchronization
MobiLink offers a great deal of flexibility in synchronization. Using MobiLink, which is included with SQL Anywhere Studio, developers can quickly set up synchronization with a variety of ODBC databases including Sybase, Orable, IBM and Microsoft. CodeXchange includes samples of using the MobiLink on Mac OS X.

Resource Usage/Start-up
While a developer can create a Mac OS X Startup Item, for server style applications, you have the flexibility to utilize the auto-starting feature of Adaptive Server Anywhere. This feature enables applications to launch a personal server upon the initial database connection, saving resources on your Mac as the database server only runs when needed. See "Creating an Adaptive Server Anywhere Startup Item on Mac OS X" for more information.

Interfaces
SQL Anywhere Studio provides support for a variety of interfaces such as JDBC, ODBC, Perl, and PHP, which enable developers to create rich solutions with a variety of development tools. These tools can include:

There is support for DBI-Perl and PHP for Mac OS X. These resources are also on the SQL Anywhere Studio for Mac OS X.

Additional Development Tools
The following companies offer development tools that provide access via JDBC or ODBC or other common interfaces that can access Adaptive Server Anywhere on Mac OS X. You can build applications with best-of-breed tools, including:

• Servoy
• AquaFolder DataStudio
• SQL Grinder
• BlueWorld Lasso
• Real Basic

Deployment
Developers who need the support of multiple operating systems can rest easy. The SQL logic built with SQL Anywhere Studio, such as functions, stored procedures, triggers, and events developed on Mac OS X can be distributed to other operating systems (UNIX, Windows, and so on) with a simple file copy. This is very different from other systems where you have to rebuild the database upon installation/deployment. Enterprise solutions have never been so easily deployable.

Related Links