How to integrate ADManager Plus with AWS SQL database

How to integrate ADManager Plus with AWS SQL database

ADManager Plus can be integrated with a list of databases to facilitate efficient AD management. This specific integration with AWS SQL database allows administrators to synchronize data from AWS SQL to AD to efficiently provision user accounts and manage their entire life cycle and access.

Actions supported

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:

  • Create user accounts

  • Add users to groups

  • Modify user attributes

  • Remove users from groups

  • Modify user accounts by template

  • Create mailbox

  • Reset passwords

  • Disable or delete mailbox

  • Unlock user accounts

  • Move home folder

  • Enable user accounts

  • Delete home folder

  • Disable user accounts

  • Revoke Microsoft 365 licenses

  • Delete user accounts

  • Manage user photos

  • Run custom scripts

  • Disable Lync accounts

  • Move users across groups

  • Configure auto reply settings

 

Steps to integrate ADManager Plus with AWS SQL database:

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

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

  1. Under Databases, click Microsoft SQL Server.

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

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

    • Instance Name: For AWS SQL server, the instance name and port number fields should be left empty.

    • Authentication: Select SQL Authentication as the authentication type and enter the username and password of the AWS AD user account.

 

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

 

Note:

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

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

  • While configuring automation, select MS SQL as the data source and select the attribute mapping configuration to import the users from MS SQL.

 We were unable to process some of the images.

Upon successful integration, transfer data seamlessly to and from your AWS SQL instance and perform the tasks mentioned in the above sections without any hassle.

 


                  New to ADManager Plus?

                    New to ADSelfService Plus?