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
- Navigate to the fulcrum/DataDirect, for example:
cd /export/home/fulcrum/DataDirect
- Open the file odbc.ini in this directory with a text editor such as vi, for example:
vi odbc.ini
- Apply the following changes to the file Odbc.ini:
- 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.
- Add a data source to the Odbc.ini file.
- 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
- Add a new section to odbc.ini for your own data source, specifying parameters for your database connection.
- 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
- 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.
- Save your changes to odbc.ini.
|