Configuring DSN for Launcher startup

This information also applies to establishing a Windows-based data source name for the Informix® adapter. For information about how to configure a DSN for UNIX, see your UNIX documentation.

Using ODBC, data sources are configured in the ODBC Data Source Administrator applet in the Control Panel as system sources (System DSN) that are visible to all users and NT services on the system, or to user sources (User DSN) that are visible only to you, the current user.

For Windows operating systems, access this applet by selecting Administrative Tools in the Control Panel, then Data Sources (ODBC).

Based upon each data source configuration, the data source is allowed access only if the logon account is correctly specified. A system data source can be accessed only when using a system account logon, which is the default. A user data source can be accessed only when using a user account logon that must be specified.

When using the Launcher and access to ODBC data sources is required, the Launcher must be started from the Services applet with the correct logon, either system or user account, that allows access to the data sources required by the Launcher during runtime.

For example, if a data source is defined as a system source in the System Data Sources list on the System DSN tab, the Launcher must be started using the System Account logon, which is the default.

However, if your ODBC data sources are defined as user data sources and are listed in the User Data Sources list on the User DSN tab of the ODBC Data Source Administrator applet, you must change the Launcher Startup options so that the logon is specified for the user account. This allows the Launcher to have access to the data sources associated with the user account that are required during Launcher runtime.

The following steps are based on the Windows operating system.

To change Launcher Startup Options:

  1. From the Start menu, select Settings > Control Panel.
  2. Select Administrative Tools.
  3. Open the Services applet.

    The Services dialog appears.

  4. In the Name column, double-click IBM Transformation Extender Launcher.

    The IBM Transformation Extender Launcher Properties dialog appears.

  5. Click the Log On tab.

    The Log On page appears.

  6. Enable This account and click Browse to select the user account under which the DSN was created.
  7. Enter values for the selected user account in the Password and Confirm password fields. The Launcher will use these values to log on to the system and access the user data sources.
  8. Click OK.

For more information, see the Launcher documentation.