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. Before importing the enrollment data, make sure to configure the settings for the respective authenticators in the self-service policies. To learn more on how to set up the authenticators supported by ADSelfService Plus, click here.
The data imported should follow the specified formats for each authenticator as mentioned in the table below.
The database header names given below are sample header names and the same names need not be followed. sAMAccountName is a mandatory data and it must be a valid username present in AD.
Authenticator | Database header names | Allowed formats |
---|---|---|
Security Questions and Answers | question | It must be a security question. Eg., What is your favourite colour? |
answer | It must be the corresponding answer to the security question. Eg., Yellow. | |
AD Security Questions | answer | It must be the corresponding answer to the security question. Eg., Yellow. |
SMS Verification | mobile | It must contain numbers 0 through 9. |
Email Verification | It must be a valid email address | |
Duo Security | sAMAccountName | It must be a valid user in AD. |
Google Authenticator | googleauth secret key | It must contain letters "A-Z" or "a-z" and numbers "2-7". |
Microsoft Authenticator | microsoftauth secret key | It must contain letters "A-Z" or "a-z" and numbers "0-9". |
Zoho OneAuth TOTP | zohooneauth secret key | It must contain letters "A-Z" or "a-z" and numbers "0-9". |
Custom TOTP – Software token | customtotp secret key | It must contain letters "A-Z" or "a-z" and numbers "0-9". |
Custom TOTP – Hardware token | customtotp hardware serial number | It must contain letters "A-Z" or "a-z" and numbers "0-9". |
customtotp secret key | It must contain letters "A-Z" or "a-z" and numbers "0-9". |
Sample query: Select UserName, Question, Answer, CustomTOTPSecretKey, CustomTOTPHardwareSerialNumber from TableName;
Your request has been submitted to the ADSelfService Plus technical support team. Our technical support people will assist you at the earliest.
Copyright © 2024, ZOHO Corp. All Rights Reserved.