Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,658 questions
Teradata test connection working with Advanced JSON formatted ODBC service, not after applying. Why?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 62%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEV%3C/text%3E%3C/svg%3E)
Emiel van Dongen
0
Reputation points
Hi!
I'm trying to set up an ODBC linked service in Azure Data Factory to create a connection to Teradata in order to write data from Azure to Teradata.
When I fill in a JSON object with a connection string, testing the connection works. Image 1. After I applied it and test the connection again, it fails and returns the error in image 2.
What can I do?
Thanks in advance!
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2023-04-14T15:20:12.8933333+00:00 Hi @Emiel van Dongen ,
Welcome to Microsoft Q&A forum and thanks for reaching out here.
Wanted to let you know that Teradata as sink is not supported in ADF and hence ODBC connector is the workaround. But ODBC connection to Teradata hasn't been tested fully, not all features are supported and hence may result in some issues. As per the error message it seems like a driver or configuration issue.
But to identify the exact root cause, it requires a deeper investigation. Hence would recommend filing a support ticket. In case if you don't have a support plan, please let me know.Thanks
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2023-04-19T21:43:51.61+00:00 @Emiel van Dongen Just checking to see if you have got a chance to file a support ticket for deeper investigation of this issue. If so, could you please share the SR# with for tracking it internally. Thanks
Sign in to comment
Sign in to answer