Azure SQL Database Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Azure SQL Database for replication. Azure SQL Database is the Platform as a Service (PaaS) database of Microsoft's Azure Cloud Platform.
For information about compatibility and supported versions of Azure SQL Database with HVR platforms, see Supported Platforms.
For the capabilities supported by HVR on Azure SQL Database, see Capabilities for Azure SQL Database.
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.
Fivetran provides additional solutions for replicating data from Azure SQL Database. For more information, see section SQL Server in Databases.
ODBC Connectionlink
Microsoft SQL Server Native Client ODBC driver must be installed on the machine from which HVR connects to Azure SQL Database. 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 Database during Capture, Continuous Integrate, and Row-wise Refresh. The connection to the Azure SQL Database 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.
Firewall Configurationlink
The Azure SQL Database server has a firewall setting that prevents incoming connections by default. However, this can be configured/changed under Database server/Show firewall settings. To allow access to the Azure services, when connecting from an Azure VM (through an agent), set option Allow access to Azure services to ON.
When connecting directly from an on-premises hub, add the HVR Hub Server's IP address to the allowed range. For more information about adding your server to the allowed IP address list, refer to the Azure SQL Database documentation.