Configuration of DataCentral

Basic Configuration

Database Connection

When you start DataCentral for the first time, you will be asked to connect to a database.

To do this, first select the entry “Use existing SQL server”.

SpaceObServer DataCentral

Note

For testing purposes you can choose to install MS SQL Express as mentioned in Database. After the installation proccess you can skip to Create First Indexing.

Then simply follow these step-by-step instructions:

SpaceObServer DataCentral

  1. First select the type of database.

  2. Enter the server name on which your database is located.

  3. Now enter your authentication for the database or use Windows authentication for Microsoft SQL Server.

  4. Enter the name of your database.

  5. Test the connection as soon as you have made all 4 previous settings to check whether the connection to the database can be established.

  6. After the connection test was successful and you have entered a database name, save the settings by clicking on “Apply”.

Note

We recommend activating data encryption for the database connection. We explain how to do this in Data Encryption.

Create First Indexing

After your first successful connection to a database, you can now define a storage system that you would like to index. To do this, click on the “Scan” > “Add Scan” tab.

SpaceObServer DataCentral

Now enter the UNC path to the server you want to index. Click on “More” to open an input mask that simplifies your selection.

Note

DataCentral does not create a full-text index for SharePoint and instead accesses the index that SharePoint itself provides. You can therefore disregard an existing SharePoint server when indexing.

Next, set a suitable schedule for updating the data in the index. Note that the regularity with which you update the index will have an impact on the timeliness of the search results in UltraSearch.

We recommend frequent updating for the best search results. However, you should check for yourself how much time it takes to update your database in order to determine the optimum interval for you.

Note

The initial indexing or the first scan usually takes longer than all subsequent scans, as the first data is also written to the database with this scan. You should therefore only evaluate updates (update scans) as a reference, which then only take incremental changes into account.

Also make sure that the option “Create fulltext index” is activated if you want to create a full text index for the content search.

Conversely, this also means that searching on scans that do not have this option activated cannot return any results for content searches.

Note

When activating the option for the first time, it may take a little longer for the full text index to be created.

Further useful tips:

  • You can also define that the first scan should be started immediately after setup.

  • If you would like to use different users for different scans, you can specify this in the options when creating.

  • If a drive to be indexed is an NTFS drive, you should check whether you want to activate the option Follow mountpoints and external symbolic links.

  • The other options are not relevant for the first indexing.