Extract ALL your Dynamics 365 for Finance and Operations data

With Dynamics 365 for Finance and Operations export to Azure Data Lake postponed again, businesses face massive challenges when looking for insights into their ERP data through the available D365FO data entities. BIBuilder4Dynamics enables businesses to bypass this challenge and extract data directly from the underlying tables. With a rich meta-data analyzer, BIBuilder4Dynamics knows your D365FO data model and helps you simplify the complicated D365FO data model.

Build a complete BI solution or stick with just data extraction

BIBuilder4Dynamics allows you to build a complete best practice BI solution based on the actual tables in D365FO with a simple point and click interface, turning data into a complete reporting solution in hours instead of weeks or months. BIBuilder4Dynamics builds standard Microsoft BI components – SQL Server, SSIS and Analysis Services – which you are free to customize as needed to fill complex reporting and analytical needs.
Or if you have an existing BI infrastructure, just extract your data to staging and build the rest yourself. Whether you only need the raw data or you need to build a full BI solution, BIBuilder4Dynamics can help you create fast, best-practise solutions quickly.

Features:

• Bypass Data Entities and extract data straight from tables
• Metadata analysis for simplifying data model and easily create valid joins between tables
• Supported sources:
  • D365FO
  • D365CE
  • SQL Server databases
  • Everything else - by building custom SSIS packages
• Supports Analysis Services both on-premise and cloud. Multidimensional and Tabular
• Supports Azure Data Factory
• Data Preview

With the introduction of Dynamics 365 for Finance and Operations, direct access to data is no longer an option. Instead, Dynamics 365 for Finance and Operations introduces Data Entities. Data Entities are representations of the data structure. For example the master data for a project is split into multiple tables. The Project Data Entity combines these tables, and gives a "flat" view of a project.
This is useful in many aspects of Dynamics (for example editing the Data Entity directly in Excel), but it is quite cumbersome and limiting for business intelligence developers. Even though Dynamics 365 for Finance and Operations includes more than 2000 data entities as standard, a lot of data is not represented. For BI developers, accessing data will often require a Dynamics developer and a Dynamics 365 deployment for the data to be available.
BIBuilder4Dynamics includes a unique data extractor, that can access all data in Dynamics 365 for Finance and Operations, Customer Engagement and Microsoft Dataverse. After the initial installation, there is no need to include Dynamics developers or an infrastucture specialist. A BI developer can via a point-and-click interface select from all the data in Dynamics. Even if new tables or fields are added to Dynamics, BIBuilder4Dynamics can automatically detect these and they will be available for data extraction.

BIBuilder4Dynamics creates a BI solution based 100% on Microsoft SQL Server components. At this point, BIBuilder4Dynamics can be completely uninstalled, as everything will run based on databases, SSIS packages, Analysis Services and an agent job.
It is recommended to leave BIBuilder4Dynamics installed, as it will allow for agile evolvement of your BI solution. Extending your BI Solution is very easy and quick with BIBuilder4Dynamics.