Database Commands

It will remove junk data which are fetched from raw data sources by validating through a set of rules. Clean command can also be utilized in File Operations.

It allows users to extract the data from database by performing the Select Query. The result of the Select Query will be stored either in the Target Variable or Target Data table or Target file depending on user selection.

Click on icon in the Value column and mention DB Alias, Select Query & Target Selection details in the dialog box as shown below.

✔ DB Alias – The Alias of the database

✔ Select Query – The Select Query which needs to be executed in order to fetch data

✔ Single Result – Select Single Result to store output generated from the Select Query to targeted variable

✔ Result Set – Select Result Set to store output generated from the Select Query to Targeted data table

✔ File – Select File to store output generated from the Fetch command to a .csv file

✔ Target Variable – The name of the Variable which would store the output generated from the Select Query

✔ Target Data Table – The name of the Data table which would store the output generated from the Select Query

✔ Target File – The name of the File which would store the output generated from the Fetch command

✔ Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

This operation allows insert, update and delete operations and has auto-commit set to TRUE from tool's end.

After selecting the Query action, click on icon in the Value column and mention DB Alias and Query details in the dialog box as mentioned below.

✔ DB Alias – The Alias of the database

✔ Query – Enter the inquiry which needs to be executed

✔ Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

✔ Auto-commit – Mark this option to auto commit your results to your respective transaction. Note: This option would not work with MongoDB

It allows users to compare Query to Query, File to File as well as Query to File. The result of the Comparison will be stored in the Targeted Variable. Also, this command can be utilized in File Operations.

After selecting the Comparison action, click on icon in the Value column and mention Source 1&2, DB Alias, Query and Target Variable details in the dialog box as mentioned below.

✔ Source 1 – Select “Query” or “File” to compare

✔ Source 2 – Select “Query” or “File” to compare

✔ DB Alias – The Alias of the database

✔ Query – Enter the inquiry which needs to be executed

✔ Timeout (in milliseconds) – The user can specify database timeout period in milliseconds to control script behavior better

Execute Procedure

This operation relies on the user to commit/rollback as per his requirement.

Database Stored Procedure

Select Query

Unlike the fetch command, this command builds automated query from the items chosen. Giving user from non-coding background a hassle-free and controlled command of the database.

This allows user to directly interact with database and all the tables residing in it.

✔ BD Alias – Select the DB Alias from the configured Databases list.

✔ Table – All the tables will get populated in the dropdown based on the DB selected. Choose a table to fetch the data from.

✔ Column list – User can select the columns/fields from the selected table to fetch the data. User can also search through the list of columns/fields from the list.

✔ Query – This generates and displays the query built based on the data selected in above steps.