Qlik PostgreSQL to UDB for TEXT to CLOB Transformation issue

[R_K]

Hello All,

          I am trying to migrate data from PostgreSQL as source and UDB DB2 LUW as target end point using (ODBC as type) .

           However, during the table loads one of the table on Source PostgreSQL is defined as text and target UDB defined as CLOB, is there any transformation available in Qlik to transform data from text to CLOB.

[Kent_Feng]

Hi @R_K 

Welcome to Qlik Community.

You can edit the syntax to specify TEXT to CLOB mapping. However it is not an easy process, basically there are 5 major steps:

1) find out what the current syntax name is

2) export the syntax to json file

3) edit the json file (it is very easy to get it wrong on this part)

4) import edited json file back to Replicate

5) edit syntax parameter to point to the new syntax 

As I can see you are a new to the community, I would recommend you to open a support case so our TSE can guide you step by step.

Thanks

Kent

[SushilKumar]

Hello Team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer. if you require further assistance, please raise a Support case. 

Regards,

Sushil Kumar

[john_wang]

Hello @R_K ,

There are several methods to achieve the TEXT to CLOB data type mapping in Qlik Replicate. @Kent_Feng mentioned one of the approach. The methods are:

1- in table level.

    You may change from default NCLOB to CLOB in the transformation, then in the DB2 LUW the column data type will be created from LONG VARGRAPHIC to CLOB(2147483647) NOT LOGGED NOT COMPACT. A sample:

    Where datatype of column "notes" in PostgreSQL is TEXT.

    This method weakness is it take action for this column ONLY. If you have many such columns in many tables then you need to change the type one by one.

2- In Global Rule Transformation level

    You may define once and take action for all tables all such columns within this task. The definition is similar with table level, change the column type from NCLOB to CLOB, for example:

3- Change the DB2 syntax as Kent mentioned. It's similar with 2, define once and take effective for all tables/all such columns.

Hope this helps.

John.