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...
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 essentially functions as a stand-alone database. Oracle's Database as a Service (DBaaS) is based on 12c, and uses the same concepts. Some applications - BI...
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...
Introduction Many Cloud products such as Oracle Sales Cloud, and Oracle ERP Cloud come packaged with Oracle Transaction Business Intelligence (OTBI). OTBI...
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 Database, but would need to figure out how everything joins together – the RPD does a great job in...
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...
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...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources to the BI Cloud Service (BICS). The tool can source from both relational data, and flat files, and it can be used for one-off loads, or in an incremental fashion to keep BICS 'in-sync' with on-premise data. This article will cover the installation and configuration steps, and then walk through the creation of data...
For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync Tool provides the ability to synchronize data from on-premise sources to the BI Cloud Service (BICS). The...
