Project Details

ERP ETL's

  • Basic Level
  • Type Fixed
  • Duration: Less than a month

Project Details

We are building a new intelligent data platform for corporate data and is looking to create a series of Azure Data Factory templates for the main Finance ERP’s. This project has two objectives: 1. To create synthesised data for the main ERP’s so that the ADF templates can be tested 2. To create a view of the mapping from the ERP to Engine B’s Data Model We want to repeat this project (if successful) for various different target ERP’s but initially we wish to focus on Microsoft Dynamics 365 for Finance and Operations. The deliverables: 1.  A CSV file of synthesised data that could have been exported from Dynamics 365 F&O 2. Data Maps for the Dynamics F&O data model to the Engine B data model. This can either be an Excel file or an Azure Data Factory Template Engine B will provide the Engine B Common Data Model. Skills required: -  ETL type skills with specific knowledge of Microsoft Dynamics 365 - Access to or ability to create synthesised MS Dynamics 365 F&O data