idea Re: Support jsonb datatype for postgres ODBC data source in Suggest an Idea

Support jsonb datatype for postgres ODBC data source

sujankudumula — Wed, 21 Dec 2022 19:18:32 GMT

We are using ODBC with CDC source endpoint to connect to a postgres database that is a physical replica.

One of the data types of this source is jsonb datatype which has variant data. The odbc driver is interpreting the jsonb as varchar(255) and truncating the data. No matter we increase the LOB size or data type length in qlik or target endpoint, the data is getting truncated with malformed json written to target snowflake endpoint.

Gerald Umoru who is helping us with the qlik case 00062911 suggested that jsonb datatype is not supported for ODBC driver endpoint and that a new enhancement may be requested.

Re: Support jsonb datatype for postgres ODBC data source

john_wang — Fri, 23 Dec 2022 03:57:57 GMT

Hello @sujankudumula ,

I got solution for this issue:

Qlik Replicate: Support JSONB datatype for PostgreSQL ODBC data source

personally I do not think FR is needed.

Hope this helps.

Regards,

John.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:34:56 GMT

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.

Re: Support jsonb datatype for postgres ODBC data source - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:34:58 GMT