Breadcrumbs

ETL+ Source Driver for Oracle

Creates and manages that connect to Oracle data bases. 🛠️ Work in progress.

v2026.01

Oracle Page

image-20250129-005737.png
Source Objects panel toolbar

Add Source: New Oracle connection.

Properties: Maintain Oracle connection.

Refresh: Update source Oracle database metadata.

Where to Find in ETL+
image-20260218-054837.png

  • 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).

  • Schema: Check this box if you want all target tables from this source to be assigned into a SQL schema named <Schema Name>.

  • Default / TNS.

  • Host name. Can be a IP address.

  • Port.

  • Login.

  • Password.

  • Device: Be sure to set the Device to a computer with direct access to the Oracle Db.

  • 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.

image-20230813-001241.png

Help
image-20230813-001426.png

Change DataSource. Only shown when opened by Properties.

How to Add Oracle Connections

  1. Open the ETL+ Extract, Transform and Load (ETL) Page 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 ETL+ Extract, Transform and Load (ETL) Page 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.

Position in the ETL+ Interface