Database Unit

Database Unit

Overview


A Database Unit in a flow diagram interacts with a database as part of the workflow. It allows the process to perform structured operations such as reading, writing, updating, or deleting data.

What it does:
  1. Connects to a database system (SQL or NoSQL).
  2. Executes queries or commands to manipulate data.
  3. Returns results for use in subsequent steps.
How it works:
  1. Configuration:
    1. Database type (e.g., MySQL, PostgreSQL, Oracle, MongoDB).
    2. Connection details (host, port, username, password).
    3. Optional: Connection pooling, timeout settings.
  2. Action Selection:
    1. Read: Fetch data using SELECT or equivalent.
    2. Write: Insert or update records.
    3. Delete: Remove records.
    4. Execute Procedure: Call stored procedures or functions.
  3. Execution:
    1. Sends the query to the database.
    2. Receives the result set or status.
    3. Passes data to the next unit (e.g., Mapping Unit, Decision Unit).
  4. Error Handling:
    1. Handles connection failures, query errors, or timeouts.
    2. Can branch to error-handling logic.
Use Case:
  1. Document Workflow: Fetch metadata from a database before processing a document.
  2. Integration: Store API response data in a database.
  3. Reporting: Retrieve records for generating reports.
Visual Representation



    • Related Articles

    • Edit Database Unit

      Edit Database Unit

    • Edit Database Unit (Store Operations)

      Overview A Database Unit in a flow diagram interacts with a database as part of the workflow. It allows the process to perform structured operations such as reading, writing, updating, or deleting data. What it does: Connects to a database system ...

    • Mapping Unit

      Overview The Mapping Unit is an action unit in the Flow Editor/Designer that enables a flow to transform, map, and structure data between different formats or schemas during execution. What it does: Converts input data into the required output ...

    • Edit Mapping Unit

      Overview The Mapping Unit is an action unit in the Flow Editor/Designer that enables a flow to transform, map, and structure data between different formats or schemas during execution. What it does: Converts input data into the required output ...

    • Delegate Automation Unit

      Overview A delegate Automation Unit in a flow diagram represents a step where the workflow performs an automated action without manual intervention. It’s designed to execute predefined tasks using scripts, bots, or automation services. What it does: ...