Business Intelligence & Data Warehousing
Only Oracle delivers a complete technology foundation to reduce the cost and complexity of building and deploying enterprise business intelligence.
Configuring the Data Sync Tool for BI Cloud Service (BICS)
The Data Sync Tool provides the ability to synchronize data from on-premise sources to the Oracle 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 by solution architect Richard Williams covers the installation and configuration steps, and then walks through the creation of data loads, including load strategies, scheduling, and monitoring jobs.
posted Mon, 27 Apr 2015 17:02:16 +0000
Oracle BI Applications 11g GoldenGate Integration
Oracle ACE Michael Rainey's technical article walks you through we'll walk through the architecture and setup for using GoldenGate 11g with Oracle BI Applications 22.214.171.124.1.
posted Tue, 21 Apr 2015 20:35:26 +0000
Getting Groovy with Oracle Data Integrator
Oracle A-Team solution architect Christophe Dupupet describes how to use post migration scripts to automate massive changes to repositories after upgrading ODI or migrating from Oracle Warehouse Builder.
posted Fri, 10 Apr 2015 16:42:49 +0000
Oracle GoldenGate Best Practices: Replication between Cloud and On-Premise Environments with Oracle GoldenGate Version 12c
Oracle GoldenGate Extract, Replicat and associated utilities enable you to create, load and refresh one database to another database. Solution architect Tracy West's article addresses different approaches to extracting data from a Cloud environment and replicating it to an on-premise environment.
posted Fri, 10 Apr 2015 16:36:22 +0000
An Introduction to Analysing ODI Runtime Data Through Elasticsearch and Kibana 4
In this article Rittman Mead's Robin Moffatt shows you how can "make use of a generic method of pulling information out of an RDBMS such as Oracle and storing it in Elasticsearch, from where it can be explored and analysed through Kibana."
posted Thu, 12 Mar 2015 18:02:05 +0000
Why and How to use Oracle Metadata Management 12c. Part 2: Importing and Relating Metadata
In this second article in her series, Oracle ACE Edelweiss Kammermann shows you how to import metadata into OEMM from Oracle Database, OBIEE, ODI and OWB and other sources, and then relate all of them inside OEMM.
posted Tue, 10 Mar 2015 16:06:02 +0000