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.
Supported Platforms
- Learn about the Azure Synapse Analytics versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what HVR offers for Azure Synapse Analytics on our Capabilities for Azure Synapse Analytics page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
- Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Azure Synapse Analytics data types and their mapping, see Data Type Mapping for Azure Synapse Analytics.
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.