Step: Query SQL Database

This step allows you to perform queries on any registered SQL graph database Data Sources (e.g., PostgreSQL or MySQL) for SELECT, UPDATE, DELETE, and INSERT queries.


Uses SQL Query syntax

  • Datasource: Choose the SQL Data Source the query will be sent to
  • Output Variable: The name of the package variable the results will be stored in. Results will be in a multi-dimensional array (table) and referenced in FreeMarker with double brackets (e.g. ${empinfo[0][1]}}
  • Query: The query you want to send in SQL syntax. Must start with one of the following keywords: SELECT, UPDATE, DELETE, INSERT
  • step/query-sql-database
  • Last modified: 2019/07/16 20:27