Discover OCI GoldenGate Data Transforms
Learn how to use OCI GoldenGate Data Replication and Data Transforms deployments together to load and transform data between two Autonomous Databases.
Before you begin
To successfully complete this quickstart you need:
- A source Autonomous Database with sample data loaded, and supplemental
logging enabled.
Tip:
You can download the OCI GoldenGate sample data, if you need sample data to work with.- Use the Autonomous Database's Database actions SQL tool to run the two scripts to create the user schema and tables.
- Use the SQL tool to enable supplemental logging.
- Unlock the GGADMIN user on the source Autonomous Database instance
- On the Autonomous Database Details page, select
Database Users from the
Database actions menu.
Tip:
Use the Autonomous Database administrator credentials provided when you created the instance to log in, if prompted. - Locate the GGADMIN user, and then select Edit from its ellipsis (three dots) menu.
- In the Edit User panel, enter a password, confirm that password, and then deselect Account is Locked.
- Click Apply Changes.
- On the Autonomous Database Details page, select
Database Users from the
Database actions menu.
Task 2: Create the Integrated Extract
An Integrated Extract captures ongoing changes to source database.
Task 3: Export data using Oracle Data Pump (ExpDP)
Use Oracle Data Pump (ExpDP) to export data from the source database to Oracle Object Store.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.