Generic SQL
Use the Generic SQL integration to run SQL queries on the following databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Teradata and Trino.
- Category
- Database
- Pack
- 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
- incidentFetchInterval — Incidents Fetch Interval
Commands (3)
- pgsql-query — Runs a SQL query. Deprecated. Use the generic sql-command instead.
- query — Runs a SQL query. Deprecated. Use the generic sql-command instead.
- sql-command — Running a sql query.