I am able to create database connection with Sybase and a separate database with Oracle. It appears TOAD for Data Analyst allows export of Sybase table to file, then import of file into Oracle table. But what I want to do is to export data from Sybase table to directly into Oracle table, using TOAD Data Analyst. Please advise.
You can do this in TDA version 2.7. Use the Import Wizard Add Query type. Here you can point to the Sybase table and import into Oracle.
See the video in this link. How to do this is about 9 minutes into the video.