Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
vkura
Contributor
Contributor

Qlik replicate converting Oracle Timestamp to String in Snowflake

Hi Team,

We are using Qlik Enterprise Manager to replicate data from Oracle to Snowflake and it automatically converting datatype from Timestamp LTZ to String in Snowflake. Please refer to the below attachments to resolve the issue. 

 

Thank you,

Vinil

 

 

Labels (1)
1 Solution

Accepted Solutions
Heinvandenheuvel
Specialist III
Specialist III


@vkura wrote:

We are using Qlik Enterprise Manager to replicate data from Oracle to Snowflake

No you are not. 🙂

You are using the Enterprise Manager to create and manage a Replicate task. 

Any issues with the inner working of that task is best discussed in the "replicate" sub-forum parallel to this forum also under "data Integration"

and it automatically converting datatype from Timestamp LTZ to String in Snowflake. 


So it will create a string like "2022-03-04 15:19:17.885607" . Is that what is needed? If not,  tell it how you would like to do the transform, what the timestamp as string should look like. This is done through an transformation under  the "Fx" option with the datetime function strftime. ( https://www.sqlite.org/lang_datefunc.html )

>>  Please refer to the below attachments to resolve the issue. 

What issue?

UPDATE: I initially did not recognize that the issue was that Replicate forces a string where timestamp with timezone was the Oracle source datatype. This datatype is also available as datatype on the snowflake target and was desired, but apparently Replicate does not support that today. This action/restriction is documented in the Replicate User Guide under Oracle as Source.

hope this helps.

Hein

 

 

View solution in original post

1 Reply
Heinvandenheuvel
Specialist III
Specialist III


@vkura wrote:

We are using Qlik Enterprise Manager to replicate data from Oracle to Snowflake

No you are not. 🙂

You are using the Enterprise Manager to create and manage a Replicate task. 

Any issues with the inner working of that task is best discussed in the "replicate" sub-forum parallel to this forum also under "data Integration"

and it automatically converting datatype from Timestamp LTZ to String in Snowflake. 


So it will create a string like "2022-03-04 15:19:17.885607" . Is that what is needed? If not,  tell it how you would like to do the transform, what the timestamp as string should look like. This is done through an transformation under  the "Fx" option with the datetime function strftime. ( https://www.sqlite.org/lang_datefunc.html )

>>  Please refer to the below attachments to resolve the issue. 

What issue?

UPDATE: I initially did not recognize that the issue was that Replicate forces a string where timestamp with timezone was the Oracle source datatype. This datatype is also available as datatype on the snowflake target and was desired, but apparently Replicate does not support that today. This action/restriction is documented in the Replicate User Guide under Oracle as Source.

hope this helps.

Hein