Database server   A SQL Anywhere database is required at the consolidated and each remote site.

SQL Remote   To send and receive replication messages from database to database, SQL Remote must be installed at the consolidated site and the remote sites.

The SQL Remote Message Agent connects to the database server via a client/server connection. The SQL Remote Message Agent may run on the same computer as the database server or on a different computer.

Message system client software   SQL Remote uses existing message systems to transport replication messages.

If you are using a shared file or FTP message system, the message system is included with your operating system.

If you are using an SMTP email system, you must have an email client installed at the consolidated and each remote site.

Client applications   The client application can use ODBC, embedded SQL, or several other programming interfaces. Client applications do not have to know if they are using a consolidated or remote database. From the client application perspective, there is no difference. For specific details about the SQL Anywhere programming interfaces, see the list below:

• SQL Anywhere .NET support
• ODBC support
• OLE DB and ADO development
• Embedded SQL
• JDBC support
• Sybase Open Client support
• SQL Anywhere C API support
• Perl DBI support
• SQL Anywhere PHP extension
• Python support
• SQL Anywhere Ruby API support