Entrar Agendar una demo Agendar una demo
Back To Templates
principianteintegraciónInicio fácil

PostgreSQL Connector (Single Row)

This template demonstrates how to integrate a PostgreSQL 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

PostgreSQL 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 PostgreSQL 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 (postgresql_single_row):
    • Function: Connects to the database using the connector alias conn-postgresql-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 postgresql_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 PostgreSQL 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-postgresql-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

servicios financierossugerido

Pruebas A/B

Descubra una forma sencilla de asignar un grupo de prueba para realizar pruebas A/B en sus decisiones.

Explore
servicios financierossugerido

Precios basados ​​en el riesgo

Descubra una forma sencilla de aplicar una matriz de precios basada en riesgo adecuada en función del tipo de cliente.

Explore
servicios financierossugerido

Normas de elegibilidad y política

Descubra una forma sencilla de definir y ejecutar varios conjuntos de reglas y obtener el resultado de la decisión final.

Explore