Oracle VM Consulting
view counter

Middleware Feed

Oracle Fusion Middleware, BPEL, JMS, Java EE, developer tools, integration services, business intelligence and collaboration resources, news, and support articles.

Extracting Data from BICS / Apex via RESTful Webservice

BI Cloud Service (BICS) has an API to load data into the underlying database (more details here), but reports created in BICS can not be made available and called as web-services to extract the data.  This article will document a method by which RESTful web-services can be created in Apex and exposed to replicate a BICS report, and provide access in the underlying BICS Schema Service Database.

Exalytics X5-4 Fast and Furious

I love going to KScope because I learn about new features and products. This event was no different. In the Sunday symposiums with Oracle there was a discussion on the new Exalytics X5-4. It was only Sept last year at Open World when the X4-4  was announced . Edward Roske talks about it in his Blog. It was a big deal then. With the introduction of the X5-4 only 9 months later it becomes even bigger, better and “Badder”. With the X5-4 we go to a max of 72 cores, up from 60 and more memory.

Essbase Studio patch

Well, I survived KScope. It was a very good event with participants getting over 175 sessions related to EPM/BI.  I sat in a number of sessions and was impressed with the quality of the speakers and presentations.  I also had the opportunity to speak in 4 sessions and I think they went pretty well, at least from the questions people asked.

Patch came out the other day and I read through the readme file. There were only two changes and one document change. 

Oracle BI Cloud Service (BICS) – Planned Upgrade for 10-July-2015

As from the 10th of July the Oracle BI Cloud Service environment will be upgraded. Looking forward to the new features and enhancements to the Oracle BI Cloud Service. Find below a list of things we can expect.

KScope Review

It’s been about two weeks since the KScope conference in Hollywood, FL, and our heads are still whirling with the excitement that is happening in our industry. We met so many wonderful people from all over the world and were able to connect with other like-minded individuals who want to get the most out of […]

The post KScope Review appeared first on Art of Business Intelligence Blog.

Setting up OBIEE Impersonate – BITeamwork Updating Impersonate Credentials for BITeamwork OBIEE WS Service Account

BITeamwork makes use of the OBIEE API system and web service calls for part of the functionality it delivers to empower OBIEE users. A OBIEE service account for accessing the API must be created and then using the BITeamwork control panel those credentials are securely entered and encrypted to be leveraged by BITeamwork. That credential […]

Window Functions (aka Analytic Functions) in Spark.

As of Spark 1.4.0 we now have support for window functions (aka analytic functions) in SparkSQL. At Sonra we are heavy users of SparkSQL to handle data transformations for structured data. We also use it in combination with cached RDDs and Tableau for business intelligence and visual analytics.

Spark SQL and Window Functions: The rationale

I am a strong supporter of using SQL for performing ETL and data transformations of structured data. There are several reasons for this:

Hadoop User Group Ireland Meetup (24 June 2015): An Introduction to Spark

Thanks again to everyone who attended the third Hadoop User Group Ireland meetup. Also thanks to Bank of Ireland Grand Canal Square for making the venue available. Participants in the event can send feedback to their Twitter and Facebook accounts:

Also thanks to Étienne from Idiro and Antonio from HP for their great presentations. We have all of the presentations made available for download.

Encrypting password in JBoss EAP

Copyright 2013 - http://www.

To encrypt password in Jboss using CLI, you can follow the steps below. This is particularly useful if you want to encrypt password for datasource.


1) export JBOSS_HOME=/pallavi/

2) export CLASSPATH=/pallavi/jboss-eap-6.2/modules/system/layers/base/org/picketbox/main/picketbox-4.0.19.SP2-redhat-1.jar:/pallavi/modules/system/layers/base/org/jboss/logging/main/jboss-logging-3.1.2.GA-redhat-1.jar:$CLASSPATH

3) java sa

view counter