Check Database Connectivity

Estimated reading time: 1 minute

Before performing database operations with Flows,you may want to make a quick flow to check connectivity.


Create the flow

To check MSSQL database connectivity in Flows:

  1. In Flows, create an Inject node, a MSSQL node, and a debug node.

    This example uses Microsoft SQL server. To use a different database you can create the node corresponding to your system instead of the MSSQL node.

  2. Double-click the MSSQL node and enter a simple test query. This query will show the number of rows in a table:


    Make sure to replace FlowHPE with a table name in your database.

  3. Click to edit database connection settings. Enter your Server IP address, your database Username, and your database Password.

  4. Click Update to save the connection settings for use in any other flow you create. Click Save to save your flow.
  5. Click the button to the left of the inject node. The debug tab should display the query result.