Suggest an Idea

[UsmanRah]

For Qlik Replicate with SAP IQ as a target,  currently we have transactional mode and batch mode. Transactional mode will not work against SAP IQ as it does not handle OLTP workloads. Batch mode is better for SAP IQ but does not give transactional integrity

This does the following

Begin tran

Delete table a

Commit tran

Begin tran

Insert table a

Commit tran

Begin tran

Update table a

Commit tran

Begin tran

Delete table b

Commit tran

Begin tran

Insert table b

Commit tran

Begin tran

Update table b

Commit tran

Begin tran

Etc

Commit tran

We’d like to raise an ideation to create a new mode “Transactional Integrity Batch Mode”

This will do the following

Begin tran

Delete table a

Insert table a

Update table a

Delete table b

Insert table b

Update table b

Etc

Commit tran

[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.