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.
  1. 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.
  2. 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.
  3. 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: ...