Teradata test connection working with Advanced JSON formatted ODBC service, not after applying. Why?

Emiel van Dongen 0

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! Screenshot 2023-04-13 at 14.02.14

Screenshot 2023-04-13 at 14.03.06

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2023-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,442 Reputation points Microsoft Employee

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

Share via

Teradata test connection working with Advanced JSON formatted ODBC service, not after applying. Why?