Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Activity Party entity ...
Customer experience | Sales, Customer Insights,...
Suggested answer

Activity Party entity to SQL Server db

(0) ShareShare
ReportReport
Posted on by Amila Akalanka 15

Hello,

I'm trying to figure out a way to export the Activity Party table to the SQL server database for reporting purposes. Earlier we used Data Export Services to export this data. However, since DES is deprecated I'm trying to find an alternative method to do this. I followed the manner suggested by Microsoft to use Dataverse with Synapse link. But as activityparty is not showing in the table list in dataverse (In MS Power Apps portal). I'm quite new to the dynamics and not sure how to achieve this (Or whether I'm taking a completely wrong approach). Is there anyway to achieve this ? 

Thanks in advance!

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,964 Super User 2024 Season 1 on at
    RE: Activity Party entity to SQL Server db

    Hi,

    Make sure Change Tracking is enabled for your entity.

    learn.microsoft.com/.../azure-synapse-link-synapse

  • Amila Akalanka Profile Picture
    Amila Akalanka 15 on at
    RE: Activity Party entity to SQL Server db

    Hi Abdul Wahab,

    I checked both articles and tried the ADF approach. But still, no luck as the actitivtyparty entity is not showing in the available list of entities for the copy.

    Thank you!

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: Activity Party entity to SQL Server db

    Hi Amila Akalanka,

    Did you check these links and still have no luck?

    1. https://learn.microsoft.com/en-us/azure/data-factory/connector-dynamics-crm-office-365?tabs=data-factory
    2. learn.microsoft.com/.../export-data-lake-faq
  • Amila Akalanka Profile Picture
    Amila Akalanka 15 on at
    Activity party export to SQL Server db

    Hello,

    I'm trying to figure out a way to export the Activity Party table to the SQL server database for reporting purposes. Earlier we used Data Export Services to export this data. However, since DES is deprecated I'm trying to find an alternative method to do this. I followed the manner suggested by Microsoft to use Dataverse with Synapse link. But as activityparty is not showing in the table list in dataverse (In MS Power Apps portal). I'm quite new to the dynamics and not sure how to achieve this (Or whether I'm taking a completely wrong approach). Is there any way to achieve this?

    Thanks in advance!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans