Configure a self-managed Oracle database for CDC

This page describes how to configure change data capture (CDC) to stream data from a self-managed Oracle database to a supported destination, such as BigQuery or Cloud Storage.

You can configure your self-managed Oracle database to work with the following CDC methods:

These methods specify how Datastream accesses your log files. For more information about the binary log reader and the LogMiner API, see Work with Oracle database redo log files.

For detailed instructions about how to configure your source Oracle database for each of these methods, see the sections that follow.

Configure your self managed Oracle database for binary log reader

To configure your self-managed Oracle database for use with the binary log reader CDC method, perform the following steps:

  1. Create a database user account to be used by Datastream to connect to your database:

    CREATE USER USER_NAME IDENTIFIED BY