Using the Siebel Query Objects activity

Use the Siebel Query Objects activity to work with either Siebel Business Objects, Business Components, or Siebel Integration Objects.

Before you begin

Ensure that you have:

About this task

Use this task to query either a Business Component hierarchy or an Integration Object on the Siebel server. The call to this activity is a synchronous call where the input data is sent to the activity for processing and the response is sent back to the orchestration.

Procedure

  1. In an active orchestration, open the Activities tab and expand the Siebel folder contents.
  2. Drag the Query Objects activity icon onto the orchestration. The Siebel Query Objects Checklist is displayed.
  3. In the Checklist, click Summary.
  4. Review the contents of the Activity Name field, and make the required changes.
  5. In the Checklist, click Pick Endpoint.
  6. Click Browse and use the Project Explorer dialog box to select the relevant Siebel endpoint.
  7. Optional: You can create the endpoint by clicking New and specifying the required connection details. Click OK to save and use the endpoint for this configuration.
    Note: For more information, see Creating or editing a Siebel endpoint.
  8. To make required changes to the selected endpoint configuration, click Edit to access the options in a separate window. Any changes you make globally affects all uses of the endpoint in active orchestrations.
  9. In the Checklist, click Configure.
  10. Enter the repository name in the Repository Name text box. Repository name is populated with a default value, which represents the Siebel Repository. Enter the repository name if it is not same as the default value. All the metadata needed for discovering the objects are retrieved from this repository.
  11. Select one of the following objects for integration.

    To work with Business Object/Business Component:

    1. Select the Object Type as Business Object / Business Component.
    2. Click Browse to display the list of Business Objects.
    3. Use the Business Object Filter to filter the business objects during selection.
    4. Optional: Click Refresh to update the current object list from the Siebel server.
    5. Select a Business Object from the business object list and click Next.
    6. The list of business components for the selected business object is displayed. Select a business component and click Finish to generate schemas for the map input and map output.

      The Query activity retrieves the Siebel business component for the specified key in the map input. The following occurs during the Query activity:
      • The keys are set on the top-level business component to search for records. If the record is not found, an error message is logged, and the job fails. If the record is found, the simple attribute values are retrieved from the top-level business component and set to the map output.
        Note: A simple PickList attribute is retrieved differently from other simple attributes. The simple PickList attribute is retrieved by obtaining the value of the PickListKey from the child picklist component. To retrieve a child picklist component, the FieldName value must be used.
      • Child business components are retrieved based on the type of relationship they have with the parent business component.
      • Child PickList instances are retrieved.
      • If the child record is found with multi-value link and association, the attribute value is set to the parent.

    To work with Integration Object:

    1. For Siebel Integration Object, select the Object Type as Integration Object.
    2. Click Browse to display the list of integration objects.
    3. Use Integration Object Filter to filter the integration objects during selection.
    4. Optional: Click Refresh to update the current object list from the Siebel server.
    5. Select an integration object and click Finish to generate schemas for the map input and map output. During processing, the selected business service is executed and the output is sent back to the orchestration.
  12. In the Checklist, click Retry. Review the default settings and make the required changes. For more information, see Specifying Retry and Delivery Options for Siebel Activities.
  13. Select the Map Inputs in the Checklist. The XML Schemas generated from the selected object of the Query Objects activity are displayed as nodes under the request input parameter in the To Activity panel.
  14. Create a map between the orchestration variables and the input parameter of the activity.
    Note: Values must be provided at run time for any mandatory elements of the input structure. A value can be provided by specifying a default value for element or by linking the element with an input node. During run time if no value is provided for a mandatory element, the activity throws an exception, which is reported by the Web Management Console (WMC). If a value is not provided at run time for an optional input parameter, no exception is thrown during run time.
  15. Select the Map Outputs in the checklist. The XML Schema generated to hold the response of the activity is displayed as nodes under the response output parameter in the From Activity panel.
  16. Create a map between the output parameters and orchestration variables.

Results

You have configured the Siebel Query Objects activity.



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/Siebel_query_outactivity.html