Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). Part I details Using ODI to call the RESTful Service which calls the Cloud Service API and produces a file containing the JSON response. Part II details Using ODI to Load...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). Part I details Using ODI to call the RESTful Service which calls the Cloud Service API and produces a file containing the JSON response. This post details Using ODI to...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series details a method of extracting and loading data from Oracle Field Service Cloud (OFSC) into Oracle Analytics Cloud (OAC). This post details Using ODI to call the RESTful Service which calls the Cloud Service API and produces a file containing the JSON response. Part II details...
Introduction In December, 2016 Oracle announced Oracle Data Integrator (ODI) release 12.2.1.2.6 which contains significant new features including support for RESTful services. This three-part series...
Introduction This post details a method of extracting data from an Oracle Business Intelligence Enterprise Edition (OBIEE) environment that is integrated with...
Introduction This post details a method of extracting data from an Oracle Business Intelligence Enterprise Edition (OBIEE) environment that is integrated with Oracle Business Intelligence Publisher (BIP) 12c. The environment may either be Cloud-Based or On-Premise. The method utilizes the BI Publisher REST API to extract data from a BIP report. It also uses BIP parameters to filter the result set. It builds upon the A-Team post Using Oracle BI Publisher to Extract Data From...
Introduction This post details a method of extracting data from an Oracle Business Intelligence Enterprise Edition (OBIEE) environment that is integrated with Oracle Business Intelligence...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and retrieve the report, as XML, as part of the response of the SOAP call. This blog article serves as a follow on blog article providing a tutorial style walk through on how to implement the above procedure in Java. This article assumes you have already followed the steps in Richard's blog...
hljs.initHighlightingOnLoad(); Introduction In a recent article by Richard Williams on A-Team Chronicles, Richard explained how you can execute a BI publisher report from a SOAP Service and...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an Oracle Business Intelligence Cloud Service (BICS) Schema Service Database. "Oracle Data as a Service for Customer Intelligence (DaaS for CI) enables you to analyze your own unstructured text as well as public social data, so you can translate insights into actions that benefit you and your customers. DaaS for CI...
Background This article provides a set of sample code snippets for loading data from Oracle Data as a Service for Customer Intelligence (DaaS for CI) into an Oracle Business Intelligence Cloud...
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...
