idea Re: Parallel Load feature for HANA source end point - Status changed to: Open - On Roadmap in Suggest an Idea

Parallel Load feature for HANA source end point

l9phan1 — Mon, 10 Aug 2020 12:50:01 GMT

I would like to see an option for parallel load feature for HANA source end point. This will help reduce time and potential error for loading large tables from HANA (> Billion of rows).

Re: Parallel Load feature for HANA source end point

dtylerlivingston — Tue, 11 Aug 2020 01:04:29 GMT

This would be helpful in our environment too. By 2021 we will have multiple instances of HANA and some of our tables have billions of rows as well.

Re: Parallel Load feature for HANA source end point

chekurim — Thu, 20 Aug 2020 14:07:27 GMT

Parallel load feature in Qlik for HANA source end point helps to avoid manual work to split the load into multiple logical partitions .Currently without this feature its lot of manual effort to split big tables into multiple tasks with different settings in each task to aviod overlapping of the tasks loading same table.

Also having parallel load option in qlik the load balancing will be automatically controlled. Now without this option some one running multiple parallel tasks without realizing CPU sizing etc cc . There will be resource bottle necks and causing latency issues.

Re: Parallel Load feature for HANA source end point - Status changed to: Open - On Roadmap

Ola_Mayer — Mon, 31 Aug 2020 12:35:08 GMT

Re: Parallel Load feature for HANA source end point

Anonymous — Tue, 29 Sep 2020 15:55:11 GMT

I second your idea. we are also in the same boat, but SAP HANA as a Target. It would be better to have this feature soon. when there are no technical limitations with this feature, I was wondering why it wasn't in place already.

Thanks

Re: Parallel Load feature for HANA source end point

Attunity_user — Fri, 09 Oct 2020 18:21:54 GMT

We are still exploring and in the phase of POC, the Attunity Replicate for Oracle to Oracle. There are some areas of configurations in Attunity Replicate is opaque.

Could both of you share how the replication is working from HANA to HANA or HANA to something else (target) or something else (source) to HANA?

We are also looking at this area to see how the SAP to HANA going to work. Is that going to be similar to Oracle to Oracle through Redo logs or some other procedures?

Thanks!

Re: Parallel Load feature for HANA source end point - Status changed to: Delivered

Shelley_Brennan — Fri, 12 Nov 2021 21:27:50 GMT

Support for parallel load for HANA sources is now available with the Nov 2021 release of Qlik Replicate.

Re: Parallel Load feature for HANA source end point

l9phan1 — Sun, 14 Nov 2021 02:51:44 GMT

Thank you Shelley!!!