Activate Database Collector - Administrator Guide - Cortex XSIAM - Cortex - Security Operations

Connection

Select the type of database connection as MySQL, PostegreSQL, MSSQL, or Oracle.

Host

Specify the hostname or IP address of the database.

Port

Specify the port number of the database.

Database

Specify the database name for the type of database configured. This field is relevant when configuring a Connection Type for MySQL, PostegreSQL, and MSSQL.

When configuring an Oracle connection, this field is called Service Name, so you can specify the name of the service.

Enable SSL

Select whether to Enable SSL (default) to encrypt the data while in transit between the database and the Broker VM.

Username

Enter the username to access the database.

Password

Enter the password to access the database.

Test Connection

Select to validate the database connection.

Rising Column

Specify a column for the Database Collector applet to keep track of new rows from one input execution to the next. This column must be included in the query results.

Retrieval Value

Specify a Retrieval Value for the Database Collector applet to determine which rows are new from one input execution to the next. Cortex XSIAM supports configuring this value as an integer or a string that contains a timestamp. The following string timestamp formats are supported: ISO 8601 format, RFC 2822 format, date strings with month names spelled out, such as “January 1, 2022”, date strings with abbreviated month names, such as “Jan 1, 2022", and date strings with two-digit years- MM/DD/YY.

The first time the input is run, the Database Collector applet only selects those rows that contain a value higher than the value you specified in this field. Each time the input finishes running, the Database Collector applet updates the input's Retrieval Value with the value in the last row of the Rising Column.

Unique IDs (Optional)

Specify the column name(s) to match against when multiple records have the same value in the Rising Column. This column must be included in the query results. This is a comma separated field that supports multiple values. In addition, when specifying a Unique IDs, the query should use the greater than equal to sign (>=) in relation to the Retrieval Value. If the Unique IDs is left empty, the user should use the greater than sign (>).

Collect Every

Specify the execution frequency of collection by designating a number and then selecting the unit as either Seconds, Minutes, Hours, or Days.

Vendor and Product

Specify the Vendor and Product for the type of data being collected. The vendor and product are used to define the name of your Cortex Query Language (XQL) dataset (<Vendor>_<Product>_raw).

SQL Query

Specify the SQL Query to run and collect data from the database by replacing the example query provided in the editor box. The question mark (?) in the query is a checkpoint placeholder for the Retrieval Value. Every time the input is run, the Database Collector applet replaces the question mark with the latest checkpoint value (i.e. start value) for the Retrieval Value.

Generate Preview

Select Generate Preview to display up to 10 rows from the SQL Query and Preview the results. The Preview works based on the Database Collector settings, which means that if after running the query no results are returned, then the Preview returns no records.

Add Query (Optional)

To define another Query for data collection on the configured database connection, select Add Query. Another Query section is displayed for you to configure.