Create a Controller Data Mart Database for Microsoft SQL Server

If you want to use the Publish to Data Mart Framework Manager model provided with IBM® Cognos® Controller, you must create an additional database to use for the Controller data mart. Here are the steps you must follow for Microsoft SQL Server.

Procedure

  1. If you performed a Typical installation of Microsoft SQL Server, after you install you must change the authentication mode to SQL Server and Windows.

    For more information, see the related knowledge base article on the Microsoft Web site.

  2. Create the database.

    Ensure that the database collation sequence is case insensitive.

  3. Determine which user account Controller Web Services Server will use to access the database.
  4. Grant create table privileges for the database to the user account.

    Ensure that the user account is a member of the db_owner role.