Query Google’s Financial Service Using Oracle Data Integrator

RESTful API is a popular protocol for exchanging data between different applications and systems especially in Web applications. Most programming languages support calling RESTful API(s) to query data quickly. Oracle Data Integrator supports RESTful services for reading and writing data.

In this tutorial, we are using Oracle Data Integrator to query data from Google Financial Service for stock prices of various companies, returning results to JSON files. Then we’ll import the JSON file into Autonomous Database. Let’s have a closer look at this process.

CodingSight - Oracle Data Integrator to query data from Google Financial Service for stock prices
Read More

How to Easily Get Data from Web Source Using Power BI Rest API Calls

Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs.

This article explains the usage of Rest API as a data source to import JSON data in Power BI from a remote location. Also, we’ll learn how to transform the imported JSON data into a tabular format. Finally, we’ll plot visualizations using the imported data.

Read More