Configuring the P6 EPPM Database Connection on an Oracle Instance

Previous TopicNext TopicContents

Use the fields on the Reporting Database Configuration Utility - [ODS] configuration wizard to configure the ODS database.

  1. On the Welcome screen, click Next to begin.
  2. On the EPPM Reporting Database Connection screen:
    1. For the Database Type option, choose Oracle.
    2. In the Oracle Database Connection section:
      1. In the Host Name field, enter the server machine name or IP address where you installed the P6 EPPM database.
      2. In the Port Number field, enter or verify the port number for this database.

        The default for Oracle is 1521.

      3. Choose the Service Name or SID option. Enter the Service Name or SID.
    3. In the Reporting User section:
      1. In the Username field, enter or verify your P6 EPPM reporting database name (for example, PxRptUser).
      2. In the Password field, enter the password for the reporting database user.
  3. Click Next.

    When you click next, the wizard will test that the connection is valid. If the test fails, ensure you have entered all the information correctly and try again.

    Follow the steps in the Configuring the ODS Database Connection.

Related Topics

Configuring the Oracle ODS Database

Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database

Configuring the ODS Database Connection

Configuring ETL Settings for ODS

Finishing the Configuration Wizard for ODS

Finishing the ODS Database Configuration



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014