Oracle Enterprise Data Quality Revisited

Monday, March 10th, 2014 by

Recently I have be working with Oracle Enterprise Data Quality (EDQ) combined with Oracle Data Integrator (ODI), we will tell you more about exactly what we have been doing in another blog, but for now I would like to revisit our earlier EDQ blogs. I am going to keep to the batch ETL paradigm and […]

Thoughts on Using Amazon Redshift as a Replacement for an Oracle Data Warehouse

Thursday, February 20th, 2014 by

Recently, my colleague, Pete Carpenter, described a proof of concept we carried out using Amazon Redshift as the data warehouse storage layer in a system capturing data from Oracle E-Business Suite (EBS) using Attunity CloudBeam in conjunction with Oracle Data Integrator (ODI) for specialised ETL processing and Oracle Business Intelligence (OBI) as the reporting tool. […]

Using Oracle TimesTen With Oracle BI Applications (Part 3)

Thursday, July 4th, 2013 by

In part 2 I introduced TimesTen Columnar Compression and explained that it creates-column value look up tables so a longer data value can be replaced with a short token. If we take a traditional Fact table we have a set of (usually) integer keys and some measures (again most likely numeric). Replace a 2 or […]

Using Oracle TimesTen With Oracle BI Applications (Part 2)

Thursday, June 27th, 2013 by

Last time I posted an introductory blog to this series of posts on using Oracle TimesTen with Oracle BI Applications (OBIA). Today, I am going to look at some of the OBIA structures and then start to explore the ways we can use TimesTen with OIBA. As TimesTen may be a new topic for some […]

Using Oracle TimesTen With Oracle BI Applications (Part 1)

Monday, June 24th, 2013 by

Oracle BI Applications (OBIA) is a product for delivering industry best-practice dashboards and analysis over enterprise sources such as ERP, HR, SCM and CRM systems. OBIA includes the necessary functionality to extract data from the source systems, transform and load it to the target database’s standardised data model and to provide a web-based analytic platform over […]

Website Design & Build: tymedia.co.uk