Hello Sayanika,
So that means, I can have my D365F&O in ABC tenant and Azure Datalake in XYZ tenant. And If I want to move data from AxDW to the data lake (using full push) it is possible. Becauseit will be authenticated through App registration credentials (App ID, Secret etc).
A] The answer is Yes. If D365F&SCM resides in ABC tenant and the Data Lake resides in XYZ tenant, then
you need to do the following configurations to move the entity store data into the Data Lake.
1. Create a storage account
2. Key vault and application secret keys + App registration setup
3. Configure the System parameters in F&SCM to move data into the Azure Data lake after enabling
the data connection.
Through the above mentioned steps, the data that is refreshed in the entity store is published into the
Azure data lake. Haven't checked if it publishes data into the AxDw database too, with the System
parameters configuration for Data Lake enabled.
Similar should be applicated to any azue sql database I believe. Say if I have any azure SQL DB in PQR tenant , then, using azure data factory I can transfer the data to azure data lake which is in a separate tenant (XYZ).
A] BYOD is an independent SQL Azure database. This database can reside on an independent tenant. You can extend the Entity store capabilities further and extract data into a BYOD database.
I have not used Azure data factory to process data to and from an Azure Data lake, so not sure how it works. I have worked on setting up the Azure data lake setup with D365 F&SCM entity store.
Thanks,
Navneeth Nagrajan | Dynamics 365 Technical Consultant
