Manage connections

Once you have created or edited one or more connections, you can manage them in Connections. Connections let you:

  • View all your connections at a glance, including the owner, the sandbox, and when the connections were created and modified.
  • Edit a connection.
  • Delete a connection.
  • Create a data view from a connection.
  • View all datasets in a connection.
  • Check the status of your connection’s datasets and the status of the ingestion process. For example, when is your data available so that you can start with reporting and analysis in Analysis Workspace.
  • Identify any data discrepancies due to misconfiguration. Are you missing any rows? If so, what rows are missing and why? Did you misconfigure connections and cause missing data in Customer Journey Analytics?

A table shows all connections available. You can quickly search for a connection using the Search Search box.

The following columns / icons are available in the table.

Column / Icon
Description
Name
The connection’s friendly name. To see the details of the connection, select the hyperlinked name. See Connection details.
Information

To view information about Datasets included, Sandbox, Owner, and more, select Information next to the connection name.

A popup window displays details.

View connection info

Data view
To create a data view for the connection, select Data view . This icon only shows when no data view is already associated with the connection.
More

Select More to:

Edit Edit a connection.

Delete Delete a connection.

Data view Create new data view. Use this to create additional data views for the connection.

Datasets

Shows one or more links to the datasets that are part of the connection. You can select the dataset hyperlink to view the dataset in the connection. If more datasets are part of the selected connection, select +x more to show a Datasets included panel. This panel shows links to all datasets and an option to search for a specific dataset that is part of the connection.

Datassets included

Selecting a dataset name opens the dataset in the Experience Platform UI in a new tab.

Sandbox
Shows the Experience Platform sandbox from which this connection draws its datasets. This sandbox was selected when you first created the connection. It cannot be changed.
Owner
The person who created the connection.
Import new data

Shows the status of importing new data for datasets:

●    x On for how many datasets are configured to import new data, and</

●    x Off for how many datasets new data import is turned off.

Date created
The timestamp when the connection was created.
Last modified
The timestamp when the connection is last updated.
Backfill data

Shows the status for backfill data across datasets.

●    x backfills failed for number of failed backfills across datasets,

●    x backfills processing for number of processing backfills across datasets,

●    x backfills completed for number of completed backfills for datasets, and

●    Off in case no backfills are defined for the datasets in the connection.

You can configure which columns to display using Column settings . This shows the Customize table dialog allowing you turn on/off columns in the table.

Edit a connection

Allows admins to edit the connection.

  1. Select More next to the connection name
  2. Select Edit Edit from the context menu.

Alternatively, you can:

  1. Select the connection row.

  2. Select Edit Edit from the blue bar.

When editing a connection, you can:

  • Start and stop importing new data.
  • Rename a connection.
  • Refresh the dataset/s.
  • Remove dataset/s from the connections.

See Create or edit a connection for more information.

Delete a connection connections-delete

Allows admins to delete the connection.

  1. Select More next to the connection name.
  2. Select Delete Delete.

Alternatively, you can:

  1. Select the connection row.

  2. Select Delete Delete from the blue bar.

When you delete a connection, a Delete connection panel indicates which data views are deleted and which workspace projects are affected.

Delete connection

Select Continue to delete the connection.

See Delete implications for more information about the implications of deleting a connection.

Create a data view

Allows admins to create a data view for the connection.

  • If no data view is associated with the connection:

    1. Select Add data view next to the connection name.
  • If one or more data views are already created for the connection:

    1. Select More next to the connection name.
    2. Select Add data view Create new data view.

Alternatively, you can:

  1. Select the connection row.

  2. Select Add data view Create data view from the blue button bar.

See Create or edit a data view for more information.

Connection details connection-detail

To go to the details for a connection, select a connection name in the connections table.

All datasets window showing the widgets and settings

The Connections details interface provides a detailed view of the status of a connection. You can:

  • Check the status of your connection’s datasets and of the ingestion process.
  • Identify configuration problems that can cause skipped or deleted records.
  • See when the data is available for reporting.
User Interface
Description
Edit Edit Connection
To edit the details of a connection, select Edit Edit Connection . See Create or edit a connection for more information.
Dataset selector
Lets you pick one or all datasets in the connection. You cannot multi-select datasets. Defaults to All datasets.
Date range selector
Edit start and/or end date or select Calendar to open the data range selector. In the date range selector, select a date range by using one of the predefined periods (for example Last 6 months) or use the calendar to select start and end date. Select Apply to apply the new data range.
Records of event data available
Represents the total number of event dataset rows available for reporting, for the entire connection. This count is independent of any calendar settings. The count changes if you select a dataset from the dataset selector or by selecting a dataset in the table. Once data is added, there is a latency of 1-2 hours to get the data to appear in reporting.
Metrics

Summarizes the event records added/skipped/deleted, and the number of batches added, for the dataset and date range you have selected.

Select Check detail to show the Check skipped detail popup, listing for all event datasets or selected dataset the number of skipped records and the reason.

Select Info popup with more information. For some skipped reasons, like Empty visitor ID, the popup displays Sample PSQL for EQS (Experience Platform for Query Service) you can use in Query Service to query for the skipped records in the dataset. Select Copy Copy sample PSQL for EQS to copy the SQL.

Records added
Indicates how many rows were added in the selected time period, for the dataset and date range you have selected. Updated every 10 minutes.
Records skipped

Indicates how many rows were skipped in the selected time period, for the dataset and date range you have selected. Reasons for skipping records include: missing timestamps, missing or invalid person ID, and so forth. Updated every 10 minutes.

Invalid person IDs (such as “undefined”, or “00000000”, or any combination of numbers and letters in a Person ID that appears in an event more than 1 million times in a given month) cannot be attributed to any specific user or person. They cannot be ingested into the system and result in error-prone ingestion and reporting. To fix invalid person IDs, you have 3 options:

  • Use Stitching to populate the undefined or all-zero user IDs with valid user IDs.
  • Blank out the user ID, which will then be skipped during ingestion (preferable to invalid or all-zero user IDs).
  • Fix any invalid user IDs in your system before ingesting the data.
Records deleted
Indicates how many rows were deleted in the selected time period, for the dataset and date range you have selected. Someone might have deleted a dataset in Experience Platform, for example. Updated every 10 minutes.
Search Search dataset name or ID
Dataset search field. You can search the datasets table by dataset name or Dataset ID.
Datasets table
Shows the datasets that are part of the connection.
Datasets
Shows the name of the dataset that is part of the connection. You can select the hyperlink to open the dataset in the Experience Platform UI in a new tab. You can select the row or the checkbox to show details for the selected dataset only.
Dataset ID
Automatically generated by Experience Platform.
Records added
The number of dataset records/rows added to a connection during the selected time interval.
Records skipped
The number of dataset records/rows skipped during data transfer for a connection during the selected time interval.
Records deleted
The number of dataset records/rows removed from a connection during the selected time interval.
Batches added
Number of dataset batches have been added to a connection.
Last added
The timestamp of the latest batch from the dataset added to a connection.
Data source type
The source type of the dataset. You define the source type when creating a connection.
Dataset type
The dataset type for this dataset. Type can be Event, Lookup, or Profile. Learn more
Schema
The Experience Platform schema that the dataset is based on.
Import new data

Shows the status of importing new data for the dataset:

●    x On if dataset is configured to import new data, and

●    x Off if dataset is configured to not import new data import.

Backfill data

Shows the status of backfill data for the dataset.

●    x backfills failed for number of failed backfills,

●    x backfills processing for number of backfills processing,

●    x backfills completed for number of backfills completed, and

●    Off in case no backfills are configured.

IMPORTANT
Any data ingested before August 13, 2021 is not reflected in the Connections interface.

Connection panel

When no dataset is selected in the datasets table, a panel on the right side of the Connections interface shows connection options and details.

Options / Details
Description
Refresh Refresh
To refresh the connection and allow recently added records to be reflected, select Refresh Refresh.
Delete Delete
Delete this connection.
Add data view Create data view
Create a data view based on this connection. See Data views for more information.
Connection name
Shows the friendly name of the connection.
Connection description
Shows a more detailed description that describes the purpose of this connection.
Sandbox
The Experience Platform sandbox from which this connection draws its dataset/s. This sandbox was selected when you first created the connection. It cannot be changed.
Connection ID
This ID is generated in Experience Platform. You can use Copy to copy the ID.
Data views using connection
Lists all the data views that use this connection.
Import new data

Shows the status of importing new data for datasets:

●    x On for how many datasets are configured to import new data, and

●    x Off for how many datasets new data import is turned off.

Backfill data

Shows the status of backfill data for datasets.

●    x backfills failed for number of failed backfills across datasets,

●    x backfills processing for number of processing backfills across datasets,

●    x backfills completed for number of completed backfills for datasets, and

●    Off in case no backfills are defined for the datasets in the connection.

Created by
Shows the name of the person who created the connection.
Last modified
Shows the timestamp of the last change to the connection.
Last modified by
Shows the person who last modified the connection.

Dataset panel

When a dataset is selected in the datasets table, a panel on the right side of the Connections interface show details for the selected dataset.

Details
Description
Person ID
Shows an identity that was defined in the dataset schema in the Experience Platform. This is the Person ID that you selected during the creation of the connection. If you create a connection that includes datasets with different IDs, the reporting reflects that. To merge datasets, you need use the same Person ID across datasets.
Key
Shows the key that you have specified for a lookup dataset.
Matching Key
Shows the matching key that you have specified for a lookup dataset.
Timestamp
Show the timestamp defined for an event dataset.
Records available
Represents the total number of rows ingested for this dataset, for the particular time period selected through the calendar. There is no latency in terms of getting the data to appear in reporting, once it is added. However, when you create a brand new connection, there will be latency.
Records added
Indicates how many rows were added in the selected time period.
Records deleted
Indicates how many records were deleted during the selected time period.
Batches added
Indicates how many data batches were added into this dataset.
Records skipped

Indicates how many rows were skipped during ingestion in the selected time period.

Reasons for skipping records include: Missing timestamps, missing or invalid person ID, and so forth. Updated every 10 minutes.

Invalid person IDs (such as “undefined”, or “00000000”, or any combination of numbers and letters in a Person ID that appears in an event more than 1 million times in a given month) cannot be attributed to any specific user or person. They cannot be ingested into the system and result in error-prone ingestion and reporting. To fix invalid person IDs, you have 3 options:

  • Use Stitching to populate the undefined or all-zero user IDs with valid user IDs.
  • Blank out the user ID, which is then skipped during ingestion (preferable to invalid or all-zero user IDs).
  • Fix any invalid user IDs in your system before ingesting the data.
Last added
Indicates when the last batch was added.
Import new data

Shows the status of importing new data for the dataset:

●    x On if dataset is configured to import new data, and

●    x Off if dataset is configured to not import new data import.

Backfill data

Shows the status of backfill data for the dataset.

●    x backfills failed for number of failed backfills,

●    x backfills processing for number of backfills processing,

●    x backfills completed for number of backfills completed, and

●    Off in case no backfills are configured.

To show a dialog with an overview of the past backfills for the dataset, select Past backfills Past backfills.

Data source type
Data source type as defined when adding dataset to the connection.
Dataset type
Either Event, Lookup, or Profile. Learn more
Schema
Shows the Experience Platform schema that this dataset is based on.
Dataset ID
This dataset ID is generated in Experience Platform.
recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79