PowerBI | Publishing ORDS API Oracle to PowerBI Service
This video illustrates the process of publishing data from an Oracle database to the Power BI service via the ORDS API.
Here's an overview:
1. Configuring the ORDS API:
The video demonstrates the use of an Oracle Virtual Box that comes with a pre-installed Oracle database, APEX, and ORDS. 0:22
First, it activates the ORDS schema. 0:37
Next, it establishes an ORDS service to make the desired data accessible (in this example, from the HR schema). 2:47
2. Verifying the ORDS API:
Postman is utilized in the video to verify the created ORDS API URL, confirming it returns the anticipated data in JSON format. 1:16
3. Bringing ORDS data into Power BI:
Within Power BI, the video demonstrates how to connect to the ORDS API URL using the "Web API" data source. 6:31
It processes the imported data by expanding rows and columns to generate a well-structured table. 7:35
4. Publishing to the Power BI Service:
In the final segment, the video illustrates how to publish the dashboard with the ORDS data to the Power BI service. 9:42
In summary, the video leads users through connecting an Oracle database to Power BI by utilizing the ORDS API to establish a web data source.