How to transfer data from Azure SQL Database to on prem Teradata database using Azure Data Factory?

64552978 0 Reputation points
2024-02-08T16:27:58.8733333+00:00

We trying to transfer data from Azure SQL database to on prem Teradata system, but in Sink option Teradata is not available, how can we achieve this?

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2024-02-08T18:05:41.3166667+00:00

    Try to use the ODBC Connector instead as explained on this forum thread. See on that thread how they handle issues with dates.

    Basically, you will use an ADF pipeline to copy data from Azure SQL to an Azure Blob Storage and then using another pipeline you will copy from the Storage Account to the Teradata database

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.