Database Connection
The Database Connection page collects the connection information needed to create the database.
The Database Connection page is displayed if you selected Define a CPM custom model in an existing database on the first page.
| 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 | Microsoft SQL Server only. Name of the server computer on which the Microsoft SQL Server database is installed. This is populated based on the ODBC DSN. |
| Data Source Connection | Creates a data source or enables you to select an existing data source from a list. |
| 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 SQL Server authentication is used to sign in to CPM. Select the Integrated option if Windows authentication is used to sign in to CPM. |
| 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. If selecting Use Existing for Data Source Connection, this becomes a list of available data sources. |
| 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 of the Oracle service. |
| Driver | List of drivers. For Oracle, select the Oracle 32-bit home driver. |
| 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. |
| Test Connection | Verifies the connection using the specified details. |