Description:
Send SQL statement to tenant database.
Inputs
- Tnconnection – Select Tenant manager connection string
- Tnnameid – Tenant/Host Name or ID
- Lstsqlstring – List of SQL strings
Returns
- True – step executed successfully
- False – step failed to execute
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 "Settings" properties. Provide a name to the step. Select the connection string. Provide the Tenant Name or GUID value. Click on the button to provide the SQL string.
- Provide the SQL string and click on "Add Row" to include more. Click on "Save" to confirm the changes.
- Click on the "clsSendSQLtoTenantDB" step to configure its "Logging" properties (optional). Provide the description, log message and documentation info. Click on "Save" to confirm the changes.
- Save the process definition, create a new process instance and execute. The process step should execute the list of SQL strings in the TenantDB.