Run SQL Script

01-Run-SQL-Script-Object

The Run SQL Script task provides flexibility to write a SQL code within Centerprise and execute it as part of a workflow.

To use a Run SQL Script task, drag and drop the Run SQL Script task object onto the workflow designer. Configure the object by right-clicking on the object’s header and selecting Properties from the context menu.

02-Run-SQL-Script-Click

A Database Connection window opens as shown below. This is where we configure connection with the database.

03-Run-SQL-Script-DB-Conn

To connect to a database, click on the drop-down menu next to the Data Provider option and select a data provider from the list.

05-SQL-Script-DB-Conn-Options

To establish a connection to a data provider, fill in the credentials such as User Id, Password, Server Name, Database, and Schema.

The next screen is the Run Sql Properties screen.

In the SQL Statement box, enter the SQL code. This code will be executed by the Run SQL Script task.

04-Run-SQL-Script-Properties

Once you’ve added the SQL script, click OK to close the window.

This concludes the working of the Run SQL Script object in Astera Centerprise.