Dynamics Community Forum Thread Details

Activity pointer and mapping to Activity Parties

We replicate from Dynamics 365 CRM 9.x Online to an inhouse SQL server using SCRIBE Online Replication. We pull the activitypointer table every 15 minutes as this table has a modifiedon date. Where we are challenged is that a few key columns in this table are activitypartyid lists and we can't replicate the activityparty table given its size and lack of a modifiedon date (can take 18-20 hours to replicate or more).

What we need to be able to do is determine what accounts or contacts referred to in the activitypointer columns so that we can do appropriate reporting on which sales reps are touching (email, appointment, phone call) which of their clients on a regular basis as part of their comp is tied to touching all of their accounts each quarter.

In addition to using SCRIBE Online for replication, we have SCRIBE Insight available to us on our local servers and we have SSIS with Kingswaysoft connector for Dynamics 365. Are there any efficient approaches we might use to retrieve the level of information we need for our reporting?

Quick Links

Leaderboard