Skip to main content
Version: ACE 5

SAP IQ Db

Overview​

SAP IQ DB step is used to access SAP IQ DB and run SQL queries against it.

Configuration​

Connection​

  • Host - hostname string to connect to database (the recommended way of usage would be to specify a global db host string and access it here through e.g. {{$env.DB_HOST}})
  • Port - port on which SAP IQ DB is accessible (the recommended way of usage would be to specify a global db port {{$env.DB_PORT}})
  • Database name - the database name to connect to
  • User Name - user name to access the Oracle Db, we recommend consuming it as workspace variable e.g. {{$env.DB_USER}})
  • Password - password for accessing the database, we recommend consuming it as workspace variable e.g. {{$env.DB_PASSWORD}})

Actions​

Actions allows creating SQL queries that need to be run when the step is executed.

  • SQL - SQL statement to execute on the database (e.g. SELECT id FROM users WHERE email = :email)
  • Target path - doc node on which to place the query results