Using Business Process Designer to Create Business Rules

Business Rules, created between the business process Activities, allow you to configure the relationships between the input and output Attributes of the Activities using the Business Process Designer's Business Rule Designer.

This section walks you through creating the project's five business processes:

Creating the bpDelete Business Rules
Creating the bpInsert Business Rules
Creating the bpPsSelect Business Rules
Creating the bpTableSelect Business Rules
Creating the bpUpdate Business Rules

Creating the bpDelete Business Rules

The bpDelete business process describes how to delete a record in the SQL Server database using the Business Process Designer.

Create the bpDelete Business Rules

Double-click bpDelete in the Projects window to open the Business Process Designer to the bpDelete business process.
Create the bpDelete FileClient.receive -> FileClient.write rule.
1. Right-click the link between FileClient.receive and FileClient.write and select Add Business Rule.
  A Business Rule icon is add to the link.
2. Double-click the Business Rule icon.
  The Business Rule Designer opens to the new Business Rule.
3. From the Business Rule Designer toolbar String menu, select string literal.
  A string literal method box is added to the Business Rule Designer canvas.
4. Double-click the string literal method box value field, and enter Deleting record... as the value.
5. Map the Deleting record... output node of the string literal method box to text under FileClient.write.Input in the Input pane (right pane) of the Business Rule Designer. To do this, click on the Deleting record... output node of the string literal method box, and drag your cursor to the text node under FileClient.write.Input in the Input pane of the Business Rule Designer.
Create the bpDelete FileClient.write -> otdSQLServer.Db_employeeDelete rule.
1. Add a Business Rule to the link between FileClient.write and otdSQLServer.Db_employeeDelete and double-click the new Business Rule icon.
  The Business Rule Designer opens to the new Business Rule.
2. Map text under FileClient.receive.Output in the Output pane of the Business Rule Designer to whereClause under otdSQLServer.Db_employeeDelete.Input -> input in the Input pane of the Business Rule Designer.
  A visible link now connects the two nodes in the Business Rule Designer.
Create the otdSQLServer.Db_employeeDelete -> bpDelete FileClient.write rule.
1. Add a Business Rule to the link between otdSQLServer.Db_employeeDelete and bpDelete FileClient.write and double-click the new Business Rule icon.
  The Business Rule Designer opens to the new Business Rule.
2. From the Business Rule Designer toolbar String menu, select string literal.
  A string literal method box is added to the Business Rule Designer canvas.
3. Double-click the string literal method box value field, and enter Delete done.. as the value.
4. Map the Delete done.. output node of the string literal method box to text under FileClient.write.Input1 in the Input pane of the Business Rule Designer.
Save your project.

Creating the bpInsert Business Rules

The bpInsert business process implements the Input Operation to read the TriggerInsert.in. file. It then unmarshals data from the input data into the otdInputDTD_DBEmployees OTD, calls the otdSQLServer, and inserts records into the database, and writes a message to confirm an inserted record.

Create the bpInsert Business Rules

Double-click bpInsert in the Projects window to open the Business Process Designer to the bpInsert business process.
Create the bpInsert FileClient.receive -> FileClient.write rule.
1. Add a Business Rule to the link between FileClient.receive and FileClient.write and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer toolbar String menu, select string literal.
3. Enter Inserting records into db_employee table.. as the String value in the string literal method box.
4. Map the Inserting records into db_employee table.. output node of the string literal method box to text under FileClient.write.input in the Input pane (right pane) of the Business Rule Designer.
Create the bpInsert FileClient.write -> otdInputDTD_DB_employee.unmarshal rule.
1. Add a Business Rule to the link between FileClient.write and otdInputDTD_DB_employee.unmarshal and double-click the new Business Rule icon.
  The Business Rule Designer opens to the new Business Rule.
2. Map text under FileClient.receive.Output in the Output pane of the Business Rule Designer to contents under otdInputDTD_DB_employee.unmarshal.Input in the Input pane of the Business Rule Designer.
Create the otdInputDTD_DB_employee.unmarshal -> Insert (Scope) element rule.
1. Add a Business Rule to the link between otdInputDTD_DB_employee.unmarshal and the Insert (Scope) element and double-click the new Business Rule icon.
  The Business Rule Designer opens to the new Business Rule.
2. From the Business Rule Designer toolbar Nodes menu, select count.
  A count method box is added to the Business Rule Designer canvas.
3. Map the X_sequence_A node under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee in the Output pane of the Business Rule Designer to the node-set1 input node of the count method box.
4. Map the return number output node of the count method box to value under Total_count in the Input pane of the Business Rule Designer.
5. From the Business Rule Designer toolbar Number menu, select number literal.
  A number literal method box is added to the Business Rule Designer canvas.
6. Double-click the number literal method box value field, and enter 1.0 as the value.
7. Map the 1.0 output node of the number literal method box to value under Index_count in the Input pane of the Business Rule Designer.
Create the X_sequence_A[number(getContainerData('Index_count'.'value'.'/value'))] predicate for the DTD.
1. Right-click otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> x_sequence_A, and select New Predicate from the popup menu.
  The Predicate window appears
2. From the Predicate window's Number menu, select number.
  A number method box is added to the Predicate window canvas.
3. Map value under Index_count in the Business Process Attributes pane of the Predicate window to the object1? input node of the number method box.
4. Map the Return Number output node of the number method box to Result in the right pane of the Predicate window.
5. Click OK.
  The X_sequence_A[number(getContainerData('Index_count'.'value'.'/value'))] predicate is added to the Output pane of the Business Rule Designer under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee.
Create the While -> otdSQLServer.DB_EMPLOYEEInsert rule.
1. Add a Business Rule to the link between While input node and the otdSQLServer.DB_EMPLOYEEInsert and double-click the new Business Rule icon.
2. From the Business Rule Designer toolbar Number menu, select Settings.
  The Method Palette appears.
3. From the Method Palette, click the Number tab and select the number option. Click Close.
  The number option is added to the Number menu.
4. From the Business Rule Designer toolbar Number menu, select number.
  A number method box is added to the canvas.
5. Map EmpNo under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> X_sequence_A[number(getContainerData(´‘Index_count'.‘value'.‘/value'))] in the Output pane of the Business Rule Designer to the object1? input node of the number method box.
6. Map the return number output node of the number method box to EMP_NO under otdSQLServer.DB_EMPLOYEEInsert.Input -> input in the Input pane of the Business Rule Designer.
7. From the Business Rule Designer toolbar Number menu, select number to add another number method box.
8. Map Rate under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> X_sequence_A[number(getContainerData(´‘Index_count'.‘value'.‘/value'))] in the Output pane of the Business Rule Designer to the object1? input node of the number method box.
9. Map the return number output node of the number method box to RATE under otdSQLServer.DB_EMPLOYEEInsert.Input -> input in the Input pane of the Business Rule Designer.
10. Map Lastname under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> X_sequence_A[number(getContainerData(´‘Index_count'.‘value'.‘/value'))] in the Output pane of the Business Rule Designer to LAST_NAME under otdSQLServer.DB_EMPLOYEEInsert.Input -> input in the Input pane of the Business Rule Designer.
11. Map Firstname under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> X_sequence_A[number(getContainerData(´‘Index_count'.‘value'.‘/value'))] in the Output pane of the Business Rule Designer to FIRST_NAME under otdSQLServer.DB_EMPLOYEEInsert.Input -> input in the Input pane of the Business Rule Designer.
12. Map LastDate under otdInputDTD_DB_employee.unmarshal.Output -> DB_employee -> X_sequence_A[number(getContainerData(´‘Index_count'.‘value'.‘/value'))] in the Output pane of the Business Rule Designer to LAST_UPDATE under otdSQLServer.DB_EMPLOYEEInsert.Input -> input in the Input pane of the Business Rule Designer.
Create the otdSQLServer.DB_EMPLOYEEInsert -> While rule.
1. Add a Business Rule to the link between the otdSQLServer.DB_EMPLOYEEInsert activity and the While output node and double-click the new Business Rule icon.
2. From the Business Rule Designer toolbar Operator menu, select addition.
  A addition method box is added to the canvas.
3. Map value under Index_count in the Output pane of the Business Rule Designer to the number1 input node of the addition method box.
4. Double-click the number2 field of the addition method box and enter a value of 1.0
5. Map the return number output node of the addition method box to value under Index-count in the Input pane of the Business Rule Designer.
Create the Insert -> FileClient.write rule.
1. Add a Business Rule to the link between the Insert output node and FileClient.write and double-click the new Business Rule icon.
2. From the Business Rule Designer toolbar String menu, select string literal.
3. Enter Insert Done as the String value.
4. Map the Insert Done output node of the string literal method box to text under FileClient.write.Input1 in the Input pane of the Business Rule Designer.

Creating the bpPsSelect Business Rules

The bpPsSelect business process describes how to use a Prepared Statement query to select all records in the SQL Server database via the Business Process Designer.

Create the bpPsSelect Business Rules

Double-click bpPsSelect in the Projects window to open the Business Process Designer to the bpPsSelect business process.
Create the bpPsSelect FileClient.receive -> FileClient.write rule.
1. Add a Business Rule to the link between FileClient.receive and FileClient.write and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer toolbar String menu, select string literal.
3. Enter Selecting record(s) from db_employee table via Prepared Statement select... as the String value in the string literal method box.
4. Map the Selecting record(s) from db_employee table via Prepared Statement select... output node of the string literal method box to text under FileClient.write.input in the Input pane (right pane) of the Business Rule Designer.
Create the FileClient.write -> otdSQLServer.Select_psPSSelectAll rule.
1. Add a Business Rule to the link between FileClient.write and otdSQLServer.Select_psPSSelectAll and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer toolbar Number menu, select number literal.
3. Enter 0.0 as the number value.
4. Map the 0.0 output node of the number literal method box to EMP_NO under otdSQLServer.Select_psPSSelectAll.Input -> input in the Input pane of the Business Rule Designer.
Create the Records found -> otdInputDTD_DBemployees.marshal rule in Case 1 of the Decision branching activity.
1. Add a Business Rule to the link between the Records found input node and otdInputDTD_DBemployees.marshal and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer String menu, select String.
  If String is not available from the String menu, click Settings on the String menu to open the Method Palette, and select String as an option from the String tab. This will add String to the String menu
3. Map EMP_NO under otdSQLServer.Select_psPSSelectAll.Output -> output -> Select_psPSSelectAllPSResponseTypeList in the Output pane of the Business Rule Designer to the object1? input node of the String method box.
4. Map the return string output node of the String method box to EmpNo under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer
5. From the Business Rule Designer String menu, select String to add another String method box.
6. Map RATE under otdSQLServer.Select_psPSSelectAll.Output -> output -> Select_psPSSelectAllPSResponseTypeList in the Output pane of the Business Rule Designer to the object1? input node of the String method box.
7. Map the return string output node of the String method box to Rate under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer
8. Map the nodes in the Output pane of the Business Rule Designer to their corresponding nodes under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane, as follows:
  - LAST_NAME -> Lastname
  - FIRST_NAME -> Firstname
  - LAST_UPDATE -> LastDate
Create the otdInputDTD_DBemployees.marshal -> FileClient.write rule in Case 1 of the Decision branching activity.
1. Add a Business Rule to the link between otdInputDTD_DBemployees.marshaland FileClient.write within the Records found element, and double-click the new Business Rule icon to open the Business Rule Designer.
2. Map contents under otdInputDTD_DBemployee.marshal.Output, in the Output pane of the Business Rule Designer to text under FileClient.write.Input3 in the Input pane of the Business Rule Designer.
Create the Norecord -> FileClient.write rule in Case 2 of the Decision branching activity.
1. Add a Business Rule to the link between No record input node and FileClient.write within the Records found element, and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer toolbar String menu, select string literal.
3. Enter Records Not Found as the String value in the string literal method box.
4. Map the Records Not Found output node of the string literal method box to text under FileClient.write.Input2 in the Input pane (right pane) of the Business Rule Designer.
Create the Decision Gate Properties for the Decision Case 1 and Case 2.
1. Double-click the red Case 1 icon between Decision input node and Records found input node.
  The Decision Gate Properties Editor appears.
2. From the Decision Gate Properties Editor toolbar Operator menu, select Settings.
  The Method Palette appears.
3. From the Method Palette, click the Operator tab and select the greater than option (for Case 1) and select the lesser or equal option (for case 2). Click Close.
  The new options are added to the Operator menu.
4. From the Decision Gate Properties Editor toolbar Operator menu, select greater than.
  The greater than method box is added to the editor's canvas.
5. Map rowCount under otdSQLServer.Select_psPSSelectAll.Output -> output in the left pane of the Decision Gate Properties Editor to the number1 input node of the greater than method box.
6. Double-click the number2 field of the greater than method box, and change the value to 0.0.
7. Map 00 output node of the greater than method box to the Result node in the right pane of the Decision Gate Properties Editor.
8. From the Order of Execution field, select Case 2.
9. From the Decision Gate Properties Editor toolbar Operator menu, select lessor or equal.
  The lessor or equal method box is added to the editor's canvas.
10. Map rowCount under otdSQLServer.Select_psPSSelectAll.Output -> output in the left pane of the Decision Gate Properties Editor to the number1 input node of the lessor or equal method box.
11. Double-click the number2 field of the lessor or equal method box, and change the value to 0.0.
12. Map 00 output node of the lessor or equal method box to the Result node in the right pane of the Decision Gate Properties Editor.
13. Click OK to close the Decision Gate Properties Editor.
  The Case 1 and 2 icons change from red to green to indicate that the properties have been set.
Create the Decision.end -> FileClient.write rule.
1. Add a Business Rule to the link between the Decision.end element and FileClient.write, and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer toolbar String menu, select string literal.
3. Enter Select Done as the String value in the string literal method box.
4. Map the Select Done output node of the string literal method box to text under FileClient.write.Input3 in the Input pane of the Business Rule Designer.
Save your project.

Creating the bpTableSelect Business Rules

The bpTableSelect business process describes how to select all records the SQL database using the Business Process Designer.

Note - The where clause in the business rule reads the trigger value as a placeholder for input. This permits you to modify the query to select a specific record. Also note that all records are selected from the database when the TriggerTableSelect.in file is empty.

Create the bpTableSelect Business Rules

Double-click bpTableSelect in the Projects window to open the Business Process Designer to the bpTableSelect business process.
Create the bpTableSelect FileClient.receive -> FileClient.write rule.
1. Add a Business Rule to the link between FileClient.receive and FileClient.write and double-click the new Business Rule icon to open the Business Rule Designer.
2. Create a string literal and enter Selecting record(s) from db_employee table via table select... as the String value.
3. Map the Selecting record(s) from db_employee table via table select... output node of the string literal method box to text under FileClient.write.input in the Input pane (right pane) of the Business Rule Designer.
Create the FileClient.write -> otdSQLServer.DB_EMPLOYEESelectAll rule.
1. Add a Business Rule to the link between FileClient.write and otdSQLServer.DB_EMPLOYEESelectAll and double-click the new Business Rule icon to open the Business Rule Designer.
2. Map text under FileClient.receive.Output in the Output pane of the Business Rule Designer to the whereClause under otdSQLServer.DB_EMPLOYEESelectAll.Input in the Input pane.
Create the otdSQLServer.DB_EMPLOYEESelectAll -> otdInputDTD_DBemployees.marshal rule.
1. Add a Business Rule to the link between otdSQLServer.DB_EMPLOYEESelectAll and otdInputDTD_DBemployees.marshal and double-click the new Business Rule icon to open the Business Rule Designer.
2. From the Business Rule Designer String menu, select String.
  If String is not available from the String menu, click Settings on the String menu to open the Method Palette, and select String as an option from the String tab. This will add String to the String menu
3. Map EMP_NO under otdSQLServer.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer to the object1? input node of the String method box.
4. Map the return string output node of the String method box to EmpNo under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer
5. From the Business Rule Designer String menu, select String to add another String method box.
6. Map RATE under otdSQLServer.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer to the object1? input node of the String method box.
7. Map the return string output node of the String method box to Rate under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer
8. Map nodes under otdSQLServer.Select_psPSSelectAll.Output -> output -> DB_EMPLOYEESelectAllTableResponseTypeList in the Output pane of the Business Rule Designer to the corresponding nodes under otdInputDTD_DBemployees.marshal.Input -> DBemployees -> X_sequence_A in the Input pane of the Business Rule Designer, as follows:
  - LAST_NAME -> Lastname
  - FIRST_NAME -> Firstname
  - LAST_UPDATE -> LastDate
Create the otdInputDTD_DBemployees.marshal -> FileClient.write rule.
1. Add a Business Rule to the link between otdInputDTD_DBemployees.marshal and FileClient.write, and double-click the new Business Rule icon to open the Business Rule Designer.
2. Map text under otdInputDTD_DBemployees.marshal.Output in the Output pane of the Business Rule Designer to text under FileClient.write.Input1 in the Input pane.
Create the FileClient.write -> FileClient.write rule.
1. Add a Business Rule to the link between FileClient.write element and FileClient.write, and double-click the new Business Rule icon to open the Business Rule Designer.
2. Create a string literal and enter TableSelect Done... as the String value.
3. Map the TableSelect Done... output node of the string literal method box to text under FileClient.write.input2 in the Input pane (right pane) of the Business Rule Designer.

Creating the bpUpdate Business Rules

The bpTableSelect business process describes how to select all records the SQL Server database using the Business Process Designer.

Create the bpUpdate Business Rules

Double-click bpUpdate in the Projects window to open the Business Process Designer to the bpUpdate business process.
Create the bpUpdate FileClient.receive -> FileClient.write rule.
1. Add a Business Rule to the link between FileClient.receive and FileClient.write and double-click the new Business Rule icon to open the Business Rule Designer.
2. Create a string literal and enter Update the Rate and Last_update fields... as the String value.
3. Map the Update the Rate and Last_update fields... output node of the string literal method box to text under FileClient.write.input in the Input pane (right pane) of the Business Rule Designer.
Create the FileClient.write -> otdSQLServer.DB_EMPLOYEEUpdate rule.
1. Add a Business Rule to the link between FileClient.write and otdSQLServer.DB_EMPLOYEEUpdate and double-click the new Business Rule icon to open the Business Rule Designer.
2. Create a string literal and enter today's date as the String value.
3. Map the today's date output node of the string literal method box to LAST_UPDATE under otdSQLServer.DB_EMPLOYEEUpdate.Input -> insert in the Input pane (right pane) of the Business Rule Designer.
4. Create another string literal and enter 888as the String value.
5. Map the 888 output node of the string literal method box to RATE under otdSQLServer.DB_EMPLOYEEUpdate.Input -> insert in the Input pane (right pane) of the Business Rule Designer.
6. Map the text under FileClient.receive.Output1 in the Output pane of the Business Rule Designer to whereClause under otdSQLServer.DB_EMPLOYEEUpdate.Input -> insert in the Input pane (right pane) of the Business Rule Designer.
Create the otdSQLServer.DB_EMPLOYEEUpdate -> FileClient.write rule.
1. Create a string literal and enter Update Done as the String value.
2. Map the Update Done output node of the string literal method box to text under FileClient.write.Input1 in the Input pane of the Business Rule Designer.
Save your Project.

Next Steps

For your next step, see Creating the Connectivity Maps .

Skip Navigation Links
Exit Print View
	Oracle Java CAPS Adapter for SQL Server Tutorials Java CAPS Documentation