Siebel Search Administration Guide > Installing Siebel Search Under UNIX >

Creating a DataDirect ODBC Data Source on Oracle Under UNIX

You must configure a DataDirect ODBC data source to use with SearchServer. This topic covers creating a DataDirect ODBC data source on an Oracle database.

NOTE:  There are different entry values for Hummingbird SearchServer Version 5.3.6 and Hummingbird SearchServer Version 6.

To create a DataDirect ODBC data source on an Oracle database

1. Navigate to the fulcrum/DataDirect, for example:

   cd /export/home/fulcrum/DataDirect

2. Open the file odbc.ini in this directory with a text editor such as vi, for example:

   vi odbc.ini

3. Apply the following changes to the file Odbc.ini:
   1. Within the [ODBC] section, replace all instances of <enter Connect ODBC installation path> with the fully qualified path up to and including your ./DataDirect directory.
   2. Add a data source to the Odbc.ini file.
4. Under the [ODBC Data Sources] section, add a new line for your data source, for example:
   • For Hummingbird SearchServer Version 5.3.6

   Siebel_Search=DataDirect 4.20 Oracle Wire Protocol Driver

   • For Hummingbird SearchServer Version 6

   Siebel_Search=DataDirect 5.0 Oracle Wire Protocol Driver

5. Add a new section to odbc.ini for your own data source, specifying parameters for your database connection.
   1. Add the following for SOLARIS and AIX:

   [Siebel_Search]

   Driver=<Install_Directory>/DataDirect/lib/<Driver>

   Description=DataDirect <version> Oracle Wire Protocol

   ApplicationUsingThreads=1

   ArraySize=60000

   CachedCursorLimit=32

   CachedDescLimit=0

   CatalogIncludesSynonyms=1

   CatalogOptions=0

   DefaultLongDataBuffLen=1024

   DescribeAtPrepare=0

   EnableDescribeParam=0

   EnableNcharSupport=0

   EnableScrollableCursors=1

   EnableStaticCursorsForLongData=0

   EnableTimestampWithTimeZone=0

   LocalTimeZoneOffset=

   LockTimeOut=-1

   LogonID=<db logon >

   Password=<db password >

   HostName= <db hostname >

   PortNumber=<db port>

   SID=<SID>

   ProcedureRetResults=0

   2. Add the following for HP-UX:

   [Siebel_Search]

   Driver=<Install_Directory>/DataDirect/lib/<Driver>

   Description=DataDirect <version> Oracle Wire Protocol Driver

   Database=<db name>

   IpAddress=<db server>

   LogonID=siebel

   Password=<db password>

   Package=db2pac

   TcpPort=<portnumber>

where:

• Install_Path contains the path to the driver.
• Driver corresponds to the version of the driver for the Hummingbird SearchServer version, and the operating system that you are using, for example:
  • For Hummingbird SearchServer version 5.3.6, use driver HDora19.so (for SOLARIS and AIX), or HDora19.sl (for HP-UX).
  • For Hummingbird SearchServer version 6, use driver HDora20.so (for SOLARIS and AIX), or HDora20.sl (for HP-UX).
• LogonID is the ID you use to connect to the database.
• Password is the name of the password for the specified LogonID.
• Hostname is the name or the IP address of the server to which you want to connect.
• Port Number. Check the *.ini file for the port number.
• SID is the Oracle System Identifier that refers to the instance of Oracle running on your server.

6. Save your changes to odbc.ini.