Loading

You can import User details from other Database (DB), such as MS SQL.

To import User details from DB:

Select Admin > Basic > Users > Import > DB Import.
On the DB IMPORT page, click ADD NEW on the ACTIONS panel. Type in the required details. For more information about fields on the DB IMPORT page, see Field Description.
Click SUBMIT.

Figure: DB IMPORT page

Field Description

The following table describes the fields on the DB IMPORT page:

Field	Description
DETAILS
SQL Server Name	Specify the SQL Server Name.
Database Name	Specify the database Name of the specified SQL server.
Login	Specify the login name to access the specified SQL database server.
Password	Type in the password.
Confirm Password	Re-enter the password for confirmation.
SQL Query	Write the SQL query to import user details from the other database to Summit database.
icon	Click this icon to validate the specified SQL statement and to display in the Destination Column field values.
Sl no.	Displays the serial number for the source columns fields.
Source Column	Displays the standard fields from SUMMIT.
Required	Displays if the source is mandatory. If Yes, it indicates the source field is mandatory.
Destination Columns	Lists the validated destination column data to map to the Source column. Select any one option from the list.

ACTIONS

This section explains all the icons displayed on the ACTIONS panel of the DB IMPORT page.

SHOW LIST

Click SHOW LIST to display the LIST table showing details of the imported DB.

Figure: DB IMPORT page: List of imported DBs

Note:

When the imported DB details are displayed under the LIST table, the ADD NEW action is displayed on the ACTIONS panel. Click ADD NEW to import data from a DB as described in this topic.

References

To import User details from Microsoft Excel, see Importing User Details Using Excel.
To import User details from Active Directory, see Importing Active Directory User Details.

Loading