GenericSQL Connector Data Sheet

Owned by Steinar Skjerven
Last updated: Dec 06, 2018 by Jeremy Sommer (Deactivated)

Release Notes

Release Notes

Released Versions

  • SDK 1.4 (ViaWorks 2.8)
  • SDK 1.5 (Locator 2.9)
  • SDK 1.6 (Locator 2.10)

Supported Versions

The database connector frameworks supports the following database connection types:

  • Odbc
  • Microsoft SQL
  • Oracle
  • PostgreSQL

Limitations

The database connector framework can be used to develop fairly sophisticated connectors. However, it does have limitations. The following are the most notable limitations:

  • Relies on database connectivity
  • Implements a simple document model
  • Implements a simple discovery algorithm
  • Does not implement user authentication, only user security identifiers
  • Requires implementation of full scan discovery
  • Provides limited options for performance optimization

Prerequisites

  • A license for the GenericSQL Connector.
  • Knowledge of the database connector framework
  • GenericSQL Connector with Oracle backend requires 64-bit Oracle Data Access Components (ODAC) installed on the Locator servers.

Supported Data Types

Which data types to be indexed is determined by the developer

Crawl Methods

Full Crawl: The GenericSQL Connector supports creating periodic full scans of the source systems.

Incremental Crawl: The GenericSQL Connector supports creating ChangeSet scans of the source systems.

DocumentHandler

Not supported by database framework out of the box.

Other information

None


ayfie