Editing Data Source Connection Properties

You can edit the data source connection information.

Note:

All steps and substeps in the following procedure are optional. The tasks you complete depend on the information you want to modify.

  To edit the properties of a data source:

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

  2. Under Data Sources in the physical tree, right-click the data source to edit and select Properties.

  3. To change the data source connection name, enter a new name in Connection Name.

  4. To change the data source description, enter a new description in Connection Description.

  5. Complete the following tasks in the Parameters section of the dialog box as appropriate for the data source type.

    Relational sources:

    Note:

    You cannot change the database name.

    1. In Server Name, modify the name of server where the database resides.

      Note:

      If you change the server connection information, the new server must host a database of the same type, name, and table structure as the original database.

    2. Oracle users only: If you are connecting to an Oracle database, in the Oracle SID/Service Name group, enter the SID or Service Name for your Oracle instance.

    3. To modify the port number, ensure that the Default check box next to Port is cleared, and enter the new port number.

    4. Modify the User Name and Password for this database.

    5. Click Test Connection.

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

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

    6. Continue to step 6.

    Essbase Server connections:

    1. In Essbase Server, modify the name of computer where the Essbase Server resides.

    2. To modify the port number, ensure that the Default check box next to Port is cleared, and enter the new port number.

    3. Optional: If you are connecting to an Essbase Server cluster, select the Cluster check box.

      Note:

      Essbase Server clusters must be set up prior to creating an Essbase connection. See Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide and Oracle Hyperion Enterprise Performance Management System High Availability Guide for information on setting up clusters.

    4. Modify the User Name and Password for this instance of Essbase Server.

    5. Select a Data Encryption method:

      • No Encryption—The default mode for communication between Essbase Studio Server and an Essbase Server instance or cluster.

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

        SSL enables secure communication between Essbase Studio Server and Essbase.

        Note:

        If the Essbase Server is not configured to support SSL, then a connection cannot be established and an error message is displayed.

    6. Click Test Connection.

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

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

    7. Continue to step 6.

    Dimension Server sources:

    1. In Server Name, modify the name of computer where Performance Management Architect resides.

    2. To modify the port number, ensure that the Default check box next to Port is cleared, and enter the new port number.

    3. Modify the User Name and Password for this instance of Performance Management Architect.

    4. Continue to step 6.

    Text file sources:

    1. To modify the Location of the text file data source, click Browse.

    2. In the Text File Location dialog box, select the directory that contains the text file data source you want to access.

      Note:

      You can select only one directory per data source. Essbase Studio does not support text files from different subdirectories within the same directory.

    3. Review the files listed under Contents of selected directory to ensure that this is the text file data source you want to select.

    4. Continue to step 6.

  6. Click Apply, and then click OK.

  7. If you changed the data source name and want to view the updated data source name in the Source Navigator, right-click the data source connection name you just changed and select Refresh.

    The new name is displayed in the physical tree.