Create an Experience Platform schema for Pendo

You must also ensure that you first create an Experience Platform schema to use for your source. See the tutorial on creating an Experience Platform schema for comprehensive steps on how to create a schema.

Experience Platform UI showing an example schema for Pendo.

Connect your Pendo account

In the Experience Platform UI, select Sources from the left navigation to access the Sources workspace and see a catalog of sources available in Experience Platform.

Use the Categories menu to filter sources by category. Alternatively, enter a source name in the search bar to find a specific source from the catalog.

Go to the Analytics category to see the Pendo source card. To begin, select Add data.

The Experience Platform UI source catalog with the Pendo card.

Select data

The Select data step appears, providing an interface for you to select the data that you want to bring to Experience Platform.

  • The left part of the interface is a browser that allows you to view the available data streams within your account;
  • The right part of the interface lets you preview up to 100 rows of data from a JSON file.

Select Upload files to upload a JSON file from your local system. Alternatively, you can drag and drop the JSON file you want to upload into the Drag and drop files panel.

The add data step of the sources workflow.

Once your file uploads, the preview interface updates to display a preview of the schema you uploaded. The preview interface allows you to inspect the contents and structure of a file. You can also use the Search field utility to access specific items from within your schema.

When finished, select Next.

The preview step of the sources workflow.

Dataflow detail

The Dataflow detail step appears, providing you with options to use an existing dataset or establish a new dataset for your dataflow, as well as an opportunity to provide a name and description for your dataflow. During this step, you can also configure settings for Profile ingestion, error diagnostics, partial ingestion, and alerts.

When finished, select Next.

The dataflow-detail step of the sources workflow.

Mapping

The Mapping step appears, providing you with an interface to map the source fields from your source schema to their appropriate target XDM fields in the target schema.

Experience Platform provides intelligent recommendations for auto-mapped fields based on the target schema or dataset that you selected. You can manually adjust mapping rules to suit your use cases. Based on your needs, you can choose to map fields directly, or use data prep functions to transform source data to derive computed or calculated values. For comprehensive steps on using the mapper interface and calculated fields, see the Data Prep UI guide.

The mappings listed below are mandatory and should be setup before proceeding to the Review stage.

Target FieldDescription
uniqueIdThe Pendo identifier for the event.

Once your source data is successfully mapped, select Next.

The mapping step of the sources workflow.

Review

The Review step appears, allowing you to review your new dataflow before it is created. Details are grouped within the following categories:

  • Connection: Shows the source type, the relevant path of the chosen source file, and the amount of columns within that source file.
  • Assign dataset & map fields: Shows which dataset the source data is being ingested into, including the schema that the dataset adheres to.

Once you have reviewed your dataflow, select Finish and allow some time for the dataflow to be created.

The review step of the sources workflow.