How to view SQL statement executed by Replicate for a single UPDATE statement?

[MoeyE]

Hi,

I have a task which is in transactional apply mode. I'd like to view the actual SQL statement executed by Replicate if possible. I have already tried increasing TARGET_APPLY and SOURCE_CAPTURE to verbose levels, executing an UPDATE of one record on the source and then checking the logs but it didn't include the SQL statement. 

Is there a way to view the SQL statements executed by Replicate for an UPDATE? Thanks.

Regards,

Mohammed

[DesmondWOO]

Hi @MoeyE ,

Could you please specify your source and target endpoints?

Regards,
Desmond

[john_wang]

Hello Mohammed @MoeyE  ,

Good morning and thanks for the post.

Besides Desmond's comment, in general Qlik Replicate task will print the applying SQL statement with TARGET_APPLY = Verbose and under Transactional Apply mode. If you cannot get them from task log files, Please share the source and target side DBs type, we'd like to have a deeper investigation for you.

Another option is checking the recent running SQL's within the target DB. 

Hope this helps.

John.

[MoeyE]

Hi John, Hi @DesmondWOO ,

Source is Oracle and target is Event hubs. I have managed to find the SQL statements within the log files and they are encrypted. We will follow the steps to decrypt them. Thanks for the help. 

Regards,

Mohammed

[john_wang]

Hello @MoeyE ,

Thanks for the feedback. 

Event hubs is not a SQL-based endpoint, it's a Data Streaming Platform. Qlik Replicate produces messages to it by using APIs rather than SQL statement, we cannot find such an applying SQL for it.

Regards,

John.

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar