Data Requester: MSSQLDataRequester Project

The MSSQLDataRequester project contains three processes demonstrating remote procedure call mode and the request reply mode. They also demonstrate SQL batch execute and SQL execute operations.

The processes in this project are:
  • RequestReply
  • RPC_SQLBATCHEXECUTE
  • RPC_SQLEXECUTE

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 has been selected.

RequestReply Process

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

RPC_SQLBATCHEXECUTE Process

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

RPC_SQLEXECUTE Process

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