Creating Static SQL Queries Using the Database Connector

Prerequisites

You need the metadata of your database, at least table and column names need to be known.

Refer to Querying Metadata

Proceed as follows

  1. Create a Technical Workflow containing a Database Connector.

  2. In the dialog Database Connection and query type in the Function area of the Database Connector, activate the option Execute static query.

    Refer to Dialog Database Connection and Query Type

  3. Click Next. The dialog Static SQL query is displayed.

    Refer to Dialog Static Query

  4. Enter the SQL query.

    Please note that the SQL query can only consist of standard requests (SELECT, INSERT, UPDATE, DELETE, CALL). Database-specific syntax is not supported.

  5. Click Next. The dialog Query result is displayed.

    Refer to Dialog Query Result

  6. Define how the query’s result should be output.

  7. Click Finish to close the wizard.

  8. Publish and activate the Technical Workflow.

The SQL query is sent to the database when the Database Connector is executed.

Press Esc to exit full screen
Modal image placeholder
Press Esc to exit full screen