Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Batch mode with Transactional Integrity

UsmanRah
Contributor II

Batch mode with Transactional Integrity

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

 

 

2 Comments
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.

Ideation
Explorer II
 
Status changed to: Closed - Archived