topic Re: ACDOCA table parallel replication in Qlik Replicate

ACDOCA table parallel replication

Ravi_SE — Sat, 06 Sep 2025 02:11:55 GMT

Hello,

we are using qlik replicate version 2024.11.0.374

source is SAP hana

target is snowflake on aws

ACDOCA table from hana is having 1.2 billion records, if we try to load in 1 go, it will take more than 300 hours, which is not suitable.

need parallel or passthrough filter approach to resolve this issue. can someone please provide an example specific to this table?

BR
Ravi

Re: ACDOCA table parallel replication

john_wang — Sat, 06 Sep 2025 02:39:48 GMT

Hello @Ravi_SE ,

Thanks for reaching out to Qlik Community!

The Full Load duration depends on factors such as data volume and network bandwidth. To optimize performance, Replicate offers features like Parallel Load to accelerate processing and Full Load Passthru Filter to reduce the dataset during the Full Load phase.

hope this helps.

John.

Re: ACDOCA table parallel replication

Ravi_SE — Sat, 06 Sep 2025 02:46:19 GMT

Hello John,

thanks for the quick reply, hope you are well.

actually in my post, i have already mentioned both options. but what i need is an example related to it which doesn't lead to data loss.

I have applied rows based approach in full load passthrough filter but this leads to missing data.

there is a column timestamp in this table which denotes the time of a document posted so it can't be changed in future, i have used this column also to fetch data till today's timestamp. but then its just stuck there. so something else is missing which is causing it to not fetch the new timestamp data.

in the meantime, replication is working and data is getting extracted but just the new timestamp data was not coming.

if you can share an example of parallel load specific to this table or passthrough filter example for ACDOCA, that would be really helpful.

Thanks & Regards

Ravi

Re: ACDOCA table parallel replication

sten_still — Thu, 09 Oct 2025 00:25:02 GMT

Hi Ravi,

I'm also having an issue with replication for CDC with table ACDOCA from SAP endpoint and yet to find solution to this problem. I have tried the following method from this article Qlik Replicate not able to process ACDOCA SAP HANA... - Qlik Community - 2078000

Alternatively, I am getting the accounting data (mirror to ACDOCA) from BSEG and BKPF which previously used before implementation of S4HANA.

However, some of important transaction were not in there. https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-members/all-you-need-to-know-about-universal-journal-acdoca-sap-s-4-hana-2020/ba-p/13545279 .

Hence we are not able to rely everything on with combination of BSEG and BKPF table.

Hopefully we are able to find the real solution for this.

BR,

Amir