Author: Arun Raj
-
Apache Hive Deep Dive – Load Data from Local File System
Welcome to the first post of the series called “Apache Hive Deep Dive”. In this post we are going to explore what happens behind the scenes in HDFS when we issue the following commands in Hive: CREATE DATABASE CREATE TABLE LOAD DATA DROP TABLE DROP DATABASE In this exercise, the data will be loaded from the local file…
-
Introduction To Apache Hive For SQL Programmers
I have always wondered how someone with SQL knowledge can work in a Big Data environment or to be more precise, in an HDFS environment. Can we use our SQL skills to analyze data? Do we have to learn Java or Map Reduce to do the analysis? After a few years of questioning, I thought of…
-
PBCS REST APIs Using Groovy Scripts
In this post we will try to cover the basics of using PBCS / EPBCS REST APIs using Groovy Scripts. Most of you may have used EPM Automate utility in your day to day activities. Although it is a great tool, it has its limitations. So lets see how we can use PBCS REST APIs.…
-
Test PBCS REST APIs Using SOAPUI
In this post, we will take a look at how to test Oracle Planning and Budgeting Cloud Service (PBCS) REST APIs using SoapUI. In the example below, we will test the List Files REST API. For more details on the APIs, check out the Oracle Help Center: REST API for Oracle Enterprise Performance Management Cloud.…
-
Load Adjustment Period Data from GL to EPBCS Financial Module
If you are using EPBCS, there is direct integration between EPBCS Finance module and Oracle Cloud General Ledger Module. The integration helps you to load Actual data from GL to EPBCS. In this post we will look at how we can load the Adjustment Period data from GL to EPBCS. I am assuming you have…