Connecting to an Oracle Database

Connect Sybase IQ to remote Oracle data via Component Integration Services.

1. Create a server using the data source name from the .odbc.ini file:
   CREATE SERVER myora CLASS 'oraodbc' USING 'MyOra2'
2. Create an external login:
   CREATE EXTERNLOGIN DBA TO myora REMOTE LOGIN system IDENTIFIED BY manager
3. Confirm the connection:
   sp_remote_tables myora
4. Create a table of Oracle data:
   CREATE EXISTING TABLE my_oratable at 'myora..system.oratable'
5. Verify that the connection works by selecting data:
   SELECT * FROM my_oratable