Customer experience | Sales, Customer Insights,...

Export Customer insights - Journey data

(1) Share

Report

Posted on by CU04030504-0

New to dynamics, i am trying to export the customer insights - Journey data and create relational database, How can we do it.

Categories:

Dynamics 365 Customer Insights - Data

Dynamics 365 Customer Insights - Journeys

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Goloknath 1,909 User Group Leader on at

Like
a
(0)

Report
Copy link

Link copied!
Here are 3 effective ways to build that relational bridge, depending on your technical comfort level.
1. This is the "gold standard" for 2026. Microsoft has replaced the old "Export to Data Lake" service with the Azure Synapse Link or the Microsoft Fabric integration.

You "link" your Dataverse environment to a Fabric workspace or an Azure Data Lake Storage account.

It automatically synchronizes your tables (Accounts, Contacts, Leads) into Parquet or Delta format, which can be queried using SQL just like a relational database.

CIJ interactions (the "big data") are naturally stored in the lake, so linking them here keeps everything in one place.

2. If you already have an existing SQL Server or PostgreSQL database and want to "pull" the data into it, you'll use the OData v4 Web API.

You can use Azure Data Factory (ADF) or SSIS with a Dynamics 365 connector.

1. Point ADF to your Dynamics 365 Organization URL. 2. Select the entities (tables) you need. 3. Map the fields to your destination SQL tables.

This is great for Profile data (who people are), but it is very inefficient for Interaction data (what they did) due to API throttling.

3. When you are looking for Journey data specifically (which journey did they join? which email was sent?), you need to look at specific tables.

Tables starting with msdynmkt_ (e.g., msdynmkt_journey, msdynmkt_email) contain the "definition" of your marketing assets.

These are the "events." In CIJ, these aren't always visible as standard SQL tables in Dataverse. You must enable the Analytics export in the CIJ Settings to push these into your own Azure storage for your relational database to ingest.

if this helps pls mark as verified so that it may be helpful for someone else. Thanks!

Was this reply helpful? Yes No
Suggested answer

11manish 1,081 on at

Like
a
(0)

Report
Copy link

Link copied!

To export Customer Insights – Journeys data into a relational database, the most robust and scalable approach is to use Synapse Link for Dataverse, which automatically streams journey and interaction tables into Azure Data Lake while preserving relational structure. From there, you can query the data using Synapse, Fabric, or load it into Azure SQL for traditional relational modeling. If a simpler approach is needed, Power Platform Dataflows or a custom ETL using Dataverse Web API can also be used, but they require manual mapping of relationships and ongoing maintenance.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Export Customer insights - Journey data

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Export Customer insights - Journey data

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the June Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates