OAC Remote Data Connector with Jetty

For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. There are now 2 versions. The initial version required that a web-sever, either weblogic or tomcat, be used on premise for the tool to work.  That version is still available, […]

Direct On-Premise Database Connections for OAC DV via RDC

For other A-Team articles by Richard, click here Introduction The Remote Data Connector (RDC) allows the Oracle Analytics Cloud service to connect to on-premise data sources. In the 5.2 release of Oracle Analytics Cloud, new functionality was added that allowed Data Visualization (DV) to connect directly to on-premise databases, via the Remote Data Connector (RDC) tool, […]

A production pattern for frequent updates with PGX

Oracle’s PGX (Property Graph analytiX) is an in-memory representation of Oracle Property Graph data. Analytics against the data are parallelized and as such can be extremely fast (especially compared to typical database queries). Such powerful analytics are ideal for recommendations or real-time accept/reject financial transactions for example. A list of the built-in analytics can be […]

Leveraging Fingerprinting with WebCenter Sites

Introduction A common question asked by clients is “how do I create segments for anonymous visitors?”. While tracking anonymous visitors and calculating appropriate segments is a deep subject worthy of its own blog post (check back later!), one must first deal with “how do we uniquely identify a returning visitor who wants to remain anonymous?” […]

Oracle Business Intelligence – MDS XML in RPD

Introduction Oracle Business Intelligence (OBIEE) platform is a development framework, where multi-users can create and work on a common object model and store them into a repository (for detailed information about the repository refer to this Blog). These models form the foundation for the Business Users to create Analyses, Dashboards, Key Performance Indicators (KPIs) and […]

How to Examine the SQL in a BI Answers Report

Introduction In a standalone OBIEE environment, or within the Analytics Reporting home page of Fusion Applications, there may be occasions where it would be useful to find the SQL being generated against the underlying database by the BI Presentation Server.  This post presents one method to locate this SQL. Main Article The first step is […]

Fusion BI RPD and Webcat files

Introduction Oracle Fusion Applications have a built in Business Intelligence framework based on Oracle Business Intelligence Enterprise Edition (OBIEE). With this framework, organizations are provided with the capabilities of transforming their business process automation systems into powerful Business Intelligence systems. There are many components which constitute the Business Intelligence suite within Fusion Applications but two […]