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 ADSelfService Plus?

                    • Related Articles

                    • How to integrate ADManager Plus with Azure SQL database

                      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. ...
                    • How to migrate ADManager Plus database to MS SQL in AWS?

                      Steps to migrate ADManager Plus database to MS SQL server in Amazon Web Services Login to your Amazon web services account. Click the Relational Database System (RDS) instance which has been created. Open command prompt in <Installation ...
                    • How to install ADManager Plus in AWS

                      Steps to install ADManager Plus in Amazon Web Services EC2 instance: Logon to your Amazon Web Services (AWS) account. Select the configured EC2 instance and click the connect button. Connect to your Windows instance using: RDP client by downloading ...
                    • Will I be able to integrate ADManager Plus with third-party applications that are not listed in ADManager Plus?

                      ADManager Plus can be integrated with any human capital management (HCM), human resource management system (HRMS), security information and event management (SIEM), IT service management (ITSM) and other applications that offer REST or SOAP API ...
                    • How to integrate ADManager Plus with BambooHR

                      To integrate ADManager Plus with BambooHR: Log in to ADManager Plus. Navigate to the Automation tab and select HCM Integrations. Under HCM applications, click BambooHR. Enter the company subdomain name provided by BambooHR. For example, if the domain ...