SQL Configuration with Dynamic Query

Owned by Pooja Yadav (Deactivated), created
Last updated: Mar 10, 2022 by shreedutta.mukherjee (Deactivated)
2 min read

 

Introduction

In this section of our documentation, the steps to configuring dynamic queries will be described.

 

Steps to configure

  1. Drag and drop the SQL task in the automation and click on it. The form below will appear on the right side of the screen.

  2. Add name and an appropriate description for reference.

  3. Select the connection that has been created for the SQL or create a new one from the plus button. Click here : to know how to create an SQL connection.

  4. Choose the type of query according to the action the user is going to perform. You can choose from the following query types:
    • Select : A Select statement retrieves zero or more rows from one or more database tables or database views.
    • Insert : The SQL Insert statement is used to add new rows of data to a table in the database.
    • Update: The use of update SQL queries in access databases is to add, change, or delete the information in an existing record.
    • Delete : The SQL Delete query is used to delete the existing records from a table. You can use the WHERE clause with a DELETE query to delete the selected rows, otherwise, all the records would be deleted.

  5. After selecting the query type, the user needs to add the desired query in the input field. For a dynamic query, you should use a colon before each parameter.

  6. Add the desired query as per the data and click on the tick button to verify the query. A query is a request for data or information from a database table or combination of tables.

  7. If the query is successfully verified, Key-value input fields will appear on the screen.
    These input fields are created according to the parameters present in the query. The value input field should be fed with the file name according to the Key.
    For example, For the IFSC key drag and drop the file named as IFSC code in the value input field from the data slot, do the same for other key-value pairs.

  8. Click on save to successfully save the configuration.