Supported data sources for migration

In this recipe, we will learn the different data sources supported for migration to Azure Synapse.

Following are the data warehouses that are supported as data sources by Synapse Pathway for the translation of T-SQL code to Azure Synapse:

Figure 9.13 – Supported data sources

We went through the data migration challenges in our first recipe with Teradata as an example. There are many data types, functions, stored procedures, and sequences that support the differences between the source data warehouses and Azure Synapse.

Let's now learn the differences between IBM Netezza, Oracle Exadata, Snowflake, Microsoft SQL Server, and Azure Synapse.

IBM Netezza and Azure Synapse platform differences

We will compare these platforms using several different criteria.

Data modeling

There are differences in data type mapping between Netezza and Synapse as regards a few data types and this requires changes...