topic does qlikreplicate support oracle global temp tables? in Qlik Replicate

does qlikreplicate support oracle global temp tables?

suhail01101984 — Mon, 16 Sep 2024 21:20:10 GMT

does qlikreplicate support oracle global temp tables?

Re: does qlikreplicate support oracle global temp tables?

john_wang — Tue, 17 Sep 2024 01:27:17 GMT

Hello @suhail01101984 ,

Welcome to Qlik Community forum and thanks for reaching out here!

It seems you're referring to Global Temporary Tables (GTTs) in Oracle as the source endpoint.

The short answer is no - Qlik Replicate cannot access data in Oracle GTTs. This is because the data in these tables is session-private, meaning data inserted by one session is only accessible within that session. As a result, Qlik Replicate is unable to access or replicate the data during either Full Load or Change Data Capture (CDC) processes.

Additionally, temporary tables are generally intended for short-term use, such as buffering result sets that are constructed through multiple DML operations. Since their purpose is temporary and session-specific, replicating them to another database offers no practical value.

Hope this helps.

John.

Re: does qlikreplicate support oracle global temp tables?

suhailmemon — Tue, 17 Sep 2024 02:41:30 GMT

Hello @john_wang , thanks for replying. we have a use case where we would like to replicate to oracle target and the target table needs to be a GTT. is that possible?

when we tried to replicate to a target GTT, the job fails coz it can't find the table. it's probably because it's running this sql:

select object_id from ALL_OBJECTS where owner = :1 and object_name = :2 and (object_type = 'TABLE' or object_type = 'VIEW') and temporary = 'N' and object_name not like 'BIN$%' and object_name not like 'DR$%';

the "and temporary='N' " in the sql is causing qlikreplicate to not recognize the GTT that we created.

is there any internal parameter that will allow qlik replicate to issue the sql without this "and temporary='N' " ?

we would like to override the sql it runs and it should like this instead:

select object_id from ALL_OBJECTS where owner = :1 and object_name = :2 and (object_type = 'TABLE' or object_type = 'VIEW') and object_name not like 'BIN$%' and object_name not like 'DR$%';

Re: does qlikreplicate support oracle global temp tables?

john_wang — Tue, 17 Sep 2024 02:44:09 GMT

Hello @suhailmemon ,

Thanks for the update.

I'm afraid NO. Because even if Qlik Replicate creates the GTT and replicates the source data to these target GTT however the data is invisible for your other Apps.

Regards,

John.

Re: does qlikreplicate support oracle global temp tables?

DesmondWOO — Tue, 17 Sep 2024 02:45:44 GMT

Hi @suhailmemon ,

Qlik Replicate does not a create global temporary table on the target side.

Regards,
Desmond