Selecting Data Source Drivers


Overview

Tasks

Included with

Tivoli Service Desk

Overview

Methods of attaching to a database

Regardless of which DBMS you use, you must connect or attach to it. The method of attaching or connecting varies, however. You should be familiar with the method of attaching to the DBMS you use with the Tivoli Service Desk Suite.

Examples:

  • With DB2, you connect to a database.
  • With Sybase, you connect to the database server. You may have multiple simultaneous connections to the same server and to the same database.
  • With Oracle, most implementations do not make use of the database concept at all, at least in the sense described here. Everything is accessed by the server.

TSD database drivers

TDT connects to your database server through a driver DLL. TDT includes TSD-written drivers for Oracle, Sybase preferred (via CT-LIB), Sybase non-preferred (via DB-Lib), and Microsoft SQLServer (via DB-Lib), and Informix. These drivers conform to the X/Open CLI specification; their names appear in the table below. In addition, a separate choice for specifying the text search driver is provided in the event that you are using this text search engine.

DBMS Driver
Oracle XOOR
Sybase preferred XOCT
Sybase non-preferred XOSS
Microsoft SQLServer XOSS
Informix XOINF

Although TDT includes DB2 family drivers, TDT supports the direct use of IBM's DB2 CLI driver, since it is also X/Open compliant.

TDT also supports most ODBC drivers that are CORE and LEVEL 1 compliant.

Warning: Although TDT may be able to work with a compliant ODBC driver at a basic level, this is not a guarantee that the driver works with a complex TSD application, such as Tivoli Service Desk. For a list of TSD-certified drivers, contact TSD customer support. See Contacting Tivoli Support.

Driver Selection dialog box

Use the Driver Selection dialog box to select a DBMS driver for a new data source.

To access the Driver Selection dialog box,


Tasks

Selecting a data source driver

The first step in configuring a new data source is to select a DBMS driver.

To select a data source driver:

  1. In the Driver Selection dialog box, select the appropriate DBMS driver for the data source you are configuring. For more information, see TSD Database Drivers.
  2. Choose OK.