Oh, one thing that we covered yesterday but that I completely forgot about is the same connection strings that allow you to connect Power BI to Dynamics could also be used for connecting SQL Server Management studio. But wait. Before you go poking around your live Dynamics database, be aware that this locks the tables when you are connected! Yeah. I am glad that we covered that. This is probably something I would have done just to go poking around. However, I also learned today that canvas apps can use connections to different solutions. So, you could even create an app on one tenancy and connect that to a Dynamics solution in another tenancy. That is quite nice. However, it is not possible to do this in a model driven app. That little nugget blows one of my earlier ideas out the window.
Another interesting thing I learned today Is solutions can be exported and imported. Solutions contain the Common Data model, the views, graphs, dashboards and everything else excluding the data that makes up a Dynamics installation. The CDS Common data Service is still something I am not sure of. According to the documentation this is stored in the solution. But that just does not make logical sense to me. Sorry. I am going off point. What I am trying to say is this is fantastic for a few reasons. Firstly, it makes migrating changes along the dev to release pipeline easy. Your version your solutions and just export / import them from dev to test staging to production. What is even better is you can tie in Git hub to regularly back up your solutions. Again, that contains your CDM, CDS, views, dashboards, graphs, site aps and everything else (excluding the data) in your Dynamics instance. When you export the solution, it arrives on your computer as a repository of XML files. So, you could even run comparisons on these files.
There is a great way of kicking the tires on this. I wish every service were as open. Go to https://trials.dynamics.com and sign up for each dynamics component you want to test.
It is very clear as I go through this system more and more each day that it is interconnectivity with Power platform is now at the core of dynamics. Now with the unification of the UI to match that of Power Platform, it is becoming hard to see where one ends and the other begins. Of course, with any UI migration, it has not done and dusted over night, but I think I said this last night. It seems that I am coming to the Dynamics world at a really good time.