Connecting to Oracle
If you haven’t installed ETL+ yet: ETL+ Deployment Instructions.
Login to ETL+ (help here).
Adding a new Oracle database: On ETL page’s left panel, click
Maintaining an Oracle source: On ETL page’s left panel, right-click the source →
Aliasbox will be automatically populated, but you can customize it.
Host name:: Enter the URL or IP of the database.
Port: Enter the database port number.
Credentials: Enter Login and Password.
Service name: Enter the service name.
You’ll get back to the ETL page and see tables under the selected Oracle source on the left panel.
Mapping and Loading Tables
To view tables available on the left panel, right-click the Oracle source →
To map an Oracle table to the data warehouse,
double-click its nameon the left panel, or right-click on it →
You’ll now see the table added/mapped to the center panel.
To preview its data, right-click the table on the center panel →
To load its data to the data warehouse, right-click the table on the center panel →
Logicon (top right) to view data load results. Log page help here.
Schedule the Data Load
On the ETL main page, click
Job(top right icon on the center panel).
Select a Job or create a new one to load your Oracle data on a schedule (help here) → on the right panel, be sure the Oracle tables to load have their boxes checked and in the desired load order.
To load them now, click the
Run Job(play icon) on the left panel for the desired Job.
To schedule the data load:
WTS Settings-> enter the WTS parameters →
This step might require you to run ETL+ app as “Run as administrator” in Windows.
After ETL+ has loaded your Oracle files, this is to check if the data extraction process finished successfully and row count per extracted table matches with your Oracle tables.