Hello everyone,
I'm facing an issue with TimeXtender when trying to retrieve tables containing datetimeoffset columns through the Generic ODBC Data Source connector. The datetimeoffset columns aren’t coming through, and in the ODBC settings, the option to override datetime types is greyed out, which I thought might solve the issue.
Has anyone encountered this or found a workaround to retrieve datetimeoffset data through ODBC in TimeXtender?
Thanks in advance!
Best answer by rory.smith
Hi,
in theory that driver should be capable of delivering datetimeoffsets from Synapse. As far as I am aware there is only an option in the ODBC driver itself to "Use regional settings when outputting currency, numbers, dates, and times”. I do not think that will solve this, but you could try.
It might be worth connecting to the ODBC source with another tool to try and see if you can get those fields there.
I suspect you may want to log a support ticket.
+7Hi,
what source type is your ODBC driver connecting to and what driver and version are you using? That usually determines what extra features are available.
Hi
The source system being accessed is Microsoft Dynamics, which runs on Dataverse. This Dataverse is replicated to a Synapse Analytics SQL endpoint. Communication with this endpoint is done via the 'ODBC Driver 18 for SQL Server,' as this allows for managed identity access to be configured.
TX version 20.10.52.64
+7Hi,
in theory that driver should be capable of delivering datetimeoffsets from Synapse. As far as I am aware there is only an option in the ODBC driver itself to "Use regional settings when outputting currency, numbers, dates, and times”. I do not think that will solve this, but you could try.
It might be worth connecting to the ODBC source with another tool to try and see if you can get those fields there.
I suspect you may want to log a support ticket.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
