1. To Fetch Data from DB.

2. Click on the edit icon of required step, click on the Test Data source and choose From DB from the dropdown.

3. Write a query in the DB Query field.

Setup: Need to be an admin user
1. Admin page > Properties > Edit Customer Database Property

2. Select product and DB Type

3. Enter the db url – The DB needs to be accessible from the Nogrunt server (if your database is behind a firewall, most likley it will need network ports to be opened)

4. Enter Username and Password

5. Submit

Example :
Product – Nogrunt Kishore
DB Type – MySQL
DB Url – jdbc:mysql://localhost:3306/cta
Username – Deva
Password –

Query – Sample SQL Query – select productname from cta.products where idproducts = 1