category: Database
provider: Microsoft
commonfields:
  id: Generic SQL
  version: -1
sectionorder:
- Connect
- Collect
configuration:
- defaultvalue: MySQL
  display: SQL DB
  name: dialect
  options:
  - MySQL
  - PostgreSQL
  - Microsoft SQL Server
  - Microsoft SQL Server - MS ODBC Driver
  - Oracle
  - Trino
  - Teradata
  required: true
  type: 15
  section: Connect
- display: Database host
  name: host
  required: true
  type: 0
  section: Connect
- display: Port
  name: port
  type: 0
  required: false
  section: Connect
- display: Username
  name: credentials
  required: true
  type: 9
  section: Connect
- display: Fetch by
  name: fetch_parameters
  type: 15
  defaultvalue: ID and timestamp
  options:
  - Unique timestamp
  - Unique ascending ID
  - ID and timestamp
  required: false
  section: Collect
- display: Fetch events query
  name: query
  type: 0
  additionalinfo: The Generic SQL query/procedure.
  required: false
  section: Collect
- display: Fetch Column
  name: column_name
  type: 0
  additionalinfo: Enter the exact column's name to fetch (ID column or timestamp column).
  required: false
  section: Collect
- display: ID Column name - in case of fetching by 'ID and timestamp'
  name: id_column
  type: 0
  required: false
  section: Collect
- display: Fetch incidents
  name: isFetch
  type: 8
  required: false
  section: Collect
  supportedModules:
  - agentix
  - xsiam
- display: Incident Name
  additionalinfo: Enter the exact column's incident name (if empty - it's the Fetch Column).
  name: incident_name
  type: 0
  required: false
  section: Collect
- display: Database Name
  name: dbname
  type: 0
  required: false
  section: Connect
- display: 'Connection Arguments (ex: arg1=val1&arg2=val2)'
  name: connect_parameters
  type: 0
  required: false
  section: Connect
- defaultvalue: '50'
  display: Fetch Limit (Default / Max - 50, Recommended less than 50)
  name: max_fetch
  type: 0
  required: false
  section: Collect
  supportedModules:
  - agentix
  - xsiam
- display: First fetch timestamp or First fetch ID
  name: first_fetch
  type: 0
  section: Collect
  required: false
- display: Use an SSL connection
  name: ssl_connect
  type: 8
  required: false
  section: Connect
- display: Use Connection Pooling
  name: use_pool
  type: 8
  required: false
  section: Connect
- display: Trust any certificate (not secure)
  name: insecure
  type: 8
  required: false
  section: Connect
- display: Use LDAP (Teradata only)
  name: use_ldap
  type: 8
  required: false
  section: Connect
- display: Connection Pool Time to Live (seconds)
  name: pool_ttl
  type: 0
  required: false
  additionalinfo: After this time the connection pool will be refreshed
  defaultvalue: 600
  section: Connect
- display: Incident type
  name: incidentType
  type: 13
  required: false
  section: Collect
  supportedModules:
  - agentix
  - xsiam
- display: Incidents Fetch Interval
  name: incidentFetchInterval
  defaultvalue: '1'
  required: false
  type: 19
  section: Collect
  advanced: true
  supportedModules:
  - agentix
  - xsiam
description: 'Use the Generic SQL integration to run SQL queries on the following databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Teradata and Trino.'
display: Generic SQL
name: Generic SQL
script:
  commands:
  - arguments:
    - description: The SQL query to run.
      name: query
      required: true
    - defaultValue: '50'
      description: The maximum number of results to return.
      name: limit
    - defaultValue: '0'
      description: The offset at which to start the results. The default is 0.
      name: skip
    - description: 'A comma-separated list of names, for example: "foo","bar","alpha".'
      isArray: true
      name: bind_variables_names
    - description: 'A comma-separated list of value, for example: 7,"foo",3.'
      isArray: true
      name: bind_variables_values
    deprecated: true
    description: Runs a SQL query. Deprecated. Use the generic sql-command instead.
    name: pgsql-query
  - arguments:
    - description: The SQL query to run.
      name: query
      required: true
    - defaultValue: '50'
      description: The maximum number of results to return. The default is 50.
      name: limit
    - defaultValue: '0'
      description: The offset at which to start the results. The default is 0.
      name: skip
    - description: 'A comma-separated list of names, for example: "foo","bar","alpha".'
      isArray: true
      name: bind_variables_names
    - description: 'A comma-separated list of value, for example: 7,"foo",3.'
      isArray: true
      name: bind_variables_values
    deprecated: true
    description: Runs a SQL query. Deprecated. Use the generic sql-command instead.
    name: query
  - arguments:
    - description: The SQL query to run.
      name: query
      required: true
    - defaultValue: '50'
      description: The maximum number of results to return.
      name: limit
    - defaultValue: '0'
      description: The offset at which to start the results. The default is 0.
      name: skip
    - description: 'A comma-separated list of names, for example: "foo","bar","alpha".'
      isArray: true
      name: bind_variables_names
    - description: 'A comma-separated list of value, for example: 7,"foo",3.'
      isArray: true
      name: bind_variables_values
    description: Running a sql query.
    name: sql-command
  dockerimage: demisto/genericsql:1.2.0.10221838
  isfetch: true
  runonce: false
  script: '-'
  subtype: python3
  type: python
fromversion: 5.0.0
tests:
- generic-sql
- generic-sql-oracle
defaultclassifier: GenericSQL Classifier