topic Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ? in Qlik Replicate

Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

khchoy — Tue, 20 Sep 2022 06:58:57 GMT

Hi All,

One of current customer asked about this.

Oracle supported varchar2(32767) after 12c version. So customer ask about Qlik replicate supporting varchar2(32767).

it means oracle source endpoint use varchar2(32767) columns, Does Qlik Replicate did not change data type to CLOB on oracle target or other database ?

For excample oracle source and target table has varchar2(32767) column , Qlik Replicate can replicate without any error ?

Regards,

Kwangho

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

Arun_Arasu — Tue, 20 Sep 2022 07:14:49 GMT

Hi @khchoy ,

Please refer the below user guide for the supported data type

Oracle as a source

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Oracle/ora_source_data_types.htm#ar_oracleds_385117211_1677127

Oracle as a target

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Oracle/ora_target_data_types.htm#ar_oracleds_385117211_1680373

Thanks & Regards,

Arun

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

Bill_Steinagle — Tue, 20 Sep 2022 17:23:07 GMT

Kwangho,

Thank you for the Post to the Qlik Replicate Forums. As noted by Arun the VARCHAR2(32767) is Supported as this is listed in the Supported Datatypes for Oracle. I would also check the TRANSFORM on the Table when setting up the Mapping of the Source and Target Table to ensure its mapping to a VARCHAR2 as well.

https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/Oracle/Oracle-connector.htm

Thanks!

Bill

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

shashi_holla — Tue, 20 Sep 2022 22:42:42 GMT

Hi @khchoy

VARCHAR2(32767) will be converted to CLOB by Replicate. But if we want to have target datatype to continue having VARCHAR2 then we need to add transformation on the table to change the default CLOB to STRING(32767). Please try this in Test environment to verify the behavior.

Thanks,

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

khchoy — Wed, 21 Sep 2022 04:39:22 GMT

Thank shashi.

Does any other why for this? such as use new syntaxes file.

Also can i use transformation clob to string(32767) for all supported target endpoints?

regards,

kwangho

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

Steve_Nguyen — Fri, 23 Sep 2022 21:22:42 GMT

Does any other why for this? such as use new syntaxes file.

ans: not sure what you mean

----

Also can i use transformation clob to string(32767) for all supported target endpoints?

ans: test you can use global transformation .

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

khchoy — Tue, 27 Sep 2022 04:27:14 GMT

I tested ORACLE (AL32UTF8) to POSTGRESQL (UTF8) whr varchar2(6000) byte.

When I use character varying (6000) on target , FL testing is OK , but change apply (cdc) testing is fail. (Null data)

target table character varying (6000) : transformation clob -> string(6000) and nochange ( clob)

transformation clob -> string(6000) - ONLY string(6000) column date is null

not transformation clob - all recorrd missing with out any log information (record loss)

does any idea ?

Re: Does Qlik Replicate support ORACLE VARCHAR2(32767) ?

john_wang — Tue, 27 Sep 2022 04:49:31 GMT

Hello @khchoy ,

I'm afraid I did not get your meaning exactly. could you please describe the behavior in detail? a screen copy is much better, and let me know what's the expected result.

BTW, what's the output of the query "show parameter max_string_size;" in Oracle DB?

Regards,

John.