DataRequester: MSSQLDataRequester_CustomRPC Project

The MSSQLDataRequester_CustomRPC project contains four processes demonstrating remote procedure call mode using stored procedures and functions.

The processes in this project are:
  • Execute_procedure_EMPLOYEEDATA
  • Execute_procedure_GETPRICE
  • Execute_procedure_PARAMTEST
  • Execute_procedure_SETDESCRIPTION

JDBC Connection Resource

In this example, the JDBC Connection resource is configured as follows:

ADB Connection Resource

In this example, the ADB Configuration resource is configured as follows:

The Configuration tab is used to configure the schema. In the following figure, RPC mode with custom operations has been selected.

Execute_procedure_EMPLOYEEDATA Process

The following figure shows the General tab of the Execute_procedure_EMPLOYEEDATA process:

Execute_procedure_GETPRICE Process

The following figure shows the General tab of the Execute_procedure_GETPRICE process:

Execute_procedure_PARAMTEST Process

The following figure shows the General tab of the Execute_procedure_PARAMTEST process:

Execute_procedure_SETDESCRIPTION Process

The following figure shows the General tab of the Execute_procedure_SETDESCRIPTION process: