How to migrate the data from Teradata to Azure Synapse in batch mode with low network latency

Question

Vasudev Sriramula (INFOSYS LIMITED) 0 Microsoft External Staff

1 answer

Answer 1

Thanks for reaching out to Microsoft Q&A. We're glad to assist you with your query on migrating data from Teradata to Azure Synapse.

You can use tools like Azure Data Factory (ADF) or Azure Synapse Pipelines to manage and automate the process of moving data. These tools help you pull data from Teradata, clean it up, and load it into Azure without putting too much strain on the Teradata system.
For faster data transfers—especially when using a temporary storage space like Azure Blob Storage—you can also use PolyBase or the COPY INTO command. These methods are great for loading large amounts of data efficiently.
Performance tips -
- Break your large files into smaller pieces so they can be processed at the same time. This helps speed things up and makes the most of your system’s capacity.
- Make sure the temporary storage area (called the staging area) is located close to your Azure Synapse system. This helps move data faster and saves time during transfers.
- If you're concern about slow data transfers due to internet delays, consider using Azure ExpressRoute. It creates a private, direct connection to Azure, which is much faster and more reliable than regular public internet—especially helpful when moving large amounts of data.

For more details, kindly refer the below quick guide -