Skip to main content

Posts Tagged ‘OTBI’

Bulk user profiles from laptop

Best Practices for Oracle Fusion HCM Analytics

Oracle Fusion HCM Analytics, a part of Oracle Fusion Data Intelligence Platform (DIP) (earlier known as Fusion Analytics Warehouse), equips various management levels with deep insights to effectively manage the workforce across the organization. DIP is to the most part a ready-to-use data and analytics solution that is typically implemented in a matter of weeks. […]

Users reviewing loaded data

Data Conversions to Oracle Cloud Supply Chain Management is as easy as 1 – 2 – 3

Implementing enterprise-level software has its challenges. Traditionally, a few of the most demanding and challenging milestones of an implementation project have been the conversions and integrations. Oracle has been quite generous about open “import” interfaces in E-Business Suite (EBS). The new generation of Oracle’s enterprise software solution, Oracle Fusion, especially Oracle Cloud Supply Chain Management […]

Oracle Webinar

Seamless Integration of Oracle Fusion Apps Data with OAC Data Replication

One of the easiest and lowest maintenance approaches to feed Fusion Cloud Apps data into a data warehouse, is with Oracle Analytics Cloud (OAC) Fusion Business Intelligence Cloud Connector (BICC) Data Replication. Data Replication for Fusion Apps is a native feature of OAC Enterprise edition. If you’re migrating your on-premises application, such as E-Business Suite, […]

Istock 1255683032

5 Snags to Avoid When Modifying Seeded Oracle Fusion Reports

Oracle Cloud Applications provide many predefined reports to generate important documents necessary for running a business. These documents support internal operations, communicate with trading partners, or produce legal documentation. Still, they almost always require modifications to include company branding or rearranging and adding data elements to appear similar to legacy documents. Thoughtfully, Oracle Fusion provides […]

How to Integrate Oracle SaaS Data into Oracle Analytics Cloud?

Reporting on Oracle Fusion and non-Fusion SaaS Apps from Oracle Analytics Cloud (OAC) is a common solution to performing cross-functional reporting from one or more Cloud and non-Cloud applications. The BI capabilities within each of the transaction systems, whether Financials, HCM, Sales or other, are limited when it comes to integrated reporting with external data […]

6 Must-Attend Sessions at Collaborate 17 #C17LV

Perficient is proud to be a sponsor at Collaborate 17, which is being held April 2-6 in Las Vegas. It’s an opportunity for the Oracle user community to come together to share and learn through sessions, panels and networking events. We are honored to have been invited to present on six unique topics across multiple tracks at Collaborate and […]

Using Physical SQL (PVOs) to Extract ERP Cloud Data from OTBI

Physical SQLs are essentially the same as Logical SQLs. Behind the scenes, Logical SQLs are converted back to physical SQLs by BI server using the OTBI Fusion public view objects (PVOs) defined in the RPD physical layer. Physical SQLs leverage the same Data Sync built-in Oracle BI Connector used by logical SQLs for extracting ERP Cloud data from OTBI. The process […]

Using Logical SQL to Extract ERP Cloud Data from OTBI

This approach is officially recommended by Oracle. Data Sync comes with a built-in Oracle BI Content connector, which can be used to extract ERP Cloud data from OTBI. The connector supports three data extraction modes. SQL – used to extract data from logical SQL queries Report – used to extract data from BI analyses reports Subject Area.Table – used  for extracting […]

3 Ways to Integrate Oracle ERP Cloud (OTBI) with DataSync (BICS)

Here are the blogs that I have posted previously as part of my blog series on Oracle DataSync (BICS). Best Practice to ETL with Data Sync (BICS) In this blog, I am going to talk about three different ways to integrate Oracle ERP Cloud data with Data Sync (BICS) through OTBI.         […]

Best Practice to ETL with Data Sync (BICS)

As Oracle BI Cloud Service (BICS) starts to become popular, I am going to write a series blogs about best use of the Data Sync to upload data to BICS schema service.  In this post, I am going to share with you a best practice to use Data Sync for ETL. As an ETL tool, Data […]

Oracle BICS and Cloud (Fusion) Apps Integration Overview

Oracle provides multiple ways of reporting from Oracle Cloud (Fusion) Apps.  Oracle HCM Cloud, CX Cloud, SCM Cloud and Cloud ERP all have Oracle Transactional Business Intelligence (OTBI) built into the application.  In addition, Oracle Business Intelligence Cloud Service (BICS) can also access Oracle Cloud application data and load it into the BICS Database via Data Sync.  While […]

Oracle BICS for Salesforce, RightNow, Amazon, IBM & Big Data

Earlier this week, Oracle upgraded its BI Cloud Service platform as well as DataSync (now version 2.2) for cloud integrations. With those 2 upgrades come great benefits if you have any of the following and looking to do consolidated business analytics from multiple source systems and allow for cross-functional insights: Salesforce: There is no need […]

Load More