How Panaseer connectors organize your data

Many cybersecurity solutions take a "black box" approach to data mapping, hiding the process from their customers. Panaseer’s transparent data mapping shows you how connectors manage your data responsibly, and with purpose, to build trust and support your goals.

Key benefits

• Instant visibility, saving time: no more querying databases to see field mappings. Explore all your data mappings directly in Panaseer.
• % population in Panaseer: quickly check the population of key fields without digging through raw data.
• Spot and fix issues faster: identify gaps in normalization and debug field mappings in minutes, not hours.

Viewing data mappings and transformations

Panaseer uses data connectors to integrate data from different security tools. Each installed connector retains information on how your data was ingested, mapped and transformed in Panaseer.

To view a connector’s data mapping and transforms:

1. Click on the Data Management Center icon on the left-hand menu.
2. Click the Data sources panel to display the catalog.
3. Click the Installed tab to view all the connectors currently installed on your platform.
4. Locate the required connector in the list and then click the Details button.

An example of a Panaseer connector

The Details page shows a list of data mappings and transform operations for the selected connector.

Connector column mappings and transformations

• Panaseer Columns: these are common inventory columns populated by connector values. These columns are where Panaseer stores the mapped data.
• Operation: this is the transformation performed on the data from various security tools to improve clarity and accuracy in Panaseer.

You can look at the operations to quickly see how the connector mapped and transformed the data to Panaseer inventory columns, without interrogating any databases.

Data mapping and transform examples

Collect Timestamp

In some cases, the mapping does not need transformation, such as the Collect Timestamp column. The data is copied from the security tools into a column.

Source System ID

Some mappings are a little more complicated, such as the Source System ID column. This operation applies several transformations on the data from your security tools:

• Convert the value in the addr column to lowercase.
• Trim any leading or trailing spaces from the result.
• Ensure the result is explicitly a string type.

Snapshot Date

Some transforms are very complex, such as the Snapshot Date column, which is beyond the scope of this Help Center page.