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)
Expecting some good features to enable lot of business needs
- Aggregated Entities ADL Azure Data Lake PU23+
Uses a storage account
- 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
Whitepaper on
- 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
- Define one or more SQL Azure databases for exporting Entity data from D365FO
- Export all the records using full push or export changes records using incremental push
- Leverage batch framework schedule recurring exports
*This post is locked for comments