* This blog was last tested on Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production Version 19.11.0.0.0 by Jay Pearson (Oracle A-Team) *...
* This blog was last tested on Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production Version 19.11.0.0.0 by Jay Pearson (Oracle A-Team) * Introduction With the release of Oracle 12c Database the concept of Pluggable Databases (PDBs) was introduced. Within a Container Database (CDB) one or many of these PDBs can exist. Each PDB is a self-contained database, with its own system, sysaux and user tablespaces. Each database has its own unique service name, and...
* This blog was last tested on Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production Version 19.11.0.0.0 by Jay Pearson (Oracle A-Team) * Introduction With the release of Oracle 12c...
* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Many Cloud products such as Oracle Sales Cloud, and...
* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Many Cloud products such as Oracle Sales Cloud, and Oracle ERP Cloud come packaged with Oracle Transaction Business Intelligence (OTBI). OTBI allows users to create and run reports against both Transactional and Warehouse databases. At times there may be a need to extract that data to an external system. On-Premise customers can create ETL jobs to run against the...
* This blog was last tested on Fusion is 21A (11.13.21.01.0) by Jay Pearson (Oracle A-Team) * Introduction Many Cloud products such as Oracle Sales Cloud, and Oracle ERP Cloud come packaged with...
* 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...
