idea From now on, please track this idea from the Ideation por... in Suggest an Idea

Enable the ability to transform CLOB / BLOB fields in Replicate

Prabodh — Wed, 06 Oct 2021 19:29:19 GMT

We encountered a limitation with Oracle source endpoint where we cannot execute transformations on CLOB / BLOB fields.

We have a requirement where we have to encrypt / tokenize certain CLOB columns.

I would like to request a feature enhancement to allow transforming CLOB / BLOB columns in Replicate.

Re: Enable the ability to transform CLOB / BLOB fields in Replicate - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Tue, 19 Oct 2021 13:33:57 GMT

Thank you for the suggestion. We will collect feedback from others here as well.

Re: Enable the ability to transform CLOB / BLOB fields in Replicate

John_Roberts — Mon, 11 Apr 2022 17:05:16 GMT

We have a similar issue,
we would like to be able use a transformation to take a CLOB, and transform it into a VARCHAR(x) (nominally 4,000) and replicate it into Azure Synapse.

Re: Enable the ability to transform CLOB / BLOB fields in Replicate

john_wang — Wed, 07 Sep 2022 01:21:50 GMT

Hello @Prabodh , @John_Roberts copy @Shelley_Brennan ,

I think I found a workaround for the LOB transformation, see the link below. The source is PostgreSQL however I think it works for other source endpoints as well, eg Oracle source etc.

https://community.qlik.com/t5/Qlik-Replicate/String-truncation-during-transformation/td-p/1977377

Hope this helps.

Regards,

John.

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

Meghann_MacDonald — Wed, 02 Aug 2023 15:24:51 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: Enable the ability to transform CLOB / BLOB fields in Replicate - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:24:53 GMT