Skip to main content

Database Input (Advanced)

1. Overview

Database input is an important predecessor operator (process starting point) in data flows. It provides the data foundation for the first stage (extraction) of the ETL process and prepares for subsequent ETL data processing.

Supports rapid integration of multi-source heterogeneous data (multi-path input), enabling users to easily integrate data from different data sources and different structures.

2. Operation Steps

  1. Drag the Input Dataset operator from the data flow operator area into the right canvas editing area.

  2. Click the database input operator and select data type and data account.

    |350

  3. Edit SQL data extraction. SQL scripts can reference time macro parameters, global parameters, and workflow parameters. For workflow parameter creation methods, see Workflow Parameters.

    Usage example:

  4. Configure preview rules and cache data rows for the input dataset as needed.

    |350