Defining Connection Parameters for Performance Management Architect Sources

  To define a connection to a Performance Management Architect data source:

  1. In the Source Navigator, select the Data Sources tab.

  2. Right-click Data Sources in the physical tree and select New, then Data Source.

  3. Enter a Connection Name.

  4. Optional: Enter a Description.

  5. In Data Source Type, select Dimension Server.

    Performance Management Architect is an example of a dimension server.

  6. Under Parameters, in Server Name, enter the name of computer where Performance Management Architect Dimension Server resides.

  7. Optional: To use a port number other than the default, clear the Default check box next to Port and enter the correct port number in the text box.

    If you are using the default port number, skip this step.

  8. Enter the User Name and Password for this Performance Management Architect Dimension Server instance.

  9. Select a Data Encryption method:

    • No Encryption—This is the default mode for communication between Essbase Studio Server and a Performance Management Architect Dimension Server.

    • SSL—If the Performance Management Architect Dimension Server instance to which you are connecting is configured for Secure Socket Layer protocol over TCP/IP (SSL), select this method.

      SSL allows for secure communication between Essbase Studio Server and Performance Management Architect Dimension Server.

      Note:

      If you select SSL, and Performance Management Architect Dimension Server is not configured to support SSL, then connection cannot be established and an error message is displayed.

  10. Click Test Connection.

    If the information you entered in the wizard is correct, a message is displayed confirming a successful connection.

    If you entered incorrect information in the wizard, a message is displayed explaining that invalid credentials were provided. Correct the errors and retest until the connection is successful.

  11. Click Next or Finish.

    Clicking Next takes you to the Create Metadata Elements page of the wizard, as described in Creating Metadata Elements for Performance Management Architect Sources.

    If you clicked Finish, you should be able to expand the data source name in the Source Navigator to view the dimensions and levels of this data source.