Follow the steps below to connect to an Oracle table or view:

 

Bring up the Data Source Creation Wizard, by navigating to Data->New Connection.  Connect to Oracle 9i or higher, by clicking on Oracle 9i.

 

 

Set required connectivity information, including the server address, the username and password as well as the name of the database you wish to connect to.  Then click OK.

 

Finally, select the table or view from the list and click OK.  To preview the table, enable the Preview checkbox.

See Also