ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with Azure SQL database allows administrators to synergistically manage AD objects from their Azure SQL instance itself.

Upon integration, administrators can configure automations to carry out desired tasks. These automations can be monitored and controlled by implementing multi-level business workflows, which ensure that they are reviewed and approved before execution. The following actions can be automated:

Steps to integrate ADManager Plus with Azure SQL database:

1. Log in to ADManager Plus and navigate to the Automation tab.

2. In the left pane, under Configuration, click Applications Integrations.

3. Under Databases, click Microsoft SQL Server.

4. In the Server Details section, configure the following:

• Server Name: Enter the name of your Azure SQL server.

• Instance Name: Enter your Azure SQL instance name and port number.

• Authentication: Select Azure Active Directory - Password as the authentication type and enter the username and password of the Azure AD user account.

5. Click Test Connection and Save to establish the connection and save the settings.

Note:

• Click the Add Server option to configure multiple Azure SQL servers.

• The Enable Integration button is turned on by default. Toggle it off to disable this integration. 

Upon successful integration, transfer data seamlessly to and from your Azure SQL instance and perform the tasks mentioned in the above sections without any hassle by selecting MS SQL as the data source while configuring an automation. To know more, click here.