Oracle Connection
For an Oracle connection, you will need to specify the TNS name required and provide the user name and password for the connection.
Connection
It is also possible to use Oracle instant client syntax: servername:1521/ORCL
User fields
Note: User fields provide a convenient way of storing additional data
Creating New Connection
- In the Name Text Box type in a new name for the connection you are about to create
- Select a TNS Name from the Server drop-down list or enter it manually
- Fill in Username/Password for the database you wish to connect to
- Click Test to ensure the details you have provided are correct
- Click OK to close the connection properties window
If you are unsure of these parameters, please contact your Database Administrator for the correct settings.
Used by
-
Oracle Reader
-
Oracle Writer
-
Database Loop Action
-
Sql Script Action
-
Sql Data Check Action
-
Check Connection Action
-
SQL To Text Dynamic Action
-
SQL To XML Dynamic Action
-
SQL To Insert Dynamic Action
-
SQL To Excel Dynamic Action
-
SQL To QVD Dynamic Action
-
SQL To QVX Dynamic Action
-
Select Value Action
-
SQL Record to Variables Action
-
SQL to Variables Action
For more technologies supported by our ETL Software see
Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Posted on January 15, 2025
•
2 min read •
227 words