Add Database Source

The Database source configuration screen allows you to enable the crawling and classification of content stored in your Microsoft SQL Server, MySQL, and Oracle databases.

Content must either be configured / crawled using the configured service accounts (IIS Application Pool User, Windows Services) or by using specific connection details.

Once connected it is possible to create an intelligent content mapping, crawling certain fields as unstructured index text, and other fields as mapped metadata. For more information please see the Database Configuration Wizard section.

If you wish to make other configuration changes before collection of the source occurs ensure you tick the checkbox "Pause source on creation".

Complete the following fields:

Option Description

Connection Type

Select your connection type: MS SQL, MySQL, or Oracle.

Server

Specify the server name of the database system to be crawled ("." can be used to indicate the local server).

Database Name

Specify the database that will be crawled. It is possible to configure multiple databases from the same server.

Authentication Method

Select authentication method: Integrated or SQL.

  • With Integration option selected, database will be accessed under the account currently logged on.
  • With SQL option selected, specify user name and password to be used when accessing the database.

OCR Processing Mode

Select processing mode for images in the documents:

  • Disabled – documents' images will not be processed.
  • Default – defaults to the source settings if configuring a path or the global setting if configured on a source.
  • Normal – images are processed with normal quality settings.
  • Enhanced – upscale images further to allow more accurate results. This will provide better accuracy but can lead to longer processing time if the images do not contain text.

Source Group

If you want to add database to a source group, select existing, or create a new one. See Source Groups for more information.

Pause source on creation

Select to make other configuration changes before the initial data collection starts.

After the source configuration is completed, you will be prompted to lauch SQL crawling configuration wizard. See Database Configuration Wizard for more information.