Capture From Oracle Pluggable Database

Fivetran HVR supports capturing from Oracle's pluggable database (PDB). A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a separate database. One or more PDBs together function as a root multitenant container database (CDB). CDB is where the PDB is managed. For more information about PDB and CDB, refer to Oracle's documentation.

HVR supports the Direct Redo Access, Archive Only, BFile, LogMiner, and LogMiner Archive Only capture methods for capturing from PDB. However, the following connection configuration must be noted:

• For capturing from a PDB (without TDE) using Direct Redo Access method, a single connection to the PDB is sufficient. The connection string for the PDB should point to the database service of the PDB.
• For capturing from a PDB (with TDE) using Direct Redo Access, Archive Only, or BFile method, two underlying connections must be set up for the capture location: one to a PDB and other one to a CDB (to which the PDB is plugged). For the PDB, the connection string should point to the database service of the PDB. The connection method for PDB is always TNS.
  • In HVR UI, while creating an Oracle location with Pluggable Database, in Step 3. Configure Location Connection the connection parameters for the PDB must be supplied. And, in Step 4. Configure Capture/Integrate the connection parameters for CDB must be supplied.
• For capturing from a PDB using LogMiner or LogMiner Archive Only method, two underlying connections must be set up for the capture location: one to a PDB and other one to a CDB (to which the PDB is plugged). For the PDB, the connection string should point to the database service of the PDB. The connection method for PDB is always TNS.
  • In HVR UI, while creating an Oracle location with Pluggable Database, in Step 3. Configure Location Connection, the connection parameters for the PDB must be supplied. And, in Step 4. Configure Capture/Integrate the connection parameters for CDB must be supplied.

Grants for Capturing from Pluggable Database

• The container database User must be a CDB common user with the default prefix c## (for example, c##user).

• The privileges required for the CDB common user (User) and the PDB user are the same as the log-based capture grants.

  For granting privileges to the PDB user, the following command should be first executed to switch to that container (PDB user):

  alter session set container=pdbuser;