* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Oracle BI Answers, also known as 'Analyses'...
* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is part of the Oracle Transactional Business Intelligence (OTBI), and available within the Oracle Human Capital Management (HCM) product suite. This article will outline an approach in which a BI Answers report will be used to extract data from HCM via web services. This provides...
* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is...
* This blog was last tested on Taleo Build: 2020.PRD.4.0.80 Version: 20D.0.7 + Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c by Jay Pearson (Oracle A-Team)...
* This blog was last tested on Taleo Build: 2020.PRD.4.0.80 Version: 20D.0.7 + Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction This article will outline a method for extracting data from Taleo Cloud Service, and automatically loading that data into Autonomous Data Warehouse (ADW). Two tools will be used: (a) Taleo Connect Client, and (b) Oracle Analytics Cloud Data...
* This blog was last tested on Taleo Build: 2020.PRD.4.0.80 Version: 20D.0.7 + Oracle Analytics Cloud Data Sync (2.6.1) + ADW 19c by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC...
* This blog was written for the legacy/limited DBCS-Schema database. Since OAC no longer includes a Schema Service DB, it is not possible to re-test this blog...
* This blog was written for the legacy/limited DBCS-Schema database. Since OAC no longer includes a Schema Service DB, it is not possible to re-test this blog on the latest software release. This blog will remain active for customers who may still be using BICS Schema Service DB - Jay Pearson (A-Team) * Introduction This article will cover the steps to migrate the data from a BICS Schema Service Database, to a BICS DBaaS Database. Similar steps could be used to move a...
* This blog was written for the legacy/limited DBCS-Schema database. Since OAC no longer includes a Schema Service DB, it is not possible to re-test this blog on the latest software release. This blog...
* This blog was last tested on OAC 5.9 + Oracle Application Express 20.2.0.00.20 + ADW 19c by Jay Pearson (Oracle A-Team) * Introduction This article documents...
* This blog was last tested on OAC 5.9 + Oracle Application Express 20.2.0.00.20 + ADW 19c by Jay Pearson (Oracle A-Team) * Introduction This article documents a method by which RESTful web-services can be created in Oracle Application Express (APEX) and exposed to replicate the SQL from an Oracle Analytics Cloud (OAC) analysis report. Load Data OAC report has been created from this dataset. Main Article RESTful services can be created from the SQL Workshop and then...
* This blog was last tested on OAC 5.9 + Oracle Application Express 20.2.0.00.20 + ADW 19c by Jay Pearson (Oracle A-Team) * Introduction This article documents a method by which RESTful web-services...
Oracle Cloud Database Schema Service (DbCS Schema) allows developers to expose RESTful (Representational State Transfer) services in JSON (JavaScript Object...
Oracle Cloud Database Schema Service (DbCS Schema) allows developers to expose RESTful (Representational State Transfer) services in JSON (JavaScript Object Notation) format from the database. This nice feature offers an open and easy way for applications constructed using different technologies to access data in DbCS Schema. AngularJS is an open source JavaScript framework. It provides the declarative tags along with the JavaScript libraries to simplify the development of a...
Oracle Cloud Database Schema Service (DbCS Schema) allows developers to expose RESTful (Representational State Transfer) services in JSON (JavaScript Object Notation) format from the database. This...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync,...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from / to various sources. The tool can source from both relational data and flat files. It can be used for both one-off and incremental data loads. This article will cover installation and configuration steps, then walk through...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) by Jay Pearson (Oracle A-Team) * For other A-Team articles about OAC and Data Sync, click here Introduction The Data Sync Tool...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework (MAF) version 2.1. In this article we will discuss the main new features. If you are new to the AMPA, you first might want to read the introductionary "Getting Started" article. Main Article Design-Time Improvements The three wizards to create a mobile persistence layer from REST-JSON or REST-XML services, SOAP web...
Introduction The Oracle Mobile A-Team has released a new version of its free Mobile Persistence Accelerator (AMPA) for Oracle's Mobile Application Framework (MAF) version 2.1. In this article we...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to upload data, by partition or subpartition, into a partitioned table of an Oracle database. This KM...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps required to enable Oracle Partition Exchange in...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration recipe on how to use Oracle Partition Exchange with Oracle Data Integrator (ODI) to upload data very fast into partitioned tables of a large Oracle data warehouse. This article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration recipe on how to use Oracle Partition...
