We extensively use Toad for Oracle and DB2 at work (although I am NO expert!), however we are taking over a new area of responsibility and their data is pulled into SAS Mainframe. They have informed us that there is no connection from Oracle to SAS Mainframe available, so they are doing everything by EXCEL SPREADSHEETS! Please help me avoid this nightmare of having to run information out of SAS and putting it into excel only to load it into Oracle. Hoping someone can tell me whether or not you can connect Oracle to a SAS mainframe.
can you connect by ODBC? Toad can import data from ODBC.