Is the Binary Log Reader Sync Method Compatible With Oracle Autonomous Database?

Question

Is the Binary Log Reader sync method compatible with Oracle Autonomous Database?

Environment

• Connector: Oracle
• Source configuration: Oracle Autonomous Database (ADB)
• Incremental sync method: Binary Log Reader

Answer

No, the Binary Log Reader sync method isn't compatible with Oracle Autonomous AI Database.

The Binary Log Reader requires access to the SYS.COL$ system table to read column definitions during setup and operation. Fivetran checks this access when you enable the Binary Log Reader, and setup fails if we can't query the SYS.COL$ table. For more information, see our documentation on enabling Binary Log Reader.

Oracle Autonomous Database is a managed service that restricts access to system-level objects, including SYS.COL$. These permissions can't be granted, even by database administrators, because Oracle manages the service architecture.

To replicate data from Oracle Autonomous Database, use the Fivetran Teleport Sync sync method instead.