In phase 3, SQL nodes can be created in the target structure. These nodes correspond to a table in a database. The fields below this node correspond to columns in this table. This allows all possible SQL operations to be executed and stored procedures to be called. You can have these nodes and fields automatically created by Lobster_data.

The SQL operations are then executed after the completed mapping (phase 3) in phase 4.

Database Access with Functions

Alternatively, you can access databases with functions in phase 3. See update (sql-stmt a, alias b, list c, ignore error d), for example (further links can be found there).

GUI: The configuration of this phase is described in section Phase 3/4 (GUI). See especially sections Attributes Target Structure and Phase 4 - SQL Execution (GUI).