Introduction: You can find a description of this phase in section Phase 2 (Introduction). See especially subsection When Does the Parser Start a New Record?

The result of SQL Input Agents (Input Agent DB and Input Agent API with class DefaultSQLCron (SQLCron) or DefaultFileSQLCron (SQLCron)) is converted into the CSV format and then parsed by the CSV parser.

Structure Templates

In the Input Agent DB, you can directly generate a suitable source structure. For the API classes, you get this as described for the document type CSV.

The following section describes how to get a suitable target structure for writing into a database in phase 4. This is not necessary for writing into a database in phase 3.

Writing in Database in Phase 4

See section Phase 4 - SQL Execution (GUI).

Writing in Database in Phase 3

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).