Small and medium business | Business Central, N...

How to build Datawarehouse for D65 tables

(0) Share

Report

Posted on by Community Member

Hello Gurus,

I am trying to create a star schema (dimension and facts) data warehouse sourced from D365 tables. Has anyone done this before ? Basically wondering if there exists a data model.

Mostly trying to create a star schema using tables such as Contact, Account, Territory, Appointment, Calendar etc. I am sure someone must have already done this so was looking for data model if any recommended by microsoft.

Basically I am trying to create a data structure needed for reporting and analytics.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

This might help: joshanglesea.wordpress.com/.../

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,161 Moderator on at

Like (0)

Report
Copy link

Link copied!

Josh provided you with a good way to figure out the database schema. In addition to that i think you will need assistance from someone with a certain level of product knowledge to be able to build a really useful datawarehouse based on the Business Central data.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry I already have the data mapping but I was looking if someone had already created a datawarehouse and how they converted the D365 tables into Star Schema for reporting

Was this reply helpful? Yes No