Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Search Administration Guide > Installing Siebel Search Under UNIX > Creating a DataDirect ODBC Datasource Under UNIXYou need to configure a DataDirect ODBC datasource to use with SearchServer. To create a DataDirect ODBC datasource
For Oracle DatabasesUnder 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: Driver=/export/home/fulcrum/DataDirect/lib/HDora18.so (AIX) Description=DataDirect 4.10 Oracle Wire Protocol (AIX) HostName=<Oracle database host name> PortNumber=<Oracle database port number> SID=<Oracle System Identifier> EnableStaticCursorsForLongData=0 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 DatabasesUnder the "[ODBC Data Sources]" section, add a new line for your datasource. For example:
Now you need to add a new section for your datasource, specifying the parameters specific to your database connection, for example: Driver=/export/home/fulcrum/DataDirect/lib/HDdb218.so Description=DataDirect 4.10 DB2 Wire Protocol Driver 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 OnlyIf 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).
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. |
![]() |
![]() ![]() |
Siebel Search Administration Guide |