We have reviewed a variety of methods to extract data from D365 FO for data warehousing. It appears there may be a lot recurring manual set up when working with multiple environments and refreshes. We have the following questions:
We require data for 70+ companies to be exported to a Azure SQL DB on a recurring basis, how can we achieve this effectively using BYOD with minimal manual intervention and configuration?
- 'All Company Export' Flighted feature – Only works for one off exports using Data Management. Manual set up 'per company' is required for recurring schedule.
- Data Task Automation – Doesn’t work for the 'All Company Export' feature or set up for Recurring Schedules. The recurring schedule is there but doesn't start at all.
- Data Management Export packages deployed from LCS – Only seems to work for import projects. Recurring schedule data not available for configuration so it has to be manual process.
- It will be a large manual task with this many companies - difficult to manage and maintain. Looking to automate as much as possible.
How can we manage configuration of BYOD data exports across multiple environments DEV/TEST/UAT/PROD?
- Recurring schedules setup doesn’t seem to be transferred between environments.
- Only solution looks to be a manual process for the recurring schedules. This will be difficult to manage and maintain through the UI.
- Can we parameterise the Azure DB connection details somehow?
Has anyone else experienced this? How did you solve these issues?
