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.
From the Admin Panel, click the Database mapping menu item
Update the default values or click + Add DB mapping
Retrieve the sourceId value from the index and enter it in the Source ID field
Enter the exact name of the database table that is to be mapped and permission-checked in the Database table
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
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.