CPM Navigation Database Creation utility

The CPM Navigation Database Creation Utility page is used to create a navigation database. This page enables you to run the database creation process that:

  • Creates the database.
  • Creates the schema.
  • Creates a navigation data source to connect to the navigation database.
  • Adds the user's ID to the Navigation Administration security group.

This table shows the page options:

Option Description
Database Server Type Select the database server type. Choose from:
  • Microsoft SQL Server
  • Oracle
Database Server Name Microsoft SQL Server only. Specify the name of the server computer on which the SQL Server database software is installed. If a SQL instance is used, it must be appended to the name. For example, MyServerName\SQL2019.
Database Administrator User ID Specify the user ID of the database administrator or system administrator.
Database Administrator Password Specify the password for the database administrator or system administrator user ID.
TNS Service Connection Oracle only. Specify the name of the TNS Service.
Oracle Database Connection Oracle only. For Host, specify the name of the host computer on which the Oracle software is installed.

For Service Name, specify the Oracle service name.

For Port, specify the port number.

Data Source Name Specify the name for the navigation data source. The default is Navigation. If you specify a name other than Navigation, you must go to the Set Properties page and update the name specified for UnifiedNavigationConnectionName.
Navigation Database Name Specify the name for the navigation database.
Navigation Database Owner ID Specify the user ID of the navigation database owner.
Navigation Database Owner Password Specify the password for the navigation database owner. See Password restrictions.
Database Directory Location Microsoft SQL Server only. Specify a directory or select the check box 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.
Create Database Create the navigation database.
Create SQL Script Create the SQL scripts that can be run later. After the scripts are created, click Download to download the script to a location you select.

For Microsoft SQL Server, the scripts are named:

  • database name_CreateEmptyNavigationDatabase_SQLServer.sql
  • database name_CreateNavigationSchema_SQLServer.sql

For Oracle, the scripts are named:

  • database name_CreateEmptyNavigationDatabase_Oracle.sql
  • database name_CreateNavigationSchema_Oracle.sql

For example, if you specify CPMNavigation as the database name and SQL Server as the database type. The file names would be:

  • CPMNavigation_CreateEmptyNavigationDatabase_SQLServer.sql
  • CPMNavigation_CreateNavigationSchema_SQLServer.sql.

The first script creates an empty database and the navigation user. The second script creates the schema and must be executed as the navigation user.

Test Connection Test the database server connection.

Detail information

You are redirected to this page from the default navigation page if you do not have a navigation database.

Page: Create.aspx

Direct access: http://ServerName:Port/CPMNavigation/Create.aspx