Server classes for remote data access

The server class you specify in the CREATE SERVER statement determines the behavior of a remote connection. The server classes give SAP Sybase IQ detailed server capability information. SAP Sybase IQ formats SQL statements specific to a server's capabilities.

All server classes are ODBC-based. Each server class has a set of unique characteristics that you need to know to configure the server for remote data access. You should refer to information generic to the server class category and also to the information specific to the individual server class.

The server classes include:

• SAODBC
• ULODBC
• ADSODBC
• ASEODBC
• DB2ODBC
• HANAODBC
• IQODBC
• MSACCESSODBC
• MSSODBC
• MYSQLODBC
• ODBC
• ORAODBC

• ODBC external server definitions
  The most common way of defining an ODBC-based remote server is to base it on an ODBC data source. To do this, you can create a data source using the ODBC Data Source Administrator.
• USING clause in the CREATE SERVER statement
  You must issue a separate CREATE SERVER statement for each remote SAP Sybase IQ database you intend to access. For example, if an SAP Sybase IQ server named TestSA is running on the computer Banana and owns three databases (db1, db2, db3), you would set up the remote servers similar to this:
• Server class SAODBC
  A remote server with server class SAODBC is an SAP Sybase IQ database server. No special requirements exist for the configuration of an SAP Sybase IQ data source.
• Server class ADSODBC
  When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding Advantage Database Server data types using the following data type conversions.
• Server class ASEODBC
  A remote server with server class ASEODBC is an Adaptive Server Enterprise (version 10 and later) database server. SAP Sybase IQ requires the installation of the Adaptive Server Enterprise ODBC driver and Open Client connectivity libraries to connect to a remote Adaptive Server Enterprise database server with class ASEODBC.
• Server class DB2ODBC
  A remote server with server class DB2ODBC is an IBM DB2 database server.
• Server class HANAODBC
  A remote server with server class HANAODBC is an SAP HANA database server.
• Server class IQODBC
  A remote server with server class IQODBC is an SAP Sybase IQ database server. No special requirements exist for the configuration of an SAP Sybase IQ data source.
• Server class MSACCESSODBC
  Access databases are stored in a .mdb file. Using the ODBC manager, create an ODBC data source and map it to one of these files. A new .mdb file can be created through the ODBC manager. This database file becomes the default if you don't specify a different default when you create a table through SAP Sybase IQ.
• Server class MSSODBC
  The server class MSSODBC is used to access Microsoft SQL Server through one of its ODBC drivers.
• Server class MYSQLODBC
  When you execute a CREATE TABLE statement, SAP Sybase IQ automatically converts the data types to the corresponding MySQL data types using the following data type conversions.
• Server class ODBC
  ODBC data sources that do not have their own server class use server class ODBC. You can use any ODBC driver. Sybase certifies the following ODBC data sources:
• Server class ORAODBC
  A remote server with server class ORAODBC is an Oracle Database version 8.0 or later.