topic Qlik replicate-trim spaces for postgres source point in Qlik Replicate

Qlik replicate-trim spaces for postgres source point

tulika — Tue, 30 Mar 2021 15:57:00 GMT

Hello team,

We have created two qlik jobs; source point is postgress for both, and endpoints are oracle table and kafka topic respectively.

The leading/ trailing spaces in postgres are replicated correctly to oracle table but in the kafka event, they are trimmed.

Could you please let me know the setting which can be changed.

Thanks in advance !

Re: Qlik replicate-trim spaces for postgres source point

john_wang — Tue, 30 Mar 2021 23:00:31 GMT

Hello @tulika ,

We got similar report recently. please check and let me know if you need additional assistance.

https://community.qlik.com/t5/Qlik-Replicate-Discussions/Spaces-in-same-treated-differently-according-to-endpoint/m-p/1793749#M813

Regards,

John.

Re: Qlik replicate-trim spaces for postgres source point

tulika — Wed, 31 Mar 2021 02:13:37 GMT

Absolutely... thanks a lot.

Re: Qlik replicate-trim spaces for postgres source point

john_wang — Wed, 31 Mar 2021 03:25:05 GMT

Hello @tulika ,

Glad to hear that.

Can I know what's your Replicate version? I cannot reproduce the behavior (missing trailing spaces in Kafka) by Replicate Nov 2020 (version 7.0) + PostgreSQL Server v11 + psqlodbc v13 + Kafka v2.6 (2.13-2.6.0 ).

Your versions information are helpful for other customers.

Thank you for your great work,

John.

Re: Qlik replicate-trim spaces for postgres source point

tulika — Wed, 31 Mar 2021 04:17:45 GMT

Hello, we are using QEM 6.6