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.