Analytic insights into information from Microsoft Dynamics 365 Finance and Operations One version with CDS-A, Azure data lake, BYODW, entity store

Analytic insights into information from Microsoft Dynamics 365 Finance and Operations One version with CDS-A, Azure data lake, BYODW, entity store

There are number of options with Microsoft Dynamics 365 Finance and Operations One version and more coming. Sharing list and details of most common BYODW.

• CDS-A (expected in June-July 2019)

https://docs.microsoft.com/en-us/business-applications-release-notes/april19/dynamics365-finance-operations/integration-dual-write

Expecting some good features to enable lot of business needs

• Aggregated Entities ADL Azure Data Lake PU23+

Uses a storage account

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/data-entities/entity-store-data-lake

• Aggregated entities to entity store (included in subscription)

Utilize with embedded PowerBI analytics

• Aggregated entities to BYDOW

Pro-Full control of data in your own data warehouse and ability to merge with other data

Con-Cost of BYODW

Using an API

https://github.com/Microsoft/BusinessPlatformApps/blob/dev/Source/Actions/Microsoft.Deployment.Actions.Custom/Ax/UpdateAxConfigurationEntity.cs

Whitepaper on

https://mbs.microsoft.com/customersource/northamerica/365Enterprise/learning/documentation/how-to-articles/StrategiesReporting365FinanceOperationsEnterprise

• Data entities to BYDOW

Wondering how to get your data to your own data warehouse BYODW with Microsoft Dynamics 365 Finance and Operations One version

1. 1. Define one or more SQL Azure databases for exporting Entity data from D365FO
   2. Export all the records using full push or export changes records using incremental push
   3. Leverage batch framework schedule recurring exports