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.

Prerequisites:

• Set up a database app in OT Link Platform Marketplace.
• Familiarity with SQL queries.

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:

   SELECT COUNT(id) FROM FlowHPE

   

   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.