Description:
Send SQL statement to tenant database.
Usage:
Example:
Let’s build and execute the SendSQLToTenantDef example.
- Create a new definition called “SendSQLToTenantDef”
- Select the definition and click the “design” button
- Drag a "clsSendSQLtoTenantDB" step to the canvas
- Connect the dots between the start and "clsSendSQLtoTenantDB" step
- Click on the "clsSendSQLtoTenantDB" step to configure its properties
- Configure the following values for the properties as shown on the below graphic
- Save the process definition, create a new process instance and execute. The process step should execute the list of SQL strings in the TenantDB.
- List of SQL string