https://community.qlik.com/t5/Suggest-an-Idea/QLIK-Replicate-CDC-CLOB-into-Varchars-Oracle-to-Azure-Synapse/idi-p/1917025 <P>We have a use case where we need to mirror in CDC mode Oracle CLOBS into Synapse.</P> <P>Specifically,</P> <TABLE> <TBODY> <TR> <TD width="141"> <P><STRONG>Source</STRONG></P> </TD> <TD width="321"> <P><STRONG>TARGET</STRONG></P> </TD> </TR> <TR> <TD width="141"> <P>Oracle</P> </TD> <TD width="321"> <P>Azure Synapse</P> </TD> </TR> <TR> <TD width="141"> <P>CLOB</P> </TD> <TD width="321"> <P>VARCHAR(4000)</P> <P>(first 4,000 characters of the CLOB)</P> </TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>We are not able to make this work in QLIK in CDC mode.</P> <P>We need to use the Insert \ Delete mode (for updates), and CLOBs are not supported in that mode.</P> <P>We tried a few different configurations QLIK Professional Services, but can't get a configuration that works.</P> <P>It is in the documentation that this feature is not supported, hence the enhancement request.We also appreciate that CLOBs are difficult to process, and introduce all kinds of extra complexity, and performance overhead.</P> <P>If this could work with any number of characters above 2,000, it would be an acceptable compromise.</P> <P>Please let us know what further information you need, and Joe can provide the specific technical details.</P> <P>Appreciate the support,</P> Mon, 11 Apr 2022 17:07:43 GMT John_Roberts 2022-04-11T17:07:43Z https://community.qlik.com/t5/Suggest-an-Idea/QLIK-Replicate-CDC-CLOB-into-Varchars-Oracle-to-Azure-Synapse/idc-p/2100924#M14170 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/281605" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 16:00:37 GMT https://community.qlik.com/t5/Suggest-an-Idea/QLIK-Replicate-CDC-CLOB-into-Varchars-Oracle-to-Azure-Synapse/idc-p/2100924#M14170 Meghann_MacDonald 2023-08-02T16:00:37Z https://community.qlik.com/t5/Suggest-an-Idea/QLIK-Replicate-CDC-CLOB-into-Varchars-Oracle-to-Azure-Synapse/idc-p/2100925#M14171 Wed, 02 Aug 2023 16:00:38 GMT https://community.qlik.com/t5/Suggest-an-Idea/QLIK-Replicate-CDC-CLOB-into-Varchars-Oracle-to-Azure-Synapse/idc-p/2100925#M14171 Ideation 2023-08-02T16:00:38Z