A server with server class oraodbc is Oracle version 8.0 or higher.
See ”Server class oraodbc” in SQL Anywhere Server - SQL Usage.
Use only Sybase IQ servers running on Windows to access Oracle data. There is no 64-bit driver manager for Sybase IQ servers running on 64-bit UNIX systems.
Querying Oracle data using Sybase IQ servers
on 64-bit UNIX
This process tells how to create the two sets of proxy tables needed to query Oracle data in this situation.
Configure DirectConnect for Oracle to connect to Oracle.
Configure proxy tables in DirectConnect for Oracle.
Create a remote server in Sybase IQ using the ASEJDBC class to the server and the port number for DirectConnect for Oracle.
Use a CREATE EXISTING TABLE statement to create a proxy table pointing to the ASE proxy tables in DirectConnect for Oracle.
Loading Oracle data using Sybase IQ servers on
64-bit UNIX
For best performance when loading large data, access the remote database with a different method from that used for queries, as follows:
Create proxy tables in DirectConnect for Oracle.
Use the INSERT .. LOCATION statement to the proxy tables.
For details about INSERT .. LOCATION, see “Inserting from a different database” in Chapter 7, “Moving Data In and Out of Databases,” in System Administration Guide: Volume 1.
