Posts Tagged ‘BICS’

Now that we have three different approaches to extract Oracle ERP Cloud data from OTBI, there comes the question – what’s the best practice, or which one should you recommend? Before answering the question, let’s take a look at the feature list of each approach so we can understand what they are best at. Feature List […]

Custom SQLs work differently than logical and physical SQLs.  Instead of going through the OBTI subject areas and the Fusion PVOs in the RPD physical layer, custom SQLs are used to create custom data models in BI Publisher to extract ERP Cloud data directly from the Fusion database tables.  The built-in Data Sync Oracle BI Connector does not support […]

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

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

Recently I led a comprehensive analysis and POC for lift and shift of on-premises 11g to Oracle BI Cloud Service (BICS). The lift and shift approach is gaining popularity as it offers a hybrid BI Cloud without having to worry about data security and recreating metadata in the cloud. BICS can leverage the on-premises repository […]

If you ever had a requirement or thought of creating an analysis report in BICS to display report columns dynamically, but later had to give it up due to the complexity, you might find this blog post is what you’ve been waiting for. I am going to show you how easily such a report can be created […]

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

In this blog, I will finish the Best Practice to ETL with Data Sync (BICS) post by showing you how to configure the Data Sync to load data in staging database. First, set up a new database connection in Data Sync for SQL Server or Oracle database. For SQL Server > Set Connection Type to MSSQL > Fill in the rest […]

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

As businesses expand into new areas of marketing they’re adopting hybrid applications, both on-premises and cloud, to support their growing needs. But multiple applications silo customer information across the business, limiting a 360-degree view of the customer and the ability to analyze different marketing initiatives. Join us for this encore presentation delivered at Oracle OpenWorld […]

Cloud implementations bring a new set of challenges due to the fundamental difference in how applications and their supporting infrastructure are delivered and managed. It should be noted that none of these challenges should be seen as a reason to delay moving an application to the cloud. Instead, you should embrace the challenges and understand […]

For companies that are happy with their on-premise data warehouse there is a fear of having to create a new data warehouse when migrating to the cloud.  Luckily for Oracle BI Cloud Service customers there are two excellent ways to avoid having to redo your warehouse.  The first method is using Oracle BICS Data Sync to do […]