Import Enrollment Data from External Database:

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.


Establishing Connection:

The first step is to "establish connection with an external data base" from where the data is going to be fetched.

  1. Select Configuration -->Administrative Tools --> External Data Sources.

  2. Click on 'Add New Data Source' to create a new data base Connection.

  3. "Data Base Connection" page appears on screen.

  4. Enter the "Connection Name" in the textbox provided.

  5. Select the 'Data Base Server' from the 'Select DB Server' drop down list box.

  6. Specify your "Hostname/IP Address"  in the respective box provided.

  7. Give the 'Port Address' as well.

  8. Choose a suitable Data Base to which the connection is to be made.

  9. Mention the "username".

  10. Follow it up with the password (if the password has not been configured, then the respective textbox can be left empty).

  11. Select "SAVE" to save the settings that were configured.

  • The user should have the privileges to execute basic commands in the database server.

  • The ADSelfService Plus installed machine must be granted the permission to access the database server.


Once the connection has been established, the next step is to fetch the "Enrollment Data" from the external database.


Fetching the Enrollment Data from an External Database:

  1. Select Admin -->> External Data Sources.

  2. Click on ADD to create a new Enrollment Data fetcher.

  3. Enter an apt "Fetcher Name".

  4. Select the "Connection" that you just created.

  5. Choose the "Policy" to which this "Enrollment Data" will apply.

  6. Type the appropriate "Query" to fetch data from the external database table .

  7. Click on Save to save the configured settings.

  • The general form used while formatting a "Query" is "Select Username, Question, Answer from TableName;" or "Select Username, Mobile Number, Email ID from TableName;"

  • "Conditions/Join Queries" too can be used.

  • In the case of Oracle Server, avoid "semicolon"(;) at the end of the "Query"


Fetch Again:

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 Again" option.

The "Fetch Again" option is indicated by an upward pointed arrow. Clicking on this arrow would update the database with the newly added entities.

Copyright © 2020, ZOHO Corp. All Rights Reserved.