Please follow these steps to add an ETL:
- Log into OWB Design Center
- Import any new required Tables into OWB
- Create a New Mapping under the appropriate Reporting\Databases\Oracle\Schema Name folder
- Add the Source and Target Tables
- Add the appropriate Control Table and join it to the Source Table to extract the updated records
- Add any other required Joins or Transformations
- Map the Source Columns over to the Target Columns
- Set the Load Properties on the Target Table and its Columns
- Add the Pre and Post Mapping Transformations to update the Control Table
- Validate and Deploy the ETL
- Add a record into the ETLCONTROL Table for the ETL. This can be done manually, as a once off, or by adding a new entry into the appropriate ETLCONTROL csv file and building the database
- Run the ETL to test via the OWB Control Center
- Add an entry into the appropriate run.bat file, which can be found in..\Reporting\components\core\run\oracle. Any new ETL's should be added to a run.bat file in the custom folder, e.g...\Reporting\components\core\custom\run\oracle. This will ensure the new ETL gets run when the ETL's are executed through the build environment
- The ETL and updated Table metadata can be exported from OWB as .mdo files and stored on a file system