Hello Tim,All of the things you have mentioned have their pros and cons.
The first question is volume how many of each entity are you looking at extracting each day as this will provide you with a good steer on what technology to use. Things like the Released products entity is a under review due to MS new stance on anti patterns so you will need to be ready to change. Also do you need to use this entity what is the actual data you want and could you use a data area id filter on another entity instead.BYOD used to be the only approach we had however now the accepted first option is to use the Azure Data Lake. This is out of the box in terms of F&O being able to carry out this function and it offers a much lower cost than BYOD. See here https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/entity-store-data-lake For the long term strategy and the likely movement to the cloud of your DW i would be recommending this approach.
If you've found this thread useful, dive deeper into User Group community content by role