Under the list of connections, select “Oracle Database”. On the right side, specify the Oracle server name, username and password ... the Oracle database you are connecting to. Select the table that ...

There are several ways to configure a database connection and several ways to perform an authentication. TNS configuration is the simplest, but it requires you to have the tnsnames.ora file somewhere ...