How to automatically enroll users with ADSelfService Plus using an external database?
Privileges
- The ADSelfService Plus server should have permission to access the external database server.
- SELECT privilege over the database table(s) for the user account that will be querying the external database. This should be an account in the database application, or an Active Directory domain account if the external database is MS SQL.
How is it done?
- Establish a connection with an external data base
- Select Configuration → Administrative Tools → Quick Enrollment → Import Enrollment Data from External Database.
- Click on Add New Data Source.
- Enter the details and click Create to establish a database connection.
- Fetch the enrollment data from the external database.
- Click on to Add data fetcher.
- Enter the details.
- Type the appropriate Query to fetch data from the external database table.
- Click on Save to save the configured settings.
- To update the bulk user additions from the data source, periodically, click on Fetch Again to fetch new data.
A scheduler can be configured to search for new user additions in the data sources at different frequencies, as required, and enroll them with ADSelfService Plus.
Check out the detailed steps to configure.
Stay tuned to know on how to self-populate user information, using ADSelfService Plus.
New to ADSelfService Plus?
Related Articles
How to enable Partial Enrollment for Active Directory users in ADSelfService Plus
Active Directory domain users need to complete enrollment with ADSelfService Plus before they can use the below listed features: Self-service password reset Self-service account unlock Endpoint multi-factor authentication ADSelfService Plus' logon ...How to automatically enroll new users for self-password reset with CSV files?
With a multitude of users, ensuring them to enroll for password expiry notifications can be a cumbersome process. Despite the reminders, when the user fails to enroll, the administrator’s intervention becomes mandatory. With ADSelfService Plus' Auto ...Multi-factor authentication techniques in ADSelfService Plus
Let's take a look into the various authentication methods supported by ADSelfService Plus for enterprise multi-factor authentication (MFA). Why should you use MFA? Authentication based solely on usernames and passwords is no longer considered secure. ...Encryption and data storage in ADSelfService Plus database
Encryption in the ADSelfService Plus database ADSelfService Plus' database uses the following encryption methods to store sensitive data: Database Encryption method PostgreSQL AES-256-CBC Microsoft SQL AES-256-CBC The following sensitive information ...Configuring high availability in ADSelfService Plus
ADSelfService Plus utilizes automatic failover to support high availability in case of system and product failures. Essentially, this means that when the ADSelfService Plus service on one machine fails, another instance of ADSelfService Plus running ...