Entrar Agende uma Demo Agende uma Demo
Back To Templates
inicianteintegraçãoInício fácil

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

serviços financeirossugerido

Teste A/B

Descubra uma maneira simples de atribuir um grupo de teste para realizar testes A/B em suas decisões.

Explore
serviços financeirossugerido

Precificação baseada em risco

Descubra uma maneira simples de aplicar uma matriz de precificação baseada em risco adequada ao tipo de cliente.

Explore
serviços financeirossugerido

Critérios de Elegibilidade e Regras da Política

Descubra uma maneira simples de definir e executar vários conjuntos de regras e obter o resultado da decisão final.

Explore