Azure SQL Managed Instance Requirements
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Azure SQL Managed Instance for replication.
Supported Platforms
- Learn about the Azure SQL Managed Instance 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 SQL Managed Instance on our Capabilities for Azure SQL Managed Instance 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.
Fivetran provides additional solutions for replicating data from Azure SQL Managed Instance. For more information, see section SQL Server in Databases.
ODBC Connection
Microsoft SQL Server Native Client ODBC driver must be installed on the machine from which HVR connects to Azure SQL Managed Instance. For more information about downloading and installing SQL Server Native Client, refer to Microsoft documentation.
HVR uses the SQL Server Native Client ODBC driver to connect, read and write data into Azure SQL Managed Instance during Capture, Continuous Integrate, and Row-wise Refresh. The connection to the Azure SQL Managed Instance is encrypted by default (HVR will always add the “ENCRYPT=YES” to connection string for any Azure SQL connection).
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.