Create Views Database
The Create Views Database option creates a new views database for Microsoft SQL Server or Oracle. The utility can create the database or provide a script that can be given to the database administrator. The utility also creates a views data source that is used to connect to the database.
The options on this screen depend on the selected database server type.
| Option | Description |
|---|---|
| Enter new views database information | Views Data Source Name specifies the data source name. DecisionViews is the CPM Workstation default. You cannot reuse an existing data source name with this utility. Database Server Type lists the supported platforms. The connection information depends on the selected platform. |
| Microsoft SQL Server options | Database Server Name specifies the name of
the server computer on which the Microsoft SQL Server software is installed. If
a SQL instance is used, it must be appended to the name. For example,
MyServerName\SQL2019. Views Database Name specifies the name for the views database. Views Database Owner ID specifies the name of the database owner. Views Database Owner Password specifies the password for the database owner. See Password restrictions. Database Directory Location specifies the directory in which to create the database. Click Default to use the default directory for Microsoft SQL Server Management Studio. This is located in Program Files\Microsoft SQL Server\MSSQL.MSSQLSERVER\MSSQL\DATA. This directory varies with different versions of Microsoft SQL Server. |
| Oracle options | Views Database Name specifies the name for
the views database.
Database Owner ID specifies the name of the database owner. Database Owner Password specifies the password for the database owner. See Password restrictions. TNS Service specifies the TNS name. Or Host specifies the name of the host computer on which the Oracle software is installed. Port specifies the port number. Service Name specifies the name of the Oracle service. |
| Enter Database Creation Credentials | Database Administrator User ID specifies the name of the database administrator. Database Administrator Password specifies the password for the database administrator. |
| Optional. The connection is automatically tested when you click Test Connection Create Views Database. | |
| Create Views Database | Creates the views database. |
| Create SQL Script | Creates two scripts that can be run outside of the Views utility. The database name_ViewInitialize_database type.sql script is run first, followed by the database name_ViewDefine_database type.sql script. See "Database scripts" for further information. |
| Exit | Returns to the main menu of the utility. |