Configuring Database mapping

Organizations may restrict employee access to database records via Active Directory. Discovery Search supports permissioned searching of content sources, including SQL databases. The Database mappings feature allows for the configuration of permissioned content sources. When configured, search results are restricted to records that an employee has permission to view.

Microsoft® SQL Server versions 2012 to 2022 are supported with this feature.

1. From the Admin Panel, click the Database mapping menu item

2. Update the default values or click + Add DB mapping

3. Retrieve the sourceId value from the index and enter it in the Source ID field

4. Enter the exact name of the database table that is to be mapped and permission-checked in the Database table

5. Enter the value that Discovery Search will use to connect to the database in the Connection string field. For example: Server=myServerAddress;Database=myDatabase;Trusted_Connection=True

6. Click Save changes

Further configuration is required in the Database permissioned schematypes page in the Admin Panel under Application settings.

To remove a mapping, click the X in the top right corner of the mapping and save changes.