Introducing the JDBC Database Connector

Connectors : Default Connectors : JDBC Database Connector : Introducing the JDBC Database Connector

The JDBC Database connector allows you to index the content of an SQL Database accessed through JDBC. It uses configurable queries to extract records. Records are then processed to build the documents to index.

The record processing is configurable and can be extended by custom code.

This chapter explains how to deploy and configure Exalead CloudView JDBC Database connectors. You must have working knowledge of:

• The operating system on which the Exalead CloudView server and the JDBC Database are installed.

• The JDBC Database source structure.

• The Administration Console.

Prerequisites

This connector requires:

• A JDBC driver for the JDBC Database you want to index.

• A user account that has access rights on the JDBC Database Server.

Workflow

Before you can configure the JDBC Database connector specific parameters, you must:

• Install the driver. See Installing JDBC Drivers.

• Create the connector. See Creating a Standard Connector.

You then need to perform the following configuration tasks in this order:

• Connect to the JDBC Database

• Specify the Query Parameters

• Define the Fields to Crawl