Establishing a Connection
Connecting with the Azure Resource Management Connection Manager
Adding a new Azure Resource Management connection to the SSIS package is straightforward. Right-click within the Connection Manager window and select New Connection from the menu. Then, choose the Azure Resource Management Connection Manager from the Add SSIS Connection Manager window.
Alternatively, you can create a new connection directly using the Azure Resource Management Source or the Azure Resource Management Destination. You can set the connection properties in the Azure Resource Management Connection Manager window.
Authenticating to Azure Resource Management
Authenticating using Azure AD
Azure AD is a connection type that goes through OAuth. Set your AuthScheme to AzureAD and see Using OAuth Authentication for an authentication guide.
Authenticating using Azure Service Principal
Azure Service Principal is a connection type that goes through OAuth. Set your AuthScheme to AzureServicePrincipal and see Using Azure Service Principal Authentication for an authentication guide.
Authenticating using MSI Authentication
If you are running Azure Resource Management on an Azure VM, you can leverage Managed Service Identity (MSI) credentials to connect:
- AuthScheme: Set this to AzureMSI.
The MSI credentials will then be automatically obtained for authentication.