Creating a Kerberos-enabled data source

You can create a data source authenticated by the Kerberos protocol by using IBM Cognos Administration. A data source defines the physical connection to a database. The data source specifies the parameters that are needed to connect to the database, including sign-on.

Procedure

  1. In IBM® Cognos® Connection, select Launch > IBM Cognos Administration.
  2. On the Configuration tab, select Data Source Connections.
  3. Select the New data source button New data source icon.
  4. In the Name and Description page, type a unique name for the data source.
  5. In the Connection page, from the Type menu, select the type of data source that you want to create, such as Microsoft SQL Server or Microsoft Analysis Services.
  6. Under Isolation level, select Use the default object gateway, and click OK.
  7. Specify the connection parameters for the Microsoft SQL Server data source.

    For information about connection parameters for the data source, see the IBM Cognos Business Intelligence Administration and Security Guide.

  8. Under Signon, select An external namespace, and choose the namespace that you created to authenticate users against the Kerberos data source.

    The credentials that are used to authenticate to the data source are taken from the specified namespace to which the user authenticated previously.

  9. To test whether the parameters are correct, click Test the connection, and then click Test.

    In the Status column, you can see whether the connection was successful. If it was unsuccessful, click Close, return to the previous steps, and verify your connection parameters.

Results

The new Kerberos-enabled data source is displayed in the Data Source Connections list on the Configuration tab, and can be selected when you are using the Metadata wizard in Framework Manager.