I have the Dynamics 365 SQL database. I want to find the relationship between AccountBase / ContactBase and ActivityPointerBase / other Base. I don't seem to find the IDs that can join. Is there documents that contains the joins?
I found the joins by opening many view to find the joins. There are hundreds views. The AccountId in AccountBase table named different in Activity tables. It made it difficult. It took me a long time to find out. Thank you very for your help.
Ohh, if you just have the DB then you have to manually check the relationship under the the individual entities. I don't have access to db as of now so not exactly sure but if I am not wrong, it will be under foreign key.
As an alternate, if you just want to know the out of box relationship. Then you can download the relevant crm version sdk which has the EntityMetadata excel file.
https://msdn.microsoft.com/en-us/library/gg309396.aspx#bkmk_EntityMetadata
You can download the sdk here-https://www.microsoft.com/en-au/download/details.aspx?id=50032
Hope this helps.
Ravi, how don't I get the metadata diagram tool. I don't have access to the CRM. I only have the client SQL Database that was provided by Microsoft.
You can use ER diagram to see how these entities are related, you can use xrmtoolbox www.xrmtoolbox.com/.../JourneyIntoCRM.XrmToolbox.ERDPlugin
Apart from that you can see all the relation ships from the default solution by navigating to individual entities ->relationships
You don't need to install SDK to just cehck the relationship. Did you try this etting>> Customization >> Customize the System >> {Select your entity} >> click on 1:N or N:1 and N:N. Fo 1:N or N:1?
Need some more help. What SDK do I have to install? Thanks.
Hi,
You would need to check the relationship of the specifc entities i.e. how the 2 entities are linked (1:N, N:1 or N;N) from the customization. Setting>> Customization >> Customize the System >> {Select your entity} >> click on 1:N or N:1 and N:N. Fo 1:N or N:1, you will find the schema name in the relationshio which will exists in either of the entity. For N:N, you will find the schema name under the relationship which would be a table in itself.
Hope it helps.
Hi danyeungw,
You can use the metadata diagram tool to build entity diagrams. The generated entity diagrams show the relationships between entities and includes the names of id fields.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (