This is a feature of ADSelfService Plus which can be used by you, the admin, to connect in-house data sources like Oracle, MS SQL, MY SQL, PostgreSQL and the other external data sources with ADSelfService Plus. These external data sources can then be used to store Enrollment data.
The first step is to "establish connection with an external data base" from where the data is going to be fetched.
Select Configuration -->Administrative Tools --> External Data Sources.
Click on 'Add New Data Source' to create a new data base Connection.
"Data Base Connection" page appears on screen.
Enter the "Connection Name" in the textbox provided.
Select the 'Data Base Server' from the 'Select DB Server' drop down list box.
Specify your "Hostname/IP Address" in the respective box provided.
Give the 'Port Address' as well.
Choose a suitable Data Base to which the connection is to be made.
Mention the "username".
Follow it up with the password (if the password has not been configured, then the respective textbox can be left empty).
Select "SAVE" to save the settings that were configured.
Once the connection has been established, the next step is to fetch the "Enrollment Data" from the external database.
Select Admin -->> External Data Sources.
Click on ADD to create a new Enrollment Data fetcher.
Enter an apt "Fetcher Name".
Select the "Connection" that you just created.
Choose the "Policy" to which this "Enrollment Data" will apply.
Type the appropriate "Query" to fetch data from the external database table .
Click on Save to save the configured settings.
Updating an existing data source can be done with the help of a process called "Fetch Again" option.
Eg. Let's say about "100
new users" are added to an "already connected data source"
then these users can be easily "updated" using the "Fetch
The "Fetch Again" option is indicated by an upward pointed arrow. Clicking on this arrow would update the database with the newly added entities.