search

d365collaborative / d365fo.tools

Tools used for Dynamics 365 Finance and Operations
MIT License
244 stars 101 forks source link

Proposition: Add cmdlets to reset the MR DataMart #514

Open valerymoskalenko opened 3 years ago

valerymoskalenko commented 3 years ago

It would be nice to have a couple of cmdlets to reset Financial Reports DataMart and to see the current status of integration.

Invoke-D365DataMartReset

I prefer using SQL scripts provided here https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore#reset-the-financial-reporting-data-mart-for-dynamics-365-finance--operations-on-premises-through-sql-server-management-studio

Get-D365DataMartIntegration

select ReaderObjectName, WriterObjectName, LastRunTime, StateType from Connector.MapsWithDetail with (nolock)

Splaxi commented 3 years ago

That is a great idea and thanks for the pointers!