Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Database Server Connector will crawl content from a Relational Database.


Easy Heading Free
navigationTitleOn this Page
wrapNavigationTexttrue
navigationExpandOptionexpand-all-by-default

Database Engines Supported


The Aspire Database Server connector was created and tested using the following databases engines:

  • MySQL Server
  • Microsoft SQL Server
  • Oracle Database

Other engines could work with the connector, but is not guaranteed. 

User Account Requirements 


To access the Database Server, a user account with sufficient privileges must be supplied to discover and extract databases, tables, and rows. The permissions vary on the database engine used.

Framework and Connector Features


Framework Features

Name Supported
Content Crawling
yes
Yes
Identity Crawling
yes
Yes
Snapshot-based Incrementals
yes
No
Non-snapshot-based Incrementals
yes
No
Document Hierarchy
yes
Yes

Connector Features

The Database Server connector has the following features:

  • Scans all the databases in on the server.
  • Extracts table information from all databases.
  • Extracts the rows from all the tables extractedfound.

Content Retrieved


The Database Server connector retrieves several types of documents.

  • Databases
  • Tables
  • Rows

Limitations


The Database Server Connector has the following limitations:

  • Incremental crawls are not supported at this moment.
  • Blob columns are not extracted.
  • Data extracted
depend
  • depends on the database engine rules, not all tables extracted can be scanned.