Answered

Exporting data from a Virtual entity to Azure SQL Database using BYOD

(1) Share

Report

Posted on by Ali AbdAlNasser

Hello everyone, I hope you are all well.

I need to set up a data export process from a virtual entity to Azure SQL Database.
I have already created the Azure SQL Database and then set up authentication using /Configure entity export to database/ but when I try to search for the virtual entity I need, I can't find it in the list of entities that I can publish.
Am I on the right track or is there something wrong?

Categories:

Integration with Other Products

Customization / Solutions / SDK and API

Other Functionality

All responses (8)

Answers (1)

Ali AbdAlNasser 88 on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

Hello Mr. Andre Arnaud.

Thank you for engaging with my question, I truly appreciate it, but this is not what I was looking for.

Thank you again for giving me some of your valuable time, I appreciate it.
Ali AbdAlNasser 88 on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

Hello Mr. Martin Dráb.

Thank you for your clear answer, you answered exactly what I wanted.

I have been trying for two hours to put "Does this answer your question", but to no avail. I have tried this on more than one browser, but it seems that the problem is from Microsoft.
André Arnaud de Cal... 288,584 Super User on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

Hi Ali,

In case the list with entities is empty, you can go to the (Data management) Framework parameters form. On the tab Entity settings, click on the action button Refresh entity list. This will build up the list with data entities for your environment. Note that it runs in the background and can take 10-15 minutes to load all details.
Verified answer

Martin Dráb 225,864 Super User on at

Like (1)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

BYOD feature in F&O allow you export F&O data entities to your database. Virtual entities are something else - it's a concept of Dataverse, not F&O. While BYOD allows you to export data from F&O, it doesn't support exporting data from Dataverse. That would require a different approach.

If you your virtual entity is backed by an F&O data entity (and it supports data management), then you can export this F&O data entity (instead of the Dataverse virtual entity) to your DB through BYOD.
Ali AbdAlNasser 88 on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

Hello Mr. Andre Arnaud, I am pleased with your response to my inquiry.

In fact, I just want to make sure that extracting data from a Virtual entity is possible when using the BYOD technology, which requires Azure Database and Entity to be available. But I will explain to you what I specifically want.
I have an Azure SQL Database and I want to export some data from D365 FO to Azure SQL Database. When I searched for this matter, I came across several articles like: D365 Finance and Operations integration using BYOD

But when I tried to apply the mentioned steps, I found that I couldn't find the entity that needs to be exported. After that, I understood that there is another type of entity called Virtual entity, which made me wonder why I can find the entity normally but I can't find the Virtual entity, and this is what made me ask my question.

I want to export a Virtual entity named: InventTransBiEntity.
André Arnaud de Cal... 288,584 Super User on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD

Hi Ali,

When you talk about a Virtual entity, is your question about Dynamics 365 F&O? Can you explain what application you are using and where you are stuck?

If the question is about Dynamics 365 F&O, can you check if the entity is visible on the form Target entities?
Ali AbdAlNasser 88 on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD.

Hello Layan Jwei.
I am grateful for your interaction with me, but this is not the way I am looking for.
Layan Jwei 4,815 Super User on at

Like (0)

Report

Exporting data from a Virtual entity to Azure SQL Database using BYOD.

Hi,

Check this link

https://www.linkedin.com/pulse/exporting-data-entities-byod-feature-d365-finance-operations-kanti?utm_source=share&utm_medium=member_android&utm_campaign=share_via