Once all of the development tasks are complete and the system is running, you can perform any of these maintenance tasks.
Automatically connect to the predefined data sources and execute the ETL collaboration at specified times or when specific event occurs.
Monitor and manage activities and alerts in the application server logs
Modify the configuration of the ETL collaboration.
You can monitor ETL collaborations using the ETL Monitor, which is deployed on the application server Admin Console. The monitor allows you to specify a date range of events to monitor and also provides a purge function so you can remove outdated or obsolete events. For each event, the monitor displays the target table, start and end dates, the number of records extracted and loaded, the number of rejected records, and any exception messages. You can also view a summary, and drill down into the details of rejected records.