Bookshelf Home | Contents | Index | Search | PDF

Siebel Search Administration Guide > Installing Siebel Search Under UNIX >

Creating a DataDirect ODBC Datasource Under UNIX

---

You need to configure a DataDirect ODBC datasource to use with SearchServer.

To create a DataDirect ODBC datasource

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"

There are a number of changes that need to be made in the odbc.ini file:
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 datasource to odbc.ini.

For Oracle Databases

Under the "[ODBC Data Sources]" section, add a new line for your datasource, for example:

"Siebel_Search=DataDirect 4.10 Oracle Wire Protocol" (AIX)

"Siebel_Search=DataDirect 4.0 Oracle Wire Protocol" (Solaris)

"Siebel_Search=DataDirect 4.10 Oracle Wire Protocol" (HP-UX)

Now you need to add a new section to odbc.ini for your own datasource, specifying parameters for your database connection. For example:

[Siebel_Search]

Driver=/export/home/fulcrum/DataDirect/lib/HDora18.so (AIX)
Driver=/export/home/fulcrum/DataDirect/lib/HDora17.so (Solaris)
Driver=/export/home/fulcrum/DataDirect/lib/HDora18.sl (HP-UX)

Description=DataDirect 4.10 Oracle Wire Protocol (AIX)
Description=DataDirect 4.0 Oracle Wire Protocol (Solaris)
Description=DataDirect 4.10 Oracle Wire Protocol (HP-UX)

LogonID=<your login>

Password=<your password>

HostName=<Oracle database host name>

PortNumber=<Oracle database port number>

SID=<Oracle System Identifier>

CatalogOptions=0

ProcedureRetResults=0

EnableDescribeParam=0

EnableStaticCursorsForLongData=0

ApplicationUsingThreads=1

where

Driver contains the path to the driver HDora18.so (AIX) and HDora17.so (Solaris) and HDora18.sl (HP-UX) in your own setup.

LogonID is the ID you use to connect to the database.

Password is the name of the password for the specified LogonID.

Host is the name or the IP address of the server to which you want to connect.

Port Number is the port number of your Oracle listener. See your database administrator for the correct number.

SID is the Oracle System Identifier that refers to the instance of Oracle running on your server.

Now save your changes to odbc.ini.

For DB2 Databases

Under the "[ODBC Data Sources]" section, add a new line for your datasource. For example:

"siebsrvr_siebel=DataDirect 4.10 DB2 Wire Protocol Driver"

Now you need to add a new section for your datasource, specifying the parameters specific to your database connection, for example:

[siebsrvr_siebel]

Driver=/export/home/fulcrum/DataDirect/lib/HDdb218.so

Description=DataDirect 4.10 DB2 Wire Protocol Driver

LogonID=siebel

Password=db2

IpAddress=devaix3

Database=UDEV75 (for UDB)

Location=UDEV75 (for DB2/390)

Collection=SIEB (for DB2/390)

TcpPort=57010

Package=db2pac (for UDB)

Package=DB2PAC (for DB2/390)

Action=REPLACE

where

Driver contains the path to the driver HDdb218.so in your own setup.

IpAddress is the database server machine name or IP address

Database is the name of your database

TcpPort is the port you are using to connect to the database

Now save your changes to odbc.ini.

NOTE:  For DB2 UDB or DB2/390 databases, you should use a different value for the Package parameter than that listed in the previous example. Moreover, for DB2 UDB, you should use Database but for DB2/390, you should use the Location and Collection parameters. You may need to confirm the correct values of these parameters with your Database Administrator. In the section Additional Step for DB2 Databases Only you will run the bind program to connect to the DB2 database. If your database information is not configured correctly, your bind program will fail.

Additional Step for DB2 Databases Only

If you are using a DB2 database, you will need to perform the following additional step.

NOTE:  You will need to use the username and password specified above (siebel and db2) for this step to work correctly. You will also need to log into the Siebel application with this user name and password (siebel and db2) whenever you wish to create or refresh indices.

For this additional step, you need to run a program that binds a package for the database server you need to connect to. You can do this by using the "bind18" program located in the fulcrum/DataDirect/lib directory. You run the command with 1 argument, the name of the datasource (in this case, siebsrvr_siebel).

source '/export/home/fulcrum/setfuladmin.csh'
run 'cd /export/home/fulcrum/DataDirect/lib'
run './bind18 siebsrvr_siebel'

This step only needs to be done once, because other datasources can use the same bind package named "db2pac". This parameter is specified by the "Package" variable in your datasource configuration.

NOTE:  DataDirect constrains the "Package" parameter to be no more than 6 characters in length.

Bookshelf Home | Contents | Index | Search | PDF