Create Database
The Create Database page gathers the information necessary to create the table space where the model will reside.
This page is displayed if you selected Create and define a custom CPM model on the first page.
Note: You must be logged in as administrator.
| Option | Description |
|---|---|
| Database Server Type | List of database server types. Choose Microsoft SQL Server or Oracle. |
| ODBC Data Source Name | Name of the data source for the ODBC driver that connects to the database server. The default for SQL Server is BPSQL1. The default for Oracle is BPORA1. |
| TNS Service | Oracle only. The TNS name. This name is required and must be set up in the tnsnames.ora file. The TNS name in the tnsnames.ora file includes the host name, service name, and port number for each TNS name. This is populated based on the ODBC DSN. |
| Database Server | SQL Server only. Name of the server computer on which the SQL Server database is installed. This is populated based on the ODBC DSN. |
| Data Source Name | Name of the data source that the wizard will create to connect to the model it is creating. The data source is used later in views and processes. If you want to use the sample views with this model, you must name the data source CTrainRelational or BusinessEdition. |
| Host | Oracle only. Name of the server computer on which the Oracle database is installed. |
| Service Name | Oracle only. Name of the Oracle service. |
| Port | Oracle only. Port number for the Oracle service. |
| Driver | List of drivers. |
| Database Administrator Authentication | SQL Server only. Select the authentication type for the database administrator. Authentication specifies how the database administrator connects to the CPM model. Select the Database option if Microsoft SQL Server authentication is used to sign in to CPM. Select the Integrated option if Windows authentication is used to sign in to CPM. If you select Integrated, the Database Administrator User ID and Database Administrator User Password options are automatically filled in. |
| Database Administrator User ID | User ID to use when connecting to the database server. This user ID is used to create the database and must have database administration permissions. |
| Database Administrator User Password | Password for the database administrator user ID. |
| Test Connection | Verifies the connection using the supplied details. |
| End User Authentication | Select the authentication type for users. End User Authentication specifies how the user connects to the CPM model. Select the Database option if Microsoft SQL Server authentication is used to sign in to CPM. Select the Integrated option if Windows authentication is used to sign in to CPM. |
| CPM Model Name | Name for the new model. If you want to use the sample content with this model, you must name the model CTrain or BusEd. |
| CPM Model Password | Password to access the CPM model. See Password restrictions. |
| Model User | SQL Server only. Select this check box to add your user as a model user for the model you are creating. Your user must already be set up as a user for the database. If you plan to use Model Builder to load the model after it is built, this check box must be selected. |
| Use default database directory | Saves the database files to the Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\DATA directory. |
| Database Directory | Directory name and path. This is where the database files are created. The path must be referenced in terms of the database server and the directory must be writable. |