Integration of external data

Join all data sources (Microsoft Dynamics + any other) across your organization into BI4Dynamics Data Warehouse. Have full control of external data quality and save cost by engaging your internal resources.

Part 1: Get data from external sources into BI4Dynamics data warehouse database (80% of effort).

Create an SSIS package with SQL Server Data tools (free Microsoft) with simple Import-Export Wizard to cover almost all import-export scenarios from any data source into BI4Dynamics SQL database.

Part 2: Create new BI structures with the Data Warehouse Automation Wizard (20% of effort).

Creating transactional tables (facts), lookup tables (dimensions) and cubes with our Data Warehouse Automation Wizard is straightforward. Click to see how: D365 (AX) or BC (NAV.

Watch videos to see how to prepare and include SSIS packages to BI4Dynamics or download the document