Generic SQL

Use the Generic SQL integration to run SQL queries on the following databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Teradata and Trino.

Database · GenericSQL

Configuration parameters

  • dialect — SQL DB (required)
  • host — Database host (required)
  • port — Port
  • credentials — Username (required)
  • fetch_parameters — Fetch by
  • query — Fetch events query
  • column_name — Fetch Column
  • id_column — ID Column name - in case of fetching by 'ID and timestamp'
  • isFetch — Fetch incidents
  • incident_name — Incident Name
  • dbname — Database Name
  • connect_parameters — Connection Arguments (ex: arg1=val1&arg2=val2)
  • max_fetch — Fetch Limit (Default / Max - 50, Recommended less than 50)
  • first_fetch — First fetch timestamp or First fetch ID
  • ssl_connect — Use an SSL connection
  • use_pool — Use Connection Pooling
  • insecure — Trust any certificate (not secure)
  • use_ldap — Use LDAP (Teradata only)
  • pool_ttl — Connection Pool Time to Live (seconds)
  • incidentType — Incident type

Commands (3)

  • pgsql-query Deprecated

    Runs a SQL query. Deprecated. Use the generic sql-command instead.

  • query Deprecated

    Runs a SQL query. Deprecated. Use the generic sql-command instead.

  • sql-command

    Running a sql query.