Login Demo buchen Demo buchen
Back To Templates
beginnerintegrationEasy Start

MSSQL Connector (Single Row)

This template demonstrates how to integrate a MSSQL Database as a live data source within a Decision Flow. It specifically shows how to use the DB Single Row node, how to pass variables to the SQL query, and how to fetch data from the database and propagate it into the flow’s output.

DecisionRules

David Škarka

Template author

MSSQL Connector (Single Row) 1
The primary objective of this flow is to show how to retrieve information from an external database using a single string input and return a corresponding result. 
It connects to a user-defined MSSQL infrastructure and executes a query against a standard single-row table.

Solution Components
The workflow is composed of several specialized nodes that handle the data lifecycle from input to final assignment:
  • DB Single Row Node (mssql_single_row):
    • Function: Connects to the database using the connector alias conn-mssql-templates.
    • Logic: Executes the SQL statement.

    • Constraint: This node is designed to return exactly one row. For multiple rows, use a standard database node instead.

  • Data Manipulation Node (assign):
    • Function: Extracts the result from the database node.
    • Logic: Maps the value found at mssql_single_row.row to the final output.

How to Use This Rule
To successfully utilize this template, the following steps must be completed:
  1. Prerequisite: Ensure your MSSQL DB instance is accessible from the DecisionRules backend (Cloud or On-Premise).
  2. Setup: Create a Database Connector in the Space settings with the specific alias conn-mssql-templates.
  3. More details could be found in the main flow description - in the Flow Designer, select in the Sidebar the Rule Settings  and scroll down to Description
Check iconA checkmark inside a circle signifying "yes"Minus iconA minus inside a circle signifying "no"PROS IconA plus symbol representing positive aspects or benefits.CONS IconA minus symbol representing negative aspects or drawbacks.

More Templates

See Other Templates

financial servicessuggested

A/B Testing

Discover a simple way to assign a test group for performing A/B Testing on your decisions.

Explore
financial servicessuggested

Risk Based Pricing

Discover a simple way to apply a suitable Risk Based Pricing matrix based on a type of client.

Explore
financial servicessuggested

Eligibility and Policy Rules

Discover a simple way to define and execute various sets of rules and get the final decision outcome.

Explore