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. |
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 |