In my previous blog I explained the issues that I faced while POA entity migration. Here I will explain the whole process that I followed to migrate the personal views with sharing information. I used kingsway soft adapter for my migration process.
We have 2 steps to migrate the data
- Source CRM –> Intermediate database.
- I enabled “Data Export Services” on the source instance to push the data into intermediate database.
- Since “userquery” entity is not available in “Data Export Services”, I Designed a simple SSIS Package with source (Dynamics CRM) and destination (OLE DB) components.
- We have to impersonate the owner of the personal view in the Dynamics CRM Source component to read this information.
- So we have to run this package multiple times based on the user count.
- Intermediate database –> Target CRM
- Designed 2 more SSIS Packages to push “userquery” and “principalobjectaccess” (share) information to Target CRM instance.
- userquery package is pretty straightforward with source (OLE DB) and destination (Dynamics CRM) components. So I am not explaining much about this package.
- But we faced some issues which I explained in the previous blog while migrating “principalobjectaccess” data. I followed the below process to migrate this data.
- Created a SQL View in intermediate database on “principaobjectaccess” table by joining the “userquery” table to get the owner of the personal view.
- I used this view in “OLE DB” source component to read the data.
- This owner field should be mapped to “impersonateas” field in the destination component, so that internally the share request will be executed under owner context.
- Batch size should be 1 in the Dynamics CRM Destination component, otherwise it will not process all the records.
This process is same to migrate personal charts (userqueryvisualization) and dashboards (userform) also. Hope this information is helpful.
6 thoughts on “Migration of Personal views/charts/dashboards with sharing information”
Reblogged this on Nishant Rana's Weblog and commented:
Interesting read ..
Reblogged this on Ricky Safford Development Repository and commented:
Awesome article describing POA Table Migration in the Microsoft 365 Dataverse!
Hello Phani, Thank you for your post! But can you give examples as to why I can not see userquery in CRM destination manager? Thank you in advance!
I am trying to use a loop to pass to a crm source that returns the list of userqueries but am having trouble passing a loop variable to the ImpersonateAs property of the kingswaysoft source object. Do you have any screen shots or directions to set the loop up?