Reference: Parameters for migrating the Microsoft SQL Server databases for the data warehouse

Use these parameters to migrate the Microsoft® SQL Server databases for the data warehouse for reporting with IBM® Rational® Insight.

Parameters for the data warehouse

Prompt Explanation
Enter SQL Server Instance to use on servername The name of the instance that the Rational Insight data warehouse resides on.

If no value is specified, the default instance is used.

Enter name of the Insight database The name of the Rational Insight database.

In the samples, the supplied database name is RIDW.

Enter schema under which the operational data store is built The name of the Rational Insight schema for the operational data store.

In the samples, the supplied schema name is RIODS.

Enter schema under which the star schema is built The name of the Rational Insight schema for the star schema. The name can contain up to 8 letters.

In the samples, the supplied schema name is RIDW.

Enter user name that is used to run reports The Rational Insight database user who connects to the database for running and viewing reports.

In the samples, the supplied user name is rptuser.

Do you want to accept the new view definitions [1=Yes 0=No] Specify if you are willing to accept the redefinition of a view that already exists. If you accept the definitions, the view is dropped and recreated.

Feedback