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

Oracle Connection

Comments

Oracle Connection Comments

User fields

Oracle Connection User Fields

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

Used by

  1. Oracle Reader
  2. Oracle Writer
  3. Database Loop Action
  4. Sql Script Action
  5. Sql Data Check Action
  6. Check Connection Action
  7. SQL To Text Dynamic Action
  8. SQL To XML Dynamic Action
  9. SQL To Insert Dynamic Action
  10. SQL To Excel Dynamic Action
  11. SQL To QVD Dynamic Action
  12. SQL To QVX Dynamic Action
  13. Select Value Action
  14. SQL Record to Variables Action
  15. 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
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License