clsSendSQLToTenantDB Step

Last published at: January 3rd, 2023

Description:

Send SQL statement to tenant database.

Inputs

  • Tnconnection – Tenant manager connection string
  • Tnnameid – Tenant/Host Name or ID
  • Lstsqlstring – List of SQL string

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 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