idea From now on, please track this idea from the Ideation por... in Suggest an Idea

Support for Oracle multitenant architecture (CDB and PDB) as source endpoint

sidneyb — Tue, 03 Nov 2020 14:43:47 GMT

Large enterprises uses the Oracle multitenant option to simplify support and maintenance of multiple databases. As part of this model, a single container database (CDB) can host multiple separate pluggable databases (PDB).

Currently, Qlik Replicate is not able to connect to pluggable databases (PDB) which prevents us from using it in multiple use cases. It would be great if the Log Miner option could work with PDB without requiring elevated permissions.

More info about Oracle Multitenant Architect:

https://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89245

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint

bobvecchione — Mon, 16 Nov 2020 14:26:45 GMT

Currently not under consideration.

No current plans to enhance LogMiner.

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint

sidneyb — Mon, 16 Nov 2020 16:28:25 GMT

Is there any other option to connect to Oracle PDB without elevated permissions?

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint

mpakala — Tue, 17 Nov 2020 15:58:37 GMT

Oracle stated that, starting in Oracle Database 20c, a multitenant container database is the only supported architecture. It will no longer support non-container databases (non-CDBS).
With that it becomes more critical to start planning on enhancing the LogMiner to support CDB/PDB. Without LogMiner support, we are forced to give elevated privileges to the replicate user which is of security concerns.

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 22 Feb 2021 14:23:35 GMT

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint

ssrlv — Thu, 13 Apr 2023 18:14:19 GMT

We are in the midst of installing Oracle Exadata in a multi-tenant environment. We currently use QLIK and have 8 or 9 Oracle databases (non CDBS) as QLIK source endpoints. We use the QLIK replicate log reader in all the Oracle source endpoints. Will QLIK support Oracle source endpoints in a exdata ASM muti-tenant environment and how would that be configured? Would we connect to the PDB or the CDB in the Oracle source endpoint?

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:34:23 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Support for Oracle multitenant architecture (CDB and PDB) as source endpoint - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:34:25 GMT