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:
![](https://s3.amazonaws.com/helpjuice-static/helpjuice_production%2Fuploads%2Fupload%2Fimage%2F8802%2Fdirect%2F1617001786301-1617001786301.png)
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.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1687855085978-image.png)
- Provide the SQL string and click on "Add Row" to include more. Click on "Save" to confirm the changes.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1687855105804-image.png)
- 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.
![](https://static.helpjuice.com/helpjuice_production/uploads/upload/image/8802/direct/1687855145281-image.png)
- Save the process definition, create a new process instance and execute. The process step should execute the list of SQL strings in the TenantDB.