SQL Client

Owned by Pooja Yadav (Unlicensed), created
Last updated: Feb 28, 2022 by Ketaki joshi
2 min read

 

SQL stands for “structured query language”. It is a standard language for storing, manipulating, retrieving data from the database. You can interact with the database and perform actions on data.

The SQL task lets you connect to your databases and allows them to access and manipulate the databases using SQL connections. We are supporting MySQL, Oracle, and Snowflake databases. 

Types of Queries

The following query types are supported for various actions in the database: 

  1. Select: Select query lets you fetch the data from the database, defined in the query and the selected SQL connection.
    A simple select query format can be defined as follows: 
    SELECT [Columns or *] FROM [table] Where [Condition]

  2.  Insert: Insert query lets you insert data into the database table mentioned in the query itself.
    Sapper’s SQL task allows you to insert either as a single row or in batches.
    For more details about batch processing, please refer to this link: https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/125075279

  3. Update: An update query helps you to update data in one or more rows in the database table with a set of data defined in the query. Update query determines rows to be updated by the condition mentioned in the where clause of the query. 

  4. Delete: Delete query allows you to delete one or more rows from the database table based on the condition defined in the where clause in the query. 

Storing Procedures

SQL provides some additional functionalities to process data into or from databases.
There are the following types of functionalities:

  1. Simple Query Execution 
    In simple query execution, then you can modify one query at a time. For example, you can add one employee and modify one employee at a time. For more details, please refer : https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/88375247

  2. Dynamic Query Execution 
    SQL task allows you to perform a query with dynamic values. Using dynamic query allows you can use data slots in the query and modify the database table based upon the received data from data slots. For more details, please refer to this link: https://sappersoftware.atlassian.net/wiki/spaces/SD/pages/125075270

  3. Batch Execution
    Batch processing is a unique feature of SQL tasks, It allows you to insert data into the database in one go. It executes the provided data or the batch with a single call to the database. 
    Related :

Data Slots

After you complete the configuration for the SQL task, a fixed set of data slots gets generated along with your defined data for further use in the automation.
Data slots of the SQL task are as below:

  • Records: Collection of connected data having varied names and data types.

  • Count: An aggregate function that returns the number of rows, returned by a query.