Integration of external data

Join all data sources (Microsoft Dynamics + any other) across your organisation 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 NAV.

Integration of external data

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

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