Access your UDE Database through SQL JIT!
As we are coming closer to the Global Availability of the Unified Developer Experience for Dynamics 365 Finance and Operations, the Product Group from Microsoft is adding more and more features to achieve the same parity as in CHE (Cloud Hosted environments) in LCS. Two months ago, they added the feature to set up VS 2022 with a single click and from today we can test one of the most requested feature, access the D365FO Database directly from SQL Server Management Studio using JIT (just-in-time).
To have this possibility first, you have to update the extension Power Platform Tools for VS 2022 to the latest version 1.0.14308776.0
The next time you start VS in the menu you should have the option Tools> SQL Credentials for Dynamics 365 FinOps:
In the new window, you can select if you like your access to be Read or Write (like in LCS currently), and enter the description for what you are requesting this access, in the IP address by default your public IP address is prefilled, but you can also enter an address range:
After you click on the button Request Access, you should wait a minute or two and you will get your connection details:
领英推荐
Copy this information to your SQL Server Management Studio (or your Azure Data Studio, or VS Code, pick your poison) and connect to your D365FO UDE Database.
Let's now try and edit some data. Here in the example below you can see that the customer with ID 128725 has a value of CM3M for the payment term, but after the update statement the value of the payment term is CM1M:
Some caveats.
Updating or dropping an index does not work, also the updated stats are not working. This is not by limitation of the product, but by choice to have less access to this SaaS product. Just to remind you this is in preview, and it might be updated before GA.
If you are working from an office or from behind a company VPN, you and your colleagues might have the same public IP address and if someone else requests JIT access for the same IP address your existing JIT access will be deleted. We gave feedback to MS so that they can show some warning and/or some info window, so hopefully that experience will be updated soon.
That's it, now go and test and find some other interesting scenarios that might are not working :)
Hi, is this only available if the UDE environment is a type "Developer" and not if it was deployed as a type "Sandbox"? Because I think I cannot connect to a type SANDBOX from Visual Studio?