Settings for crawling

This section describes the settings for crawling each data source.

Settings for crawling DataSpider Servista

To crawl a DataSpider Servista destination, set the Metadata adapter to DataSpider Servista.

1. Place "metadata_adapter" (folder with complete set of jar and other files) in "server\plugin\data_processing\modules" on the PC where DataSpider Servista is installed.

2. Restart the DataSpider Servista service.

 

Settings for crawling databases

Place a JDBC Driver compatible with your database in the "lib" folder.

Download the JDBC Driver from the manufacturer's website.

This product operates with drivers compliant with JDBC 4.1 or later.

= Remarks =

JDBC Drivers for the following databases are placed in the "lib" folder by default.

  • PostgreSQL

  • SQL Server

 

Settings for obtaining the updated date for each resource

= Remarks =

This section describes the settings required to obtain the updated date for each resource. For the latest setting procedure, refer to the setting method of each resource.

PostgreSQL

Set "track_commit_timestamp" to "on" in "postgresql.conf."

 

Oracle Database

  • Apply the MONITORING attribute to the table from which you want to obtain the date.

  • The ANALYZE ANY system permission is required for users.

 

SQL Server

Set the access permission for "sys.dm_db_index_usage_stats."