Configuring Query, Insert, Update, and Delete Services
These services perform the following operations:
Service | Description |
Query | Retrieves business component records based on one or more fields. |
Insert | Inserts a business component record with values specified for one or more fields. |
Update | Updates business component records based on the value of one or more fields. You can specify that one or more record fields be updated. |
Delete | Deletes business component records based on the value of one or more fields. |
Note:
When creating a Query, Insert, Update, or Delete service, you can select a multi-valued link (MVL) to a child record. For more information, see
Multi-Valued Links in Services.
To configure a Query, Insert, Update, or Delete service
2. Start Digital Event Services or Designer.
Note:
Make sure the server with which you want to use Digital Event Services or Designer is running.
3. Perform one of the following:
If you are using
Digital Event Services, select
File > New > Adapter Service and click
Next.
If you are using
Designer, perform the following:
1. Right-click the package in which the service should be contained and select New > Adapter Service.
2. Select the parent namespace and type a name for the adapter service.
3. Click Next.
4. Select Siebel Adapter from the list of available adapter types. Click Next.
5. Select the appropriate Adapter Connection Name and click Next.
6. From the list of available templates, select the Query, Insert, Update, or Delete template as appropriate and do one of the following:
If you are using
Digital Event Services, click
Next, select a package and folder where the adapter service should be stored, and then click
Finish.
If you are using
Designer, click
Finish.
7. Type a unique name for the service and select the appropriate folder. Click Finish.
8. You can select the Adapter Settings tab at any time to confirm adapter properties such as adapter type, connection name, and service template, as needed.
9. Select the Navigation Path tab to specify the records that the service accesses, using the following fields:
Parameter | Description/Action |
Business Object | The name of the business object that contains the business component for which you are creating the service. |
Business Component | The name of the business component for which you are creating the service. |
Multi-Valued Links | Optional. Select a field of the business component to use as a multi-valued link (MVL) to a child record. For example, to query the primary business address of a particular Account, you might select the Account business component's field Company Name, which links to a business component named Business Address. This creates a query that navigates from the Account business component to the Business Address business component. For more information about multi-valued links, see
Multi-Valued Links in Services. |
Additional Business Component [1] | The parent business component of the business component you selected, if one exists. |
Additional Business Component [2] | The parent business component of the business component you selected in Additional Business Component [1], if one exists. |
10. Use the Search tab to define a search expression for the selected business component. To define a search expression, provide values for the fields on the top row of the tab. Also define search expressions for a multi-valued link and up to two additional business components, if you specified them.
a. Use the icon (or the icon) to create new rows as needed. b. Select a logical operator from the AND/OR field, an Operator, and separators (the left and right parentheses) as needed, and provide values for the following parameters:
Parameter | Description/Action |
AND/OR | A logical operator. |
Siebel Field | A search field of the selected business component. |
Siebel Field Data Type | The data type of Siebel Field. |
Operator | An operator for the search expression. Note: For case insensitive search, select ‘~='. For case sensitive search, select ‘='. |
Input Field | An input field of the adapter service. |
Input Field Data Type | The data type of Input Field. |
11. If you want to perform a Query service
a. Select the Output Mapping tab to map the selected Siebel fields to output fields of the adapter service.
b. Provide values for the following Output Mapping parameters:
Parameter | Description/Action |
Siebel Field | Select a Siebel field to use as output to the adapter service. |
Siebel Field Data Type | The data type of Siebel Field. |
Output Field | The field to map Siebel Field to. |
Output Field Type | The data type of Output Field. |
Sort Order | Select a sort order (Ascending or Descending). |
12. If you want to perform an Insert or Update service
a. Select the Input Mapping tab to map the adapter service's input fields to Siebel fields.
b. Provide values for the following Input Mapping parameters:
Parameter | Description/Action |
Siebel Field | Select a Siebel field to use as input to the adapter service. |
Siebel Field Data Type | The data type of Siebel Field. |
Input Field | The field to map Siebel Field to. |
Input Field Data Type | The data type of Output Field. |
Note:
When mapping input values for a Siebel field with a drop-down list, make sure you provide the predefined values provided in the drop-down list. For example, assume that the Status field provides the drop-down list values Open, Pending, and Closed. When you insert or update a record that contains the Status field, the Siebel application expects you to provide Open, Pending, or Closed. Otherwise, the adapter throws an exception.
13. For information about using the Input/Output, Settings, Audit, Permissions, and Results tabs, see the webMethods Service Development Help for your release.
Digital Event Services and Designer contain the Adapter Settings and Input/Output tabs. The information from the Audit and Permissions tabs now appears in the Properties panel, and the information from the Results tab now appears in the Results panel.
14. Select File > Save.
15. To run the adapter service directly from Digital Event Services or Designer at this time, perform the following steps:
a. If you are using Digital Event Services, set the view to the Test perspective.
b. In Digital Event Services or Designer, expand the package and folder that contain the service you want to test.
c. Double-click the service you want to test.
Digital Event Services or Designer displays the configured service in the service template's Adapter Service Editor.
d. Perform one of the following
If you are using
Digital Event Services, select
Test > Run.
If you are using
Designer, select
Run > Run As > Run Service.
e. To connect to the Siebel Server using credentials that are different than the credentials provided at design time, specify the username and password here:
Parameter | Description/Action |
user | The user name used to connect to the Siebel Server. |
password | The password used to connect to the Siebel Server. |
f. For every service input field, you will be prompted to enter an input value. Enter a value for each input field and then click OK.
g. Click the Results tab to view the output from this service.
The output for each service is as follows:
The output for this service ... | Is a ... |
Query | Document list field named Results. If the Query was successful, a document field (also named Results) displays the fields returned by the service. |
Update | String field named Rows Updated, which indicates the number of rows updated by the service. |
Insert | String field named Row ID, which indicates the row ID of the row inserted by the service. |
Delete | String field named Rows Deleted, which indicates the number of rows deleted by the service. |