Introduction Oracle BI Answers, also known as 'Analyses' or 'Analysis Editor', is a reporting tool that is part of the Oracle Transactional Business...
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 an alternative method to the file based loader process (details of which can be found here)...
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...
For other A-Team articles about BICS and Data Sync, click here Introduction This article will outline a method for extracting data from Taleo Cloud Service, and...
For other A-Team articles about BICS 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 BI Cloud Service (BICS). Two tools will be used, the Taleo Connect Client, and the BICS Data Sync Utility. The Taleo Connect Client will be configured to extract data in CSV format from Taleo, and save that in a local directory. The Data Sync tool will monitor that local...
For other A-Team articles about BICS 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 BI...
Introduction Oracle customers use Java Message Service (JMS) queues with Oracle Data Integrator (ODI) to consume, transform, and publish millions of JMS...
Introduction Oracle customers use Java Message Service (JMS) queues with Oracle Data Integrator (ODI) to consume, transform, and publish millions of JMS messages every day. A new Oracle white paper called “Using JMS Queues with Oracle Data Integrator (ODI)” illustrates, step-by-step, how to use JMS queues with ODI. This white paper uses the airline industry as an example. Figure 1 illustrates the use-case presented in this white paper: Figure 1 - Using JMS Queues with...
Introduction Oracle customers use Java Message Service (JMS) queues with Oracle Data Integrator (ODI) to consume, transform, and publish millions of JMS messages every day. A new Oracle white...
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...
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 database from BICS to on-premise, or from on-premise to a BICS DBaaS instance. The process involves creating a DMP file in BICS that is then downloaded and moved to the BICS DBaaS instance, and then imported with the DATAPUMP tool. This has the advantage of not only copying all tables and their data, but also...
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 database from BICS...
Introduction BI Cloud Service (BICS) has an API to load data into the underlying database (more details here), but reports created in BICS can not be made...
Introduction BI Cloud Service (BICS) has an API to load data into the underlying database (more details here), but reports created in BICS can not be made available and called as web-services to extract the data. This article will document a method by which RESTful web-services can be created in Apex and exposed to replicate a BICS report, and provide access in the underlying BICS Schema Service Database. Main Article RESTful services can be created from the Service...
Introduction BI Cloud Service (BICS) has an API to load data into the underlying database (more details here), but reports created in BICS can not be made available and called as 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...
Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI...
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 supports three partitioning strategies: range, hash, and list. Single-level partitioning and composite...
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...