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.](../__attachments/2001502209/image-20230803-025642.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
Source Objects panel toolbar
Add Source: New Oracle connection.
Properties: Maintain Oracle connection.
Refresh: Update source Oracle database metadata.
Where to Find in ETL+
![](../__attachments/2001502209/image-20230820-231807.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
Oracle Page
![](../__attachments/2001502209/image-20230820-231818.png?inst-v=a33ad75e-8fc6-41aa-a53e-3a49a14fd4b2)
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
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select Add Source > Oracle
For more see the Oracle Page section above.
How to Maintain Oracle Connections
Open the ETL+ Extract, Transform and Load (ETL) Page for the ETL+ entity to edit.
Select a Oracle based Source Object on the Source Objects panel.
Select Properties > Oracle
For more see the Oracle Page section above.
Related ETL+ Pages
Position in the ETL+ Interface
Extract, Transform and Load (ETL) page
Add Source, Properties or Refresh buttons