Unanswered

Connect Oracle Cloud with Dataverse Virtual Tables

(0) Share

Report

Posted on by KyleSchroeder

Hello. I'm looking for assistance with connecting to an Oracle Cloud database. I'm creating a Power Pages (Portal) site where the end users would like to be able to read data from a virtual table that is connected to a table in Oracle Cloud. My first question is if this is even possible, or if there will be some reason the Power Pages users will not be able to read that data. If it is possible, will this be possible using Basic Authentication or will I need to use an API key?

Now, I've been attempting to get this connection to work by following various steps in Microsoft's documentation, but I haven't found a specific example that connects to an Oracle Cloud database. I've been trying to create a Data Provider in Dynamics 365 using OData V4 and using Basic Authentication, but I keep getting generic error messages in the Plug-In Trace Log. The main message I've been receiving is named RetrieveMultiple and the Exception Details are: "An OData error occurred. (Fault Detail is equal to Exception details". I'm guessing it might be related to the configuration Data Provider (Data Source), but it is difficult to tell. Check the screenshot below with the current configurations. If you have any experience or guidance, I would appreciate it.

Categories:

Customize & extend

I have the same question (0)

All responses (3)

Answers (0)

Sort by

KyleSchroeder on at

Like (0)

Report
Copy link

Link copied!

I have new information on this. As I thought, you cannot pass in the password and username in the Request Parameters as Query Strings. What I needed to do was add a Header with the name Authorization and where the value is "Basic [Base64 Value]". For the Base64 value, you need to combine the username and password into a single string separated by a colon (ex: MyUserName:MyPassword). After this, convert this to Base64 and add it after "Basic". I verified that this works in Postman, but I was still getting the same error message. I have learned that I need to map a value to the ID column in the virtual table from the Oracle table, however it needs to be a GUID. Unfortunately, the Oracle table does not have a GUID column. Does anyone know if there is a a workaround for this or this means I'm blocked unless the client adds a GUID column to their Oracle table?

Was this reply helpful? Yes No
Muhammad Awais 4 on at

Like (0)

Report
Copy link

Link copied!

Dears,

Did you find any solution for this. I'm also facing the same issue. I'm able to connect data in dataflows but unable to connect with virtual table. Can you guys help me for this. Thanks in advance

Was this reply helpful? Yes No
KyleSchroeder on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, I was not able to find a solution with this route. It might possible that setting up a custom data provider connection will work, but there were too many unknowns and I ran out of time. We are now moving forward with getting an XML extract from Oracle and using Power Automate to upload the data to a standard table in Dataverse.

Was this reply helpful? Yes No