Dynamics Community Forum Thread Details

Virtual table with Oracle working?

I struggled so much with virtual tables in the past (oData, Custom Plugins, etc.)

Recently I discovered that you can add a virtual table from an external source with just a few clicks in make.powerapps.com.

So I thought....

Has anybody ever managed to get a virtual table looking to an external Oracle View or table?

I managed to add an external table as a view and show lists of it in Dynamics. But opening the record in form view throws an error.
According to documentation I need a GUID column in a table in my external data. So instead of a view I tried creating a simple test table.

Integration my test table from Oracle will fail. It is not clear, how the GUID should be stored in Oracle.

When using nvarchar2(36) for the guid and storing '00000000-0000-0000-0000-000000000000', in Dynamics I get the error: "String primary key length exceeds supported 16 characters."

So this would mean to store the GUID as RAW(16) in Oracle as suggested by the Internet.

But Then I can not map the field in Virtual Table Connection Wizard. Seems like RAW(16) is not supported for mapping

Any hint on how to get virtual tables working with Oracle would be great.

Quick Links