Data access and export blueprint

The data access and export blueprint outlines all the possible methods whereby data can be accessed or exported from Experience Platform and applications.

The blueprint is broken up into two categories for data access from Experience Platform and applications.

The first includes approaches for egressing data from Experience Platform and applications. This would be considered a push type method of data egress.

The second includes approaches for access data from Experience Platform and applications. This would be considered a pull type method of data access.

Data access approaches:

Data export approaches:

Data access and export overview architecture

Reference architecture for the Data Preparation and Ingestion Blueprint {modal="regular"}

Data access and export methods

Streaming Destinations
Method
Common Use Cases
Protocols
Considerations
Event Forwarding
  • Forwarding of raw data collected from Adobe SDKs for analysis and collection to enterprise systems
  • Light weight tagging for 3 rd party data collection through extensions
  • Push
  • JSON
  • REST API
  • Low level raw events
  • No aggregation or prior record context added
RTCDP – Streaming Segment Exports
  • Activate audiences from RTCDP to marketing and advertising, systems..
  • Push
  • JSON
  • REST API
  • Aggregated data representing audience membership
  • No activation of raw experience event data
RTCDP – Profile Export Destinations
  • Leverage RTCDP rich behavioral profiles and audiences to enhance consumer experiences and marketing.
  • Activate audiences and profile attributes from RTCDP to marketing and advertising, systems that operate on audiences and profile attributes.
  • Activate AEP profiles to Email Service Providers, lead nurturing and CRM systems.
  • Push
  • JSON
  • REST API
  • Aggregated data representing audience membership and profile record attributes
  • No activation of raw experience event data
RTCDP - Personalization Destinations
  • Access the Real-time Customer Profile in browser and client side experiences to enrich client side personalization.
  • JSON
  • Requires deployment of WebSDK
RTCDP - Destination SDK
  • Configure a customized destination card in the RTCDP destinations.
  • Supports file and streaming type destinations
  • JSON
  • CSV
  • Allows partners and brands to configure custom destination cards
RTCDP - Profile Lookup Hub API
  • Access profile to enrich consumer experiences for agent assisted experiences such as support or sales agent interactions.
  • Pull
  • JSON
  • REST API
  • Hub lookup ideal for

    500ms+ use cases only

RTCDP - Profile Lookup Edge API
  • Access profile on the edge to enrich consumer experiences for real-time <200ms experiences such as personalization or offer decisions on web and mobile.
  • Pull
  • JSON
  • REST API
  • For real-time experiences and server to server integrations
Journey Optimizer Custom Actions
  • Activation of 1:1 journey events and triggers to notify an external system. Cart abandons, application abandons, registrations.
  • Push
  • JSON
  • REST API
  • Single event activation for a given profile. Not for aggregation or bulk operations
Batch Destinations
Method
Common Use Cases
Protocols
Considerations
Data Access API
  • Access to raw data for data science and ML workflows outside of Experience Platform.
  • Pull
  • REST API
  • Parquet files
  • Requires development processes to access and process parquet files into usable datasets
Query Service
  • Persist query results of datasets, for aggregated insight and reporting.
  • Pull
  • PostgreSQL
  • SQL Client
  • Aggregate data only. 10 minute query limit.
Dataset Export
  • Export Experience Platform event data for access in external reporting, analysis, and data science tools.
  • Export of aggregated profile insights and audience membership for external reporting, analysis, and data science tools.
  • Push
  • REST API
  • CSV
  • Subset of datasets are supported as outlined in the product documentation.

Approaches for Data Access

Real-time Customer Profile Access API rtcp-profile-access-api

Customers can access single unified profiles from the Real-time Customer Profile store including all profile identities, audience memberships, attributes and experience events using the Real-time Customer Profile Access API.

Refer to the Real-time Customer Profile Access API documentation for additional information.

Use cases

  • Lookup a single profile to add context to agent customer interaction such as a support interactions through chat and call center, or a sales interaction at the point of sale.
  • Allow added context to a personalization descision made by an external system, for example a web personalization system or a offer decision system.

Considerations

  • Real-time Customer Profile guardrails apply.
  • Designed for single profile lookup at a time. Not used for bulk profile access or download of the entire profile population for the use of analysis or data science.
  • Profile lookup response time adhears to the profile guardrails. Real-time low latency requirements - for example for same page personalization requirements should utilize the Edge Profile from the to Adobe Target Connection or the Custom Personalization Connection for real-time profile access for in browser and in app personalization.

Data Access API data-access-api

Using the data access API customers can directly access the raw dataset files that are stored in the Experience Platform data lake.

  • For additional details on using the data access API please refer to the documentation.

Use cases

  • Pull raw and processed data files from Experience Platform for storage and evaluation in enterprise environments.

Considerations

  • As data is accessed in a batch asynchronous fashion the access to the data will be inherently latent as compared to streaming data egress approaches such as utlitizing Tags, Event Forwarding, or RTCDP Destinations.
  • Data files when processed into Experience Platform are stored as collections of files in batches and are compressed and stored in parquet format. As such when accessing and downloading the files to a different environment they must be systematically accessed by their batch and file as oppossed to an entire dataset and any operations on the data must account for the files being compressed in parquet format.

Query Service query-service

Using the experience platform Query Service customers can query datasets within Experience Platform and persist the results of the query. A SQL Client can be utilized to query and persist the query response in the desired storage destination that the SQL client can support. The Query Service UI can be used to store the SQL result in a target dataset in the Experience Platform or the results can be saved to the local machine.

  • For additional details on connectin to SQL clients to persist SQL results from Experience Platform Query Service see the following documentation.

Use cases

  • Query raw data from the Experience Platform datasets and persist the query results.
  • Query the profile snapshot dataset to extract insights on the Real-time Customer Profile. Documentation.
  • Store query results into a separate dataset for access or into a profile enabled dataset which can later be egressed through RTCDP and other Experience Cloud applications which access the Real-time Customer Profile.

Considerations

  • As data is queried in a batch asynchronous fashion the access to the data will be inherently latent as compared to streaming data egress approaches such as utlitizing Tags, Event Forwarding, or RTCDP Destinations.
  • Only data that is available in the Experience Platform data lake can be queried using the Query Service. The Real-time Customer Profile store, the identity graph, Customer Journey Analytics can not be directly queried using the Query Service. Only when datasets are exported to the data lake can these datasets be queried, as in the example of the profile snapshot dataset.
  • Note that guardrails for the number of query results and the query timeout apply as outlined in the Query Services guardrails documentation.

Approaches for Data Export

Client-side tag extensions client-side-tags-extensions

Extensions can be deployed using Adobe’s Tags solution. Once an extension is deployed data requests are deployed directly on a client browser or application and a request can be invoked to send data and requests to the desired destination.

Refer to the Tags Overview documentation for additional information.

Use cases

  • Collect raw streaming information directly from client side environments using tagging.

Considerations

  • No direct access to any server side information such as the Experience Platform Real-time Customer Profile and audience memberships.
  • Adding additional data collection tags to the page may increase page load times.
  • Ability to set up rules to only request data when certain criteria are met.
  • Data is collected directly from the client, limiting the types of transformations and enrichment that can be performed prior to collecting the data.

Event forwarding event-forwarding

Data collection requests are collected directly to Adobe’s Edge Network. From the Edge Network requests to external RESTful endpoints can ba configured to forward these requests on to the external destination.

Refer to the following Event Forwarding documentation for additional information.

Use cases

  • Collect raw streaming information directly from client side environments to a enterprise endpoint using Adobe’s server side event forwarding.

Considerations

  • To use Event Forwarding, data must be sent to the Edge Network using the Web SDK or MobileSDK.
  • Event forwarding approach reduces the page load time and weight due to additional tags being added on the page.
  • No enrichment from the edge profile or other data sources is currently supported.
  • Limited data filtering and simple mapping transformations are supported.

Real-time Customer Data Platform destinations RTCDP-destinations

Profile attribute data and audience membership data can be activated to enterprise and advertising destinations. This means the data egressed must be ingested into the Experience Platform Real-time Customer Profile.

Refer to the Real-time Customer Data Platform Destinations documentation for additional information.

Use cases

  • Activate profile attibute information including audience membership to a internal enterprise data stores, analytsis tools, email systems, or support systems.
  • Activate profile audience membership to a external advertising vender to target and personalize content to the profile.

Considerations

  • Profile attributes and audience memberships can be activated. Raw experience events can not currently be activated as part of RTCDP Destinations.
  • Activations happen in streaming or batch depending on the nature of the segment evalution and the nature of the ingestion protocal that the destination accepts.

Journey Optimizer custom actions jo-custom-actions

Using Journey Optimizer customers can invoke a custom action from the journey canvas to send a payload or message to a external API endpoint that is configured. An action can be configured to any service from any provider that can be called through a REST API with a JSON-formatted payload. This payload can include event information, profile attributes and prior event data, transformations and enrichments that are configured in the journey.

Refer to the Journey Optimizer custom actions documentation for additional information.

Use cases

  • Activation events from Experience Platform and Journey Optimizer that include additional information from the Real-time Customer Profile.
  • Notify external systems when a customer has reached a specific point of a journey.

Considerations

  • Guardrails on the throughput supported by Journey Optimizer and enrichments supported by the Real-time Customer Profile apply.
  • Custom actions can be performed in a streaming one by one fashion for each event or profile in a journey. Bulk operations or bulk data egress in the form of files or aggregated requests across customer journeys can not be performed.
  • Streaming access to Real-time Customer Profile attributes and experience events which can be included in the activation payload.
  • Event data can be filtered and simple mapping transformations applied before sending events to external destinations.
recommendation-more-help
045b7d44-713c-4708-a7a6-5dea7cc2546b