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.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
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$%';
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.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
