Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Dynamics 365 general forum / Virtual Entity with no...
Dynamics 365 general forum

Virtual Entity with no GUID in source

(0) ShareShare
ReportReport
Posted on by Peragin 135

Hi all,

We want to create a virtual entity to link data from our legacy transaction system that sits on an oracle database. Naturally, the legacy system doesn't provide an odata end point so we are thinking of creating one with WCF. The OData endpoint would sit on a server between D365 and our oracle db as it's not on the web. I have a few questions:

1) Has anyone successfully created a VE via OData 4 to an oracle database? 

2) I've read that a GUID is mandatory in the source data, then I've read in other places that it is not, the only difference is that if one is provided then you can switch on activities for the virtual entity.

3) If one wants to create a relationship/lookup from the contact to the VE, then I assume you would need to include the contact guid in the entity.

I get the feeling that it is not going to be easy to hook this together.

Thanks in advance for any help.

Categories:
Integration with Other Products
Customization / Solutions / SDK and API
Other Functionality
  • Jevon Hills Profile Picture
    Jevon Hills 10 on at
    RE: Virtual Entity with no GUID in source

    I'm following this conversation as I'm attempting to setup VE on top of Oracle as well.  Were you able to solve this?  If so would you mind sharing how you did it?

  • Peragin Profile Picture
    Peragin 135 on at
    RE: Virtual Entity with no GUID in source

    Thanks Andrew,

    Sorry for the late response, I will try these suggestions over the coming weeks and report back here.

    Regards

  • Verified answer
    a33ik Profile Picture
    a33ik 84,327 Most Valuable Professional on at
    RE: Virtual Entity with no GUID in source

    Hello,

    1. I haven't done that personally but looks like doable.

    2. Guid for PK is mandatory. I had similar question when I had an int as PK and I found following neat workaround - stackoverflow.com/.../convert-int-to-guid.

    3. I haven't done that - id reversed thing - I had lookup on the VE that pointed to account and contact and I had to lookup record from CRM based on the data from external system to make it work.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,927 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,793 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans