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.
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
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."