Azure SQL Managed Instance Requirements

This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using Azure SQL Managed Instance for replication.

For information about compatibility and supported versions of Azure SQL Managed Instance with Local Data Processing platforms, see .

For the supported by Local Data Processing on Azure SQL Managed Instance, see .

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 .

ODBC Connection

Microsoft ODBC driver must be installed on the machine from which Local Data Processing connects to Azure SQL Managed Instance. For more information about and , refer to .

Local Data Processing uses the SQL Server Native Client ODBC driver to connect, read and write data into Azure SQL Managed Instance during , , and . The connection to the Azure SQL Managed Instance is encrypted by default (Local Data Processing 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 Local Data Processing release notes (hvr.rel) available in the HVR_HOME directory or the download page.

Related Articles