Reference: Parameters for migrating the Oracle Server databases for the data warehouse

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

Parameters for the data warehouse

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

In the samples, the supplied database name is RIDW.

Enter password for SYS account The password of the SYS user account.
Enter username to use to connect to the database The user name of the database administrator account.
Enter user password to set for the DBA account The password for the database administrator account.
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