CDS-A, Azure data lake, BYOD as advanced analytics option on Microsoft Dynamics 365 Finance and Operations

CDS-A, Azure data lake, BYOD as advanced analytics option on Microsoft Dynamics 365 Finance and Operations

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

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 ADLS

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