Oracle Reader

Reading data from an Oracle data base

Important: The out of the box Oracle Reader only works with the 32 Bit version of NFT, and only on Windows Operating Systems!

In order to read data from an Oracle database, use the following source definition:

<Source config="[configuration]">oracle://[SQL query]</Source>

Any SQL query which is supported by Oracle can be passed into the SQL Query parameter. All resulting fields will be interpreted as strings.

For the configuration, there are two possibilities:

• Using a connection string directly
• Using a connection string which is located in a text file

Using a connection string directly

Pass the connection string directly into the configuration of the source tag:

<Source config="Data Source=MyOracleDB;Integrated Security=yes">oracle://select * from MyTable where wage &gt; 1000</Source>

Parameters can be used inside the connection string, if needed.

Please note the use the substitution of the greater (>, >) operator in the SQL query (needed for XML compliance).

Using a connection string inside a text file

In order to read the connection string from a file, use the following syntax (using the @ character):

<Source config="@oracle_connection.txt">oracle://select * from MyTable where wage &gt; 1000</Source>

Sample content of the oracle_connection.txt file, also using a parameter (§env§):

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=§env§)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=MyOracleSID)));
User Id=myUsername;Password=myPassword;

Sample Connection Strings

See https://www.connectionstrings.com/oracle/