Reference: Microsoft SQL Server parameters for creating the databases for the data warehouse

See a list of the parameters, and their explanations, that are needed to manually create the databases for the data warehouse.

Parameters for the data warehouse

Prompt Explanation
Enter SQL Server Instance to use on local host name The name of the SQL Server instance. If no value is specified the default instance will be used. If you are using the default MSSQLSERVER instance, press Enter.
Enter name of the database to create The alias of the database for the data warehouse. The alias can contain up to 8 letters.

In the Rational® Insight samples, the supplied database name is RIDW.

Enter schema under which the operational data store will be built The name of the schema for the operational data store. The name can contain up to 8 letters.

In the Rational Insight samples, the supplied schema name is RIODS.

Enter schema under which the star schema will be built The name of the schema for the star schema. The name can contain up to 8 letters.

In the Rational Insight samples, the supplied schema name is RIDW.

Note: If you specify a name other than RIDW, make sure that the qualified references to the tables and views in the Framework Manager package match the name you specify here for the star schema.
Enter user name that will connect and run the reports The database users who need to connect to the database for running and viewing reports.

In the Rational Insight samples, the supplied user name is rptuser.

Specify a base directory for the table space files A fully qualified path where the table space files will be created and placed. For example, c:\Program Files\Microsoft SQL Server\MSSQL.1.
Enter earliest year to populate the date dimension with The start year for populating the tables.
Enter latest year to populate the date dimension with The end year for populating the tables.

Parameters for the data warehouse with sample data

Prompt Explanation
Enter SQL Server Instance to use on local host name The name of the SQL Server instance. If no value is specified the default instance will be used. If you are using the default MSSQLSERVER instance, press Enter..
Enter name of the database to create The alias of the database for the data warehouse. The alias can contain up to 8 letters.

In the Rational Insight samples, the supplied database name is SAMPLEDW.

Enter schema under which the operational data store will be built. The name of the schema for the operational data store. The name can contain up to 8 letters.

In the Rational Insight samples, the supplied schema name is RIODS.

Enter schema under which the star schema will be built The name of the schema for the star schema. The name can contain up to 8 letters.

In the Rational Insight samples, the supplied schema name is RIDW.

Enter user name that will connect and run the reports The database users who need to connect to the database for running and viewing reports.

In the Rational Insight samples, the supplied user name is rptuser.

Specify a base directory for the table space files A fully qualified path where the table space files will be created and located; for example, C:\DB_Location
Specify the instance's base home directory A fully qualified path for the home directory of the database instance; for example, c:\Program Files\Microsoft SQL Server\MSSQL.1

Feedback