Adding a CPM Relational connection - Oracle

To add a CPM Relational connection for Oracle:

  1. On the Manage Data Sources page.
  2. Click New and select CPM Relational as the connection type.
  3. Specify a name for the data source. The name must be unique.
  4. Select Model as the category.
  5. To define the Relational Connection:
    1. Select Oracle.
    2. Specify the user name of the schema owner.
    3. Specify the password for the administrator user.
    4. Specify the name of the host computer on which the Oracle software is installed.
    5. Specify the name of the Oracle service.
    6. Specify the port number. The default is 1521.
    7. Select the database to connect to the data source. If necessary, click Refresh to update the list of available databases.
    8. Specify 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.
    9. Select the Oracle 64-bit home driver.
  6. To define the CPM Server Connection:
    1. Select the network protocol. You can choose http or https. The default is http.
    2. Specify the name of the server computer on which the CPM Server software installed. The server name specified here must match the server name specified in the ConnectionDefinitions.config file.
    3. Specify the port number of the server computer specified in the previous step. The default is 90.
  7. Optionally, you can change the Merged Period Year parameter. See "Changing the Merged Period Year parameter".
  8. Click Test Connection
  9. Click Save.