In DBSource, driver name is “Oracle”, and options is the SID
of the Oracle database instance you want to use. DBUsername is the Oracle
user name, and DBAuth is the password for the Oracle user.
To create a
new database, see
goodies/oracleCreate.sql
for more
information.
Configure your SQL clause like this:
DBSource dbi:Oracle:sid
DBUsername user
DBAuth password
Tip
To specify server name and
port directly without $ORACLE_HOME/network/admin/tnsnames.ora,
use:
dbi:Oracle:service_name=xe;host=10.20.30.40;port=1521