Connecting to an Amazon Athena data source

Connect the Amazon Athena data source to IBM Security QRadar® Suite Software to enable your applications and dashboards to collect and analyze Amazon Athena security data. Universal Data Insights connectors enable federated search across your security products.

1. Log in to IBM Security QRadar Suite Software.
2. From the menu, click Connections > Data sources.
3. On the Integration data sources page, on the Amazon Athena tile, click Set up a connection.
4. On the Connection services page, select the Federated searches service tile, and then click Enable.
   The available connection services include:

   1. Connected assets & risk
   2. Federated searches

   Note: If there are multiple data sources to connect, select the connector from the Sources list, and then click Enable.
5. Click Next.
6. On the Connection details page, configure the following parameters.
   1. Configure the connection to the data source.

      Table 1. Connection parameters

      Parameter	Description
      Data source name	Enter a unique name to identify the data source connection. You can create multiple connections to a data source, so it is useful to clearly set them apart by name. Only alphanumeric characters and the following special characters are allowed: - . _
      Data source description	Enter a description to indicate the purpose of the data source connection. You can create multiple connections to a data source, so it is useful to clearly indicate the purpose of each connection by description. Only alphanumeric characters and the following special characters are allowed: - . _
      Edge gateway	If you have a firewall between your cluster and the data source target, use the Edge Gateway to host the containers. In the Edge gateway field, specify an Edge Gateway to host the connector. It can take up to five minutes for the status of newly deployed data source connections on the Edge Gateway to show as being connected.
      Region	Enter the Amazon Athena region for the data source. Select your region code from the Region column of the Service Endpoints table in the Amazon Athena endpoints and quotas (https://docs.aws.amazon.com/general/latest/gr/athena.html).
      Amazon S3 Bucket Location	Enter the location of the S3 bucket where query results will be stored.
      VPC Flow Logs database name (optional)	If you are using Amazon Athena with VPC flow logs, specify the name of the database that contains the VPC flow logs in the VPC Flow Logs database name (optional) field.
      VPC Flow Logs table name (optional)	If you are using Amazon Athena with VPC flow logs, specify the name of the table that contains the VPC flow logs in the VPC Flow Logs table name (optional) field.
      Amazon GuardDuty database name (optional)	If you are using Amazon Athena with Amazon GuardDuty, specify the name of the database that contains the Amazon GuardDuty logs in the Amazon GuardDuty database name (optional) field.
      Amazon GuardDuty table name (optional)	If you are using Amazon Athena with Amazon GuardDuty, specify the name of the table that contains the Amazon GuardDuty logs in the Amazon GuardDuty table name (optional) field.
      OCSF logs database name (optional)	If you are using Amazon Athena to query Amazon Security Lake logs, specify the name of the AWS Lake formation database that contains the security logs in the OCSF logs database name (optional) field.
      OCSF logs table name (optional)	If you are using Amazon Athena to query Amazon Security Lake logs, specify the name of the AWS Lake formation table that contains the security logs in the OCSF logs table name (optional) field.

   2. Set the query parameters to control the behavior of the federated search query on the data source.

      Table 2. Query parameters

      Query parameter	Description
      Concurrent search limit	Enter the number of simultaneous connections that can be made to the data source. The default limit for the number of connections is 4. The value must not be less than 1 and must not be greater than 100.
      Query search timeout limit	Enter the time limit in minutes for how long the query is run on the data source. The default time limit is 30. When the value is set to zero, no timeout occurs. The value must not be less than 1 and must not be greater than 120.
      Result size limit	Enter the maximum number of entries or objects that are returned by search query. The default result size limit is 10,000. The value must not be less than 1 and must not be greater than 500,000.
      Query time range	Enter the time range in minutes for the search, represented as the last X minutes. The default is 5 minutes. The value must not be less than 1 and must not be greater than 10,000.
      Custom mapping (Optional)	If you need to customize the STIX attributes mapping, click Customize attribute mapping and edit the JSON blob to map new or existing properties to their associated target data source fields.

      Important: If you increase the Concurrent search limit and the Result size limit, a greater amount of data can be sent to the data source, which increases the strain on the data source. Increasing the query time range also increases the amount of data.
   3. Click Next.
7. On the Connection configurations page, configure identity and access.
   1. Click Add a configuration.
   2. In the Configuration details window, configure the following parameters.

      Table 3. Configuration parameters

      Parameter	Description
      Configuration Name	Enter a unique name to describe the access configuration and distinguish it from the other access configurations for this data source connection that you might set up. Only alphanumeric characters and the following special characters are allowed: - . _
      Configuration Description	Enter a unique description to describe the access configuration and distinguish it from the other access configurations for this data source connection that you might set up. Only alphanumeric characters and the following special characters are allowed: - . _
      AWS Access key id	Establish AWS authentication to enable access to the AWS search API. To establish an AWS key-based authentication, enter values for the AWS Access key id and AWS secret access key parameters. To establish an AWS role-based authentication, enter values for the AWS Access key id, AWS secret access key, and AWS IAM Role parameters.
      AWS secret access key
      AWS IAM Role
      External ID for AWS Assume Role	To grant access to your AWS resources and establish an Assume Role authentication, enter a value for the External ID for AWS Assume Role parameter. For more information, see Using an external ID for third-party access (https://docs.aws.amazon.com/IAM/latest/UserGuide/id_roles_create_for-user_externalid.html).

      For more information about AWS authentication, see Configuring AWS authentication.

   3. To save your configuration and establish the connection, click Save.
8. Click Next.
9. To assign user access, on the User access control page, select one or more data source configurations from the Access list, and then click Finish.
10. To manage your active connections, complete the following steps:
    1. On the Integration data sources page, on the tile of the relevant data source, click Manage <x> of <x> active connections.
    2. On the Connection status page, on the tile of the relevant data source, you can edit, refresh, or delete your data source connection.