Siebel Search Administration Guide > Setting Up Siebel Search with Oracle Secure Enterprise Search > Process of Setting Up the Database Source and Connector >

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

  1. Navigate to the Sources screen.
  2. Select Database from the Source Type menu.
  3. Click Create.
  4. 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 #.

  5. Click Next.
  6. Select ACLs Controlled by the Source to secure the table that is crawled.
  7. Click Create.
Siebel Search Administration Guide Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices.