topic Re: Using CLOB/Varchar(MAX) in Compose (JSON) in Qlik Compose

Using CLOB/Varchar(MAX) in Compose (JSON)

guilherme-matte — Fri, 14 Mar 2025 20:49:07 GMT

Hello guys

Noob question here,

We currently have to Replicate a CLOB/VARCHAR(MAX) columns stored as JSON strings and wanted to Parse it within Qlik Compose into new columns. We are Replicating to azure sql server from another sql on prem.

Are there any workarounds to this since Compose do not work with clob/varchar(max) columns in practice? Would the solution trying to parse it inside in Qlik Cloud instead?

Any thoughts/insights would be appreciated

Kind Regards!

Re: Using CLOB/Varchar(MAX) in Compose (JSON)

Adam_Herman — Thu, 07 Dec 2023 07:40:52 GMT

Hi @guilherme-matte

I hope you're well. Regarding your inquiry, there isn't a recognized workaround from a support standpoint, and it falls outside the scope of support.

However, if you're considering modifications to the JSON source file of Compose, I would suggest engaging with our professional services team. They might offer a solution or provide an alternative approach along with valuable insights.

Best,
Adam

Re: Using CLOB/Varchar(MAX) in Compose (JSON)

Adam_Herman — Thu, 07 Dec 2023 15:15:21 GMT

Hi @guilherme-matte

With the help of our product team, I found a document that might assist you in addressing your case.

Please explore the content through the following link:

https://community.qlik.com/t5/Official-Support-Articles/Replicating-and-Transforming-Semi-structured-Data-with-Replicate/ta-p/1737881

Regards,
Adam