Datastream lets you stream change data capture (CDC) updates from an Oracle database to a supported destination, such as BigQuery or Cloud Storage. Depending on whether your database is on-premises or cloud-hosted, you configure redo log access and user privileges for your deployment type and CDC method.
Methods for querying redo log files
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 log files using Automatic Storage Management 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
- Learn how to configure an Amazon RDS for Oracle database to work with Datastream.
- Learn how to configure a self-managed Oracle database to work with Datastream.
- Learn how to configure a self-hosted Oracle pluggable database to work with Datastream.