Background This article outlines how to use a pipelined table function in Oracle Business Intelligence Cloud Service (BICS). Using a pipelined table function...
Background This article outlines how to use a pipelined table function in Oracle Business Intelligence Cloud Service (BICS). Using a pipelined table function makes it is possible to display data in BICS without having to load the data to a physical table. Two possible use cases for pipelined table functions in BICS are: 1) Drill-to-deal scenarios where data is only required momentarily and temporarily. 2) Situations where corporate security may restrict sensitive data...
Background This article outlines how to use a pipelined table function in Oracle Business Intelligence Cloud Service (BICS). Using a pipelined table function makes it is possible to display data in...
Background This article outlines how to integrate Social Relationship Management (SRM) with Oracle Business Intelligence Cloud Service (BICS). Bringing the SRM...
Background This article outlines how to integrate Social Relationship Management (SRM) with Oracle Business Intelligence Cloud Service (BICS). Bringing the SRM records into BICS enables the data consumer to refine and focus on relevant data through prompts and filters. Additionally, once in BICS, the SRM data can be mashed with complementary datasets. Three patterns are covered: (a) Managing SRM authentication, authorization, and token refresh. (b) Retrieving SRM data in...
Background This article outlines how to integrate Social Relationship Management (SRM) with Oracle Business Intelligence Cloud Service (BICS). Bringing the SRM records into BICS enables the data...
Background This article outlines how to integrate Oracle Social Data and Insight Cloud Service with Oracle Business Intelligence Cloud Service (BICS). Two...
Background This article outlines how to integrate Oracle Social Data and Insight Cloud Service with Oracle Business Intelligence Cloud Service (BICS). Two primary data movement patterns are described: (a) JSON data is retrieved from an external cloud source using REST Web Services. (b) Data is inserted into the Schema Service database with Apex PL/SQL functions. The above topics have previously been discussed in past A-Team BICS Blogs. What makes this article unique, is that...
Background This article outlines how to integrate Oracle Social Data and Insight Cloud Service with Oracle Business Intelligence Cloud Service (BICS). Two primary data movement patterns are...
Introduction This article expands on "Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) - Part 1" published in...
Introduction This article expands on "Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) - Part 1" published in June 2015. Please Note - this article is intended to provide the reader with some ideas of how to start an integration with Service Cloud. The reader would also need to consider other factors such as Limits, Fault Tolerance, Scalability, Efficiency, Latency, etc which are common with any enterprise integration. This...
Introduction This article expands on "Integrating Oracle Service Cloud (RightNow) with Oracle Business Intelligence Cloud Service (BICS) - Part 1" published in June 2015. Please Note - this article is...
Background This blog was originally published on Sept 8th, 2015 for Oracle Business Intelligence Cloud Service (BICS). It was updated on Jan 22nd, 2019 for...
Background This blog was originally published on Sept 8th, 2015 for Oracle Business Intelligence Cloud Service (BICS). It was updated on Jan 22nd, 2019 for Oracle Analytics Cloud Service (OACS). The article describes how to configure a link on a Oracle Analytics Cloud Service (OACS) Dashboard that allows a OACS consumer to execute a stored procedure from a OACS Dashboard. The sames steps can be followed for Oracle Business Intelligence Enterprise Edition (OBIEE/OBI). In the...
Background This blog was originally published on Sept 8th, 2015 for Oracle Business Intelligence Cloud Service (BICS). It was updated on Jan 22nd, 2019 for Oracle Analytics Cloud Service (OACS). The...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same functionality can be created through Apex. This article will walk through a process for creating notifications, both e-mail and SMS text message, based on a data event within BICS. The article will also demonstrate how these can be scheduled to run automatically. While written with a BICS audience in mind, it is...
Introduction Event Based notification functionality for Oracle's BI Cloud Service (BICS) will be available later this year, but until that time some of the same functionality can be created...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web customer service, self-service, knowledge management, and a host of other features. Besides its functional capabilities, OSvC provides a robust, API based integration and extension framework. In this and a few upcoming blogs we’ll focus on the Integration Framework and explore the Connect Web Services (CWSS) APIs in...
Introduction Oracle Service Cloud (henceforth referred to as OSvC) provides a complete customer service solution that offers cross-channel service delivery, web customer service,...
Background This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business...
Background This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS). The integration pattern covered shares similarities to those addressed in the previously published A-Team blog on: "Integrating Oracle Fusion Sales Cloud with Oracle Business Intelligence Cloud Service (BICS)". The motivation behind this article is to provide a fresh perspective on this subject,...
Background This article describes how to integrate Oracle Fusion Applications – WebCenter / Universal Content Management (UCM) with Oracle Business Intelligence Cloud Service (BICS). The integration...
Background This article outlines how to automate the loading of a JSON response into Oracle BI Cloud Service (BICS) via Oracle Application Express (Oracle...
Background This article outlines how to automate the loading of a JSON response into Oracle BI Cloud Service (BICS) via Oracle Application Express (Oracle Apex). The solution is PL/SQL based and can also be used for non-BICS database environments such as Oracle DbaaS and Oracle Database Schema Service. The main components of the PL/SQL code are as follows: 1) Read in the JSON response as a CLOB using the apex_web_service.make_rest_request function. 2) Convert the CLOB...
Background This article outlines how to automate the loading of a JSON response into Oracle BI Cloud Service (BICS) via Oracle Application Express (Oracle Apex). The solution is PL/SQL based and can...
