This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool.
The three different approaches that will be discussed are:
- Live Reporting database - The basic assumption with this approach is that there is already a Live Reporting database being maintained that can be modified to support the additional requirements for feeding data into the ETL tool being used.
Historical database - The basic assumption with this approach is that there is a need to have a chronology of the database changes. This approach turns all database change operations into inserts and creates a staging database specifically to feed data into the ETL tool being used.
- Batch mode flat files - The basic assumption here is that the desired delivery medium is flat ASCII style files that are created at user defined intervals to feed data into the ETL tool being used.
The primary focus of this document is the recommended Best Practices configuration of Oracle GoldenGate sending data to the ETL tool of choice. There is no reference to any specific ETL tool or any special requirements to support specific tools. This is meant to be a starting point and it is expected that changes will need to be made to support specific user requirements and tools.
The complete document can be found on the Oracle Support site under the document ID:1371706.1