Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided...
Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided uses the REST API for Oracle Sales Cloud to create a new OSC contact from DbaaS. The PL/SQL uses UTL_HTTP commands to call the REST API for Oracle Sales Cloud. A sample use case for this code snippet could be: Displaying a list of contacts in an Oracle or an external application. Then allowing the application consumer...
Background This article describes how to integrate Oracle Sales Cloud (OCS) with Oracle Database as a Service (DBaaS) using PL/SQL. The code snippet provided uses the REST API for Oracle Sales Cloud...
Background This article provides a fresh approach on the subject of integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS)....
Background This article provides a fresh approach on the subject of integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS). Integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS) - Part 1, showcased how to use Oracle Transactional Business Intelligence (OTBI) to extract data from Sales Cloud and load it into BICS. This article tackles the reverse data movement pattern - loading data from a BICS dashboard into...
Background This article provides a fresh approach on the subject of integrating Oracle Sales Cloud with Oracle Business Intelligence Cloud Service (BICS). Integrating Oracle Sales Cloud with Oracle...
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,...
