idea Re: Qlik Replicate Support for datetimeoffset for SQL Server Target in Suggest an Idea

Qlik Replicate Support for datetimeoffset for SQL Server Target

zwatkinscovermymeds — Fri, 11 Dec 2020 13:42:56 GMT

A majority of my task in consist of a PostgreSQL source replicating to a SQL Server target. the vast majority of my PostgreSQL source tables consist of timestamp with TZ datatype. this datatype stores the timestamp value with a timezone offset. When that is replicated over to my SQL Server target, adds (or subtracts) the timezone offset converting the datetime to UTC. Why does not support the datetimeoffset datatype in SQL Server? Currently, have ~80 task where I am having this issue. When we made the move to this presented a lot of manual work to Sql Server stored procedures to account for the new time affecting or client reporting.

My understanding is that PostgreSQL and SQL Server are mature endpoints for Qlik/Attunity, so I don't understand why I this datatype is not supported. Am I the only one with this issue? Has this been solved already?

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target

seanhawkes — Fri, 11 Dec 2020 18:15:30 GMT

yea this seems like a no brainer. please add

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target - Status changed to: Open - Collecting Feedback

Shelley_Brennan — Mon, 14 Dec 2020 14:28:58 GMT

Thank you for the suggestion. We are collecting feedback and will update when we have it on the roadmap.

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target

LaurentSamyn — Tue, 15 Dec 2020 16:14:08 GMT

Same thing required with Oracle and others would be great...

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target

karrasan — Tue, 15 Dec 2020 16:47:52 GMT

I strongly agree please add it

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target

Huey — Mon, 26 Apr 2021 22:25:41 GMT

Bump

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target

zwatkinscovermymeds — Tue, 27 Apr 2021 14:38:05 GMT

This is still an issues. I would love to see this addressed in the next update 🙂

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 16:05:00 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Qlik Replicate Support for datetimeoffset for SQL Server Target - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:05:01 GMT