Suggest an Idea

[sidneyb]

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

[bobvecchione]

Currently not under consideration.

No current plans to enhance LogMiner.

[sidneyb]

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

[mpakala]

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.

[ssrlv]

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?           

[Meghann_MacDonald]

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.