Using Oracle Data Integrator (ODI) to Load BI Cloud Service (BICS)

For other A-Team articles about BICS, click here Introduction Oracle Data Integrator (ODI) is a comprehensive data integration platform that covers most data integration scenarios.  It has long been possible to use ODI to load data into BI Cloud Service (BICS) environments, that use Database as a Service (DBaaS) as the underlying database. The recent 12.2.1.2.6 release […]

BICS Data Sync – Running Post Load Procedures against a Schema Service DB

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), and other relational databases. In the recent 2.2 release of Data Sync, the functionality to run Post Session […]

BICS Data Sync – Running Post Load Procedures Against DBCS and Oracle RDBMS

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), and other relational databases. In the recent 2.2 release of Data Sync, the functionality to run Post […]

Installing Data Sync in Compute for Cloud to Cloud Loading into BICS

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into BI Cloud Service (BICS), and other relational databases.  In some use cases, both the source databases, and the target, may be in ‘the […]

Loading Data from Generic JDBC Sources into BICS

For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source.  Rather than create a single article […]

Loading SalesForce Data into BICS with Data Sync

For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released Septembert 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source.  Rather than create a single article […]

Loading Oracle Service Cloud (RightNow) Data into BICS with Data Sync

For other A-Team articles about BICS and Data Sync, click here Introduction Version 2.2 of the Data Sync tool was released September 2016 and added the ability to connect to a number of different data sources via JDBC. Setting up these Data Sources in Data Sync varies by the source.  Rather than create a single article to […]

Using SSH for Data Sync Loads to BI Cloud Service (BICS)

For other A-Team articles about BICS and Data Sync, click here Introduction The Data Sync tool can be used to load both on-premise, and cloud data sources, into BI Cloud Service (BICS).  When the target is the standard schema service database, then an HTTPS connection is used through the BICS API, and the data uploaded is […]

Configuring the Remote Data Connector (RDC) for BI Cloud Service (BICS)

For other A-Team articles about BICS and Data Sync, click here Introduction The BICS Remote Data Connector (RDC) was released in March 2016.  It allows reports and analyses in BI Cloud Service (BICS) to directly connect to an On-Premise Oracle Database.  When a report is run, a SQL request is generated by BICS and sent to […]

Using BICS Data Sync to Extract Data from Oracle OTBI, either Cloud or On-Premise

For other A-Team articles about BICS and Data Sync, click here Introduction Last year I wrote about configuring the BICS Data Sync Tool to extract data from ‘On-Premise’ data sources and to load those into BI Cloud Services (BICS).  That article can be found here. In March 2016 the Data Sync Tool added the ability to connect and […]

Setting up Oracle’s Database as a Service (DBaaS) Pluggable Databases (PDBs) to Allow Connections via SID

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 […]

Using Oracle BI Publisher to Extract Data From Oracle Sales and ERP Clouds

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 […]

Using Oracle BI Answers to Extract Data from HCM via Web Services

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. […]

Automating Data Loads from Taleo Cloud Service to BI Cloud Service (BICS)

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 […]

Copy Data from BICS Schema Service to BICS DBaaS or on On-Premise DB

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 […]

Creating Event Based E-Mail and Text Notifications for BICS using Apex

Introduction Event Based notification functionality for Oracle’s BI Cloud Service (BICS) will be available later this year, but until that time some of the same functionality can be created through Apex. This article will walk through a process for creating notifications, both e-mail and SMS text message, based on a data event within BICS.  The article […]

Extracting Data from BICS / Apex via RESTful Webservice

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 […]

“Lift and Shift” On-Premise RPD to BI Cloud Service (BICS)

For other A-Team articles about BICS and Data Sync, click here Introduction “Lift and Shift” is the method by which an On-Premise RPD, created in the BI Admin tool, can be uploaded to a BI Cloud Service (BICS) instance and made available to report authors. This cuts down on development time, allowing a single model to be […]

Configuring the Data Sync Tool for BI Cloud Service (BICS)

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 […]

Building Oracle Sales Cloud Reports with ‘Deep Link’ Capabilities

Introduction ‘Deep Links’ or ‘Direct Page Links’ allow users to directly open a specific tab or sub-tab in the Oracle Sales Cloud Simplified User Interface.  A Salesperson, for instance, could view a report that lists all of their active opportunities with a link to open the opportunity tab directly in Sales Cloud to edit it, or perhaps […]