ETL+ Source Driver for Oracle

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

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

Add Source: New Oracle connection.

Properties: Maintain Oracle connection.

Refresh: Update source Oracle database metadata.

 

 

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 https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 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 https://dataself.atlassian.net/wiki/spaces/DS/pages/1570013215 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