ETL+ Source Driver for Oracle

Owned by Cortlandt _
Last updated: Aug 20, 2023
2 min read

Creates and manages Source Objects that connect to Oracle data bases. Work in progress.

Source Objects panel button toolbar. Part of the ETL page.
Source Objects panel toolbar

Add Source: New Oracle connection.

Properties: Maintain Oracle connection.

Refresh: Update source Oracle database metadata.

 

Where to Find in ETL+

 

Oracle Page

  • Alias. The name for the source object shown on the Source Objects panel. Unless customized the name will be automatically generated based on Oracle feed(URL).

  • Default / TNS.

  • Host name. Can be a IP address.

  • Port.

  • Login.

  • Password.

  • Back. Leave the page without saving or attempting to connect.

  • Connect. Connect to the Oracle source. Same function as Refresh.

  • Save. Save the configuration without attempting to connect.

Help

Change DataSource. Only shown when opened by Properties.

How to Add Oracle Connections

  1. Open the for the ETL+ entity to edit.

  2. Select Add Source > Oracle

For more see the Oracle Page section above.

How to Maintain Oracle Connections

  1. Open the for the ETL+ entity to edit.

  2. Select a Oracle based Source Object on the Source Objects panel.

  3. Select Properties > Oracle

For more see the Oracle Page section above.

Related ETL+ Pages

Position in the ETL+ Interface