Run SQL File

01-SQL-File-Object

The Run SQL File task runs the SQL code inside a file of .sql extension as part of a workflow.

To use a Run SQL File task, drag and drop the Run SQL File 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-SQL-File-Click

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

03-SQL-File-DB-Conn

Centerprise offers native connectivity to several databases and applications. 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.

04-SQL-File-DB-Conn-Options

To establish a connection to a data provider, fill in the credentials, which are User Id, Password, Server Name, Database, and Schema for SQL Server.

Next is the Run Sql File Properties window.

05-SQL-File-Properties

SQL File Path: Specify the path to the SQL file that you want to execute through this task.

Next is the Config Parameters screen. This is where users can set up variable parameters to indicate a run-time change for values in the list on the screen.

06-SQL-File-Config-Para

Click OK to close the window. You can now execute this task as part of the workflow.

This concludes the configuration and working of the Run SQL File workflow task in Astera Centerprise.