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 do the following:

• Set up CA Clarity PPM Web Service as the data source
• Establish real-time data transfers between CA Clarity PPM and the Xcelsius visualization

Follow these steps:

1. In CA Clarity PPM, create a query.
   • 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.
2. Complete the following steps:
   1. Navigate to CA Clarity PPM Web Services using the following URL.

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

   2. View the web query WDSL associated with the query you created for your interactive portlet.
   3. Make note of the URL of the query.
3. In Xcelsius, open the Data Manager and set up the web service to establish the connection with CA Clarity PPM.
   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

      Receives the Session ID of the CA Clarity PPM user.

      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.

      Mapped to: the interactive portlet as the Clarity Web Service URL global parameter.

      Other CA Clarity PPM information

      Optional. This can be information such as user name, user internal ID, or language.

      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

      Optional.

      Mapped to: the interactive portlet as the object parameters that you create.

More Information:

CA Clarity PPM Web Service