Setting up Interactive Portlets › Set up the CA Clarity PPM Web Service Connection to Xcelsius Visualizations

Set up the CA Clarity PPM Web Service Connection to Xcelsius Visualizations

Use these steps to set up CA Clarity PPM Web Service as the data source and to establish real-time data transfers between CA Clarity PPM and the Xcelsius visualization.

To set up CA Clarity PPM Web Services as the connection method

1. In CA Clarity PPM, create an NSQL query in Studio.
   • Write a SELECT statement to transfer CA Clarity PPM data to Xcelsius.
   • Add the SECURITY in the WHERE clause. You can include access rights information in NSQL statement to add advanced security to interactive portlets.

   Note: See the Studio Developer’s Guide for more information.

2. Navigate to CA Clarity PPM Web Services using the following URL and view the web Query WDSL associated with the query you created for your interactive portlet. Make note of the URL of the query.

   http://<servername:port>/niku/wsdl/
   

3. In Xcelsius, open the Data Manager and add a web service connection to establish a connection with CA Clarity PPM.

   See the Xcelsius documentation provided in the Xcelsius product download or refer to the following section in this guide for more information about the Data Manager: By Example: Interactive Portlet Using Web Services Connection Method.

   1. Complete the following fields:

      WSDL URL

      Defines the URL of the web service to import the URL.

      Method

      Defines the web service connection.

      Value: Query

      Web Service URL

      Defines the mapping for an output value of the web service to a cell in the embedded spreadsheet.

      Query Code

      Defines the mapping for an output value of the web service to a cell in the embedded spreadsheet.

      Records

      Defines the mapping for an output value of the web service to a cell in the embedded spreadsheet.

   2. Click the Usage tab and select Options to refresh the connection.
   3. Click the Advanced tab and define the mapping for SOAP header to a cell in the embedded spreadsheet.
   4. Create the following Flash variables. The names used to define these Flash variables are mapped to the interactive portlet as global and object parameters:
      • Session ID. Required to receive the Session ID of the CA Clarity PPM user accessing the Xcelsius visualization in CA Clarity PPM. This named Flash variable is mapped to the interactive portlet as the Clarity Session ID in SOAP Header global parameter.
      • (Optional) Web Service URL. Optional. Define if you want to use the same Xcelsius visualization as is on multiple CA Clarity PPM servers. This named Flash variable is mapped to the interactive portlet as the Clarity Web Service URL global parameter.
      • (Optional) Other CA Clarity PPM information, such as user name, user internal ID, or language. These named Flash variables are mapped to the interactive portlet as the Clarity User Name, Clarity User Internal ID, or Language global parameters, respectively.
      • (Optional) CA Clarity PPM object-related information to change the behavior based on where the interactive portlet is located in CA Clarity PPM. These named Flash variables are mapped to the interactive portlet as the object parameters that you create.

More Information:

CA Clarity PPM Web Service