Database connectivity

In order to connect your database with HuLoop and use SQL queries in your script please follow the below steps:

Step 1: Select your Automation and go to (Settings > Automation Settings > Database Settings).

Step 2: Enter all the details correctly.

Once you are done with the details in database settings we are all set to communicate with database using HuLoop. These details will establish the connection between database and HuLoop.

Step 3: Now you have write SQL scripts that will fetch the data from the database.

In order to write the SQL queries, go to Menu > Data > Manage SQL Scripts.

Step 4: Enter SQL script name and write the query in the ‘SQL Script’ text area.

Step 5: Now in order to use this SQL script in your case, go to your case in which you want to use this query.

Use the syntax as shown below in the steps, where you want to use the data fetched from the database.

Syntax: ${__sql(My_Script_1)} Here, My_Script_1 is the name of SQL query defined in step 4.

Tabular view :

Card view :

Similarly, we can use the same procedure for fetching data from any database.