Can you put multiple values in the Secret Store Encryption entry fields on an Oracle 19c source endpoint in Replicate?

[Greg_Pagan]

I am using Qlik Replicate 11-2022 to read data from an on-Prem Oracle 19c database that has encrypted data in it.  

Our Oracle DBA's rotate the encryption wallet entries on a regular basis and it would be nice if we could store both the current and new values in the source endpoint connection under the Names and Values boxes.  Is that possible, and if so, what would be use for a delimiter between the two values..  

We use the log stream feature to read our Oracle redo logs.  If we update the endpoint with both the old and new values, and save the endpoint, will the log stream task need to be stopped and resumed to pick up the change in names/values or does it dynamically read the data from the endpoint for each file that it needs to decrypt?  

Thanks

Greg Pagan

[DesmondWOO · Accepted solution]

Hi @Greg_Pagan ,

Qlik Replicate does not support storing both the current and new values of the wallet in the endpoint. If you have Qlik Enterprise Manager installed, please check if the PatchEnpdoint API is helpful in this case. You can create a script to update the wallet information regularly.

When updating wallet information for both LogStream tasks, I recommend stopping the tasks first. If you don't stop the tasks, the new wallet information will take effect only after you restart them.

Regards,
Desmond