Creating a Source for the Database Connector

This topic covers creation of an Oracle Secure Enterprise Search Source to integrate with the Siebel Search Database Connector. This task is executed in the Oracle Secure Enterprise Search Administration application.

This task is a step in the Process of Setting Up the Database Source and Connector.

To create a source for the Database Connector

Navigate to the Sources screen.
Select Database from the Source Type menu.
Click Create.

Complete the Database Source fields. The fields are described in the following table.

Field	Description
Source Name	The name of the Database Source. This value corresponds to the crawler connector Library name in the Siebel Search Administration Search Connector Settings view. Set the value to Database.
Database Connection String	The JDBC connection string for the database. Set the value to the following for an Oracle database: `jdbc:oracle:thin@<Hostname>:<Port Number>:<SID>` Set the value to the following for SQL Server: `jdbc:sqlserver://<Hostname>`
User ID	User ID to log in to the database.
Password	Password to log in to the database.
Query	Query to retrieve contents for crawling.
Query File	Path to the XML file specifying the attribute and attachment sub queries.
Cache File	Absolute path and filename prefix of temporary file for caching crawled data, for example: `c:\temp`
Path Separator	Path separator in the document path. Set the value to #.

Click Next.
Select ACLs Controlled by the Source to secure the table that is crawled.
Click Create.