✖

- Related Products
- ADManager Plus

  Active Directory Management & Reporting

  Download | Demo
- ADAudit Plus

  Real-time Active Directory Auditing and UBA

  Download | Demo
- EventLog Analyzer

  Real-time Log Analysis & Reporting

  Download | Demo
- Exchange Reporter Plus

  Exchange Server Auditing & Reporting

  Download | Demo
- AD360

  Integrated Identity & Access Management

  Download | Demo
- Log360

  Comprehensive SIEM and UEBA

  Download | Demo

# Auto-enrolling users by importing data from external databases

Using this option, you can connect databases such as Oracle, MS SQL, MySQL, and PostgreSQL with ADSelfService Plus, and import the enrollment data stored in them. This option comes in handy if you already have all the necessary enrollment data stored in an external database.

#### Steps for configuring auto-enrollment via database import

1. Log in to the ADSelfService Plus web console as an admin.
2. Navigate to Configuration → Administrative Tools → Quick Enrollment → Import Enrollment Data from External Database.
3. Click Add New Data Source.
4. Enter a Connection Name for the data source.
5. Select the type of database that you want to connect to from the Select DB Server drop-down.
6. Enter the Host Name/IP Address and Port number of the database server.
7. Enter the name of the database that stores your enrollment data in the DB Name field.
8. In the Username and Password fields, enter the credentials of a user who has privileges to query the database server.
9. Click Create.
10. Back on the Import Enrollment Data from External Database screen, click Add New Fetcher.
11. Enter a name in the Fetcher Name field.
12. Select the connection that you just created from the Select the Connection drop-down.
13. Select a policy from the Select Policy drop-down.
14. Select the enrollment data that you want to import from the Import drop-down.
15. In the SQL Query field, type the appropriate query to fetch the necessary data from the database table.

    #### Sample query:

    Select Username, Mobile Number, Email ID from < TableName >;

16. Click Save.

#### Importing User Enrollment Data

- Manually : If there are new users added to the database, then simply click the Fetch Again icon to enroll the newly added users.
- Automatically : You can also set up a scheduler to automatically update the enrollment data of new users at regular intervals.

## Thanks!

Your request has been submitted to the ADSelfService Plus technical support team. Our technical support people will assist you at the earliest.

#### Need technical assistance?

- Enter your email ID
- Talk to experts

- By clicking 'Talk to experts', you agree to processing of personal data according to the Privacy Policy.

Copyright © 2021, ZOHO Corp. All Rights Reserved.