Extracting Data from Fusion SaaS via View Objects with Data Sync

For other A-Team articles by Richard, click here Introduction The Oracle Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into Oracle Analytics Cloud Service (OAC), Oracle Autonomous Analytics Cloud Service (OAAC), and other oracle relational databases, or into Essbase. In the most recent 2.5 […]

Performing ELT Lookups with Data Sync

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), Oracle Analytics Cloud Service (OACS), and other relational databases. In the 2.3 release of Data Sync, new […]

Performing ELT Data Transformations with Data Sync

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), Oracle Analytics Cloud Service (OACS), and other relational databases. In the past, if you needed to transform the […]

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

Understanding Where to Install the ODI Standalone Agent

Introduction   With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone agent: source, target or middle tier systems? We look here at different possible architectures and provide the best choices accordingly.  Understanding Where to Install the ODI Standalone […]

Oracle GoldenGate Best Practices: Oracle GoldenGate for ETL Tools

Introduction This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool. The three different approaches that will be discussed are: Live Reporting database – The basic assumption with this approach is that there is already a Live Reporting database being maintained that can be […]