Azure Synapse Analytics Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Azure Synapse Analytics (formerly Azure SQL Data Warehouse) for replication. Azure Synapse Analytics is the Platform as a Service (PaaS) data warehouse and big data analytics of Microsoft's Azure Cloud Platform. HVR supports Azure Synapse Analytics through its regular SQL Server driver.
For information about compatibility and supported versions of Azure Synapse Analytics with HVR platforms, see Supported Platforms.
For information about the Capabilities supported by HVR on Azure Synapse, see Capabilities for Azure Synapse.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
ODBC Connection
Microsoft SQL Server Native Client must be installed on the machine from which HVR connects to Azure Synapse. For more information about downloading and installing SQL Server Native Client, refer to Microsoft documentation.
For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.