You then use Oracle SQL*Loader to import the flat files into the target Amazon RDS for Oracle database instance. On the integration server, Oracle GoldenGate uses the flat file adapter to generate a series of sequential flat files based on the transational data capture of the trail files.Oracle GoldenGate formats the data as either delimiter-separated values or length-delimited values. The data pump copies the trail files to an integration server, which is an EC2 instance. In this pattern, you use Oracle GoldenGate to extract the trail files from your source Oracle database. You can then import those flat files to an Amazon RDS for Oracle database instance. This pattern describes how to use Oracle GoldenGate and Oracle GoldenGate flat file adapters to generate flat files from the source Oracle database, which can be on-premises or on an Amazon Elastic Compute Cloud (Amazon EC2) instance. For a list of supported databases, see Oracle GoldenGate for Heterogeneous Databases (Oracle documentation). However, this service doesn’t currently support Amazon Relational Database Service (Amazon RDS) for Oracle. ![]() Oracle GoldenGate is a real-time data capture and replication service for heterogeneous databases and IT environments. ![]() Technologies: Migration Analytics Databases ![]() ![]() Source: An Oracle database (on-premises or on an EC2 instance)
0 Comments
Leave a Reply. |