Configuring TSD Data Sources


Overview

Tasks

Included with

Tivoli Service Desk

Overview

Data sources

To connect and use your database management system (DBMS), Tivoli Developer's Toolkit (TDT) must know about certain characteristics of your DBMS. In other words, it must be configured.

The basic unit of configuration is the data source. You may configure multiple data sources. A data source is a logical notion that normally corresponds to a physical DBMS server.

Data source configuration file

Data source configuration information is stored in a file. This configuration file is an ASCII text file that has the same format as a Windows INI file. By default, TDT looks in your <SAI_ROOT>\CFG directory for a file called sai_sql.cfg. You may override this by setting an environment variable called SAISQLCFG to the desired file name (including path).

How to configure a data source

For more information on configuring data sources, see:

SQL Configuration Editor dialog box

Use the SQL Configuration Editor dialog box to maintain TSD data sources and their associated database connections.

The SQL Configuration Editor dialog box contains two lists you can scroll:

  • The Sources list contains the names of of currently configured data sources.
  • The Options list contains the options (in ATTRIBUTE=VALUE format) that are configured for the highlighted data source.

To access the SQL Configuration Editor dialog box, do one of the following:

If you are using... then...
Windows 95, Windows 98, or Windows NT 4.0
  1. From the taskbar, choose Start.
  2. From the Start menu, point to Programs, choose Tivoli Service Desk 6.0, choose Service Desk, then choose SQL Configuration Editor.
OS/2
  1. Choose the Tivoli Service Desk folder.
  2. Choose the SQL Configuration Editor icon.
UNIX
  1. Change to the directory where the Tivoli Service Desk program resides.
  2. At the command line, do one of the following:
    • Type kml ce and press Enter.
    • Type sqlcfg and press Enter.

Result: The SQL Configuration Editor dialog box appears.

Tasks

Adding a new data source

To add a new data source:
  1. In the SQL Configuration Editor dialog box, choose Add.
  2. In the Driver Selection dialog box, select a driver for the new data source.
    For more information, see Selecting a Data Source Driver.
  3. In the Source Setup dialog box, in the Source box, type the data source name.
  4. Configure the data source options.
    For more information, see Configuring an Existing TSD Data Source.

Deleting a data source

To delete a data source:
  1. In the SQL Configuration Editor dialog box, from the Sources list, select a data source.
  2. Choose Delete.
  3. At the Warning message, choose OK.
    Result: The selected data source is immediately removed from the Sources list in the SQL Configuration Editor dialog box and is no longer available for use with Tivoli Service Desk applications.

Copying a data source

Copying a data source creates a new data source with a different name. The data source definition is copied to the new data source. If the selected data source is the default source, it remains the (only) default data source.

To copy a data source:

  1. In the SQL Configuration Editor dialog box, from the Sources list, select a data source.
  2. Choose Copy.
  3. In the Source Entry dialog box, in the Source box, type the name of the new data source and choose OK.
    Result: The new data source name appears in the Sources list of the SQL Configuration Editor dialog box.
    Note: For information on rules for data source names, see Data Source Name Restrictions.
  4. Change the data source configuration as necessary.
    For more information, see Configuring an Existing TSD Data Source.

Designating a default data source

The default data source is the one Tivoli Script uses if no data source name is given when connecting to the database. You can have only one default data source. The default data source is indicated by an asterisk (*) preceding the data source name in the SQL Configuration Editor dialog box.

To designate a default data source:

  1. In the SQL Configuration Editor dialog box, from the Sources list, select a data source.
  2. Choose Make Default.
    Result: The selected data source becomes the default data source. Any previous default source is no longer the default.