Database 🗃️

1. First you need to create connection with required database (MySQL, PostgerSQL, SQL Server, Oracle, MongoDB).

2. Set Parameters

   • Database Name (which you want to access)

   • Hostname

   • Port Number

   • Username

   • Password

3. Click on test connection which will create a connection to your Database.

   

• You can also edit and delete existing connection.

  
• Now you can write your query and get your required data.

  select * from newdata;

  select firstName from newdata where id = 1;

  select * from newdata where Country = "Germany";

Note : Data modification/updation queries are not supported.

• You can save, delete column and rows from your Query result table.

  
• Select a column, specify the number of rows you want to import, and click on import table, You will get all the data that you imported, and you can save the table or export the table as a CSV.

  
• Sample CSV file: Test Connection.csv

The data saved from the table can be further used for Parameterization