Configure a source Oracle database

This section describes how to configure your source Oracle database so that Datastream can pull data from it. Datastream can pull changes to data from on-premises or cloud-hosted Oracle databases, including Oracle relational database service (RDS).

Datastream can use the following methods to query redo log files:

  • Binary log reader (Preview): select this method if you need to query both online and archived redo log files. Binary reader can access the log files using Automatic Storage Management (ASM) or database directory objects. This method is multithreaded and supports low-latency CDC.

  • LogMiner API: select this method if you only need to work with archived redo log files. The Oracle LogMiner is single-threaded and can be subject to higher latency and lower throughput. However, this method supports most data types and Oracle database features.

    For more information about these methods, see Overview of Oracle as a source and Work with Oracle database redo log files. For information about how to configure your database type for each of these methods, see the respective configuration pages.

Supported databases

Datastream works with the following types of Oracle databases:

  • Amazon RDS for Oracle
  • Self-managed Oracle database
  • Self-hosted Oracle pluggable database

What's next