MS Azure SQL Managed Instance requirements
- A VM or physical machine with 2 to 4 cores, 4GB RAM, an OS >Windows 2008R2 (not necessarily the server type), and 32 or 64 bits.
- An ODBC SQL Server version higher or equal to 17.
- The installation must be performed with an administrator profile on this machine.
- Concerning your Azure account, make sure:
- you know its user name and password. You will need them when installing the source,
- the minimal TLS version in Networking tab is set to 1.0,
- you have created a storage account. For more information, see step 3 in MS Azure MI for SQL documentation.
- Configure the Azure MI database alias that will be used for the setup and
connection with Microsoft SQL Server Management Studio:
- Launch C:\windows\syswow64\cliconfg.exe on a 64-bit system (or 32-bit version on a 32-bit system).
- Select TCP/IP and enter the alias name in the Server
name field:
.
The URL must match the value available on .
- As Talend Change Data Capture Azure source relies on an intermediate layer (Microsoft SQL Server CDC), the _CT tables that are created (and used by Microsoft SQL Server CDC) could generate storage costs on Microsoft Azure. Please refer to MS CDC documentation for more information.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!