Rittman Mead Blog - Data Warehousing

Tagged

Data Warehousing

A collection of 205 posts

Rittman Mead at Collaborate 16: Data Integration Focus

It’s that time of year again when Oracle technologists from around the world gather in Las Vegas, Nevada, to teach, learn, and, of course, network with their peers. TheCollaborate 16 [http://collaborate.ioug.org/]conference, running for 10 years now, has been a collaboration, if you will, between the

Becky's BI Apps Corner: Incrementals and Future Dated Employee Records

Becky's BI Apps Corner: Incrementals and Future Dated Employee Records

During the last few posts, we have delved into a few of the many interesting aspects of a BI Apps installation. Today I wanted to change gears a bit and talk about what starts to happen when you are past installation and configuration and begin running load plans. On a

Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table

Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table

Well, it’s been awhile since I’ve posted one of our Rittman Mead Data Integration Tips, so I thought a recent challenge might be the next great candidate. I was working through the Kimball ETL Subsystems [http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/etl-architecture-34-subsystems/] and the Error Event Schema, Subsystem

Becky’s BI Apps Corner: OBIA install Perl Script Patching and troubleshooting when they fail

Becky’s BI Apps Corner: OBIA install Perl Script Patching and troubleshooting when they fail

During a recent project installing Oracle BI Applications, I became much better acquainted with OPatch, Oracle’s standard tool for managing application patches. By acquainted, I mean how to troubleshoot when OPatch patching fails. Since, at last count, there are around 50 patches total for Oracle BI Applications 11.1.

Becky’s BI Apps Corner: Installing on Windows Server 2012

Becky’s BI Apps Corner: Installing on Windows Server 2012

Recently I was installing Oracle BI Apps on a VM for a custom training, as mentioned in a previous post [http://wp.me/p6Tisj-6jR]. I setup the VM with Windows Server 2012 after verifying in the certification matrix [http://www.oracle.com/technetwork/middleware/bi/biapps-11-1-1-9-2-2527682.xls] that the Oracle

Kickstart Your 2016 with Rittman Mead's Data Integration Training

Happy Holidays and a Happy New Year to all! As you begin your 2016 this January, it’s time to start planning your team's data integration training. Look no further than Rittman Mead’s Oracle Data Integrator training course! We offer a 4 day Oracle Data Integrator 12c

Driving OBIEE User Engagement with Enhanced Usage Tracking for OBIEE

Driving OBIEE User Engagement with Enhanced Usage Tracking for OBIEE

Measuring and monitoring user interactions and behaviour with OBIEE is a key part of Rittman Mead’s User Engagement Service [http://ritt.md/ue]. By understanding and proving how users are engaging the system we can improve the experience for the user, driving up usage and ensuring maximum value for

Oracle OpenWorld 2015 Roundup Part 3 : Oracle 12cR2 Database Sharding, Analytic Views and Essbase 12c

Oracle OpenWorld 2015 Roundup Part 3 : Oracle 12cR2 Database Sharding, Analytic Views and Essbase 12c

With the UKOUG conference starting tomorrow I thought it about time I finished off my three-part post-OOW 2015 blog series, with a final post on some interesting announcements around Oracle Database and Essbase. As a reminder the other two posts were on OBIEE12c and the new Data Visualisation Cloud Service

Forays into Kafka - Enabling Flexible Data Pipelines

Forays into Kafka - Enabling Flexible Data Pipelines

One of the defining features of “Big Data” from a technologist’s point of view is the sheer number of tools and permutations at one’s disposal. Do you go Flume or Logstash? Avro or Thrift? Pig or Spark? Foo or Bar? (I made that last one up). This wealth

Introducing the Rittman Mead OBIEE Performance Analytics Service

Introducing the Rittman Mead OBIEE Performance Analytics Service

Fix Your OBIEE Performance Problems Today OBIEE is a powerful analytics tool that enables your users to make the most of the data in your organisation. Ensuring that expected response times are met is key to driving user uptake and successful user engagement with OBIEE. Rittman Mead can help diagnose

Realtime BI Show with Kevin and Stewart - BI Forum 2015 Special!

Jordan Meyer and I were very pleased to be invited onto the Realtime BI Show podcast last week, run by Kevin McGinley and Stewart Bryson, to talk about the upcoming Rittman Mead BI Forum running in Brighton and Atlanta in May 2015 [http://www.rittmanmead.com/biforum2015]. Stewart and Kevin

Rittman Mead anuncia su catálogo de cursos en Español y en Portugués.

[https://www.rittmanmead.com/blog/content/images/2016/05/07698Spanish_Portuguese_Training.png] [http://www.rittmanmead.com/rittman-mead-announces-its-training-catalog-in-spanish-and-portuguese/] [http://www.rittmanmead.com/rittman-mead-anuncia-o-seu-catalogo-de-cursos-em-espanhol-e-em-portugues/] Tenemos el agrado de anunciarles que desde ahora Rittman Mead ofrece su catálogo completo de cursos en Español y en Portugués. Esta es una gran noticia para

Oracle 12.1.0.2 and Data Warehouses

If you follow Blogs and Tweets from the Oracle community you won’t have missed hearing about the recent release of the first patch-set for Oracle 12c. With this release there are some significant pieces of new functionality that will be of interest to Data Warehouse DBAs and architects. The

Introducing the Updated Oracle / Rittman Mead Information Management Reference Architecture Pt1. - Information Architecture and the "Data Factory"

One of the things at Rittman Mead that we’re really interested in, is the architecture of “information management” systems and how these change over time as thinking, and product capabilities, evolve. In fact we often collaborate with the Enterprise Architecture team within Oracle, giving input into the architecture designs

Rittman Mead Featured in Oracle In-Memory Option Launch

Today saw the official launch of the Oracle Database In-Memory Option [http://www.oracle.com/us/corporate/events/dbim/index.html], with Larry Ellison going through the product features and then reading out some quotes and testimonials from beta testers. Rittman Mead were part of the beta testing program, with

How We Deliver Agile OBIEE Projects - Introducing ExtremeBI

Most OBIEE projects that we see are delivered through some sort of “waterfall” method, where requirements are defined up-front, there’s several stages of development, one or more major releases at the end, and any revision to requirements takes the form of a change request. These work well where requirements

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Abstract Scoring Now Live - For 1 Week Only!

The call for papers for the Rittman Mead BI Forum 2014 closed at the end of January, and we’ve had some excellent submissions on topics ranging from OBIEE, Visualizations and data discovery through to in-memory analytics, big data and data integration. As always, we’re now opening up the

Oracle Data Integrator 12c release : Part 2

In the first part of this article [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1], we discovered the new mappings and reusable mappings, the debugger and the support of OWB jobs in the freshly released ODI 12c. Let's continue to cover the new features in ODI 12c with

Oracle Data Integrator 12c release : Part 1

That's it! The long awaited Oracle Data Integrator 12c is out! You can find the 12.1.2 version on the ODI Downloads [http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html] page and discover the new features here while it gets downloaded. The main news is

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 3: Real-time ETL Challenges

I've finally had the chance to sit down and properly closeout this series on GoldenGate and Oracle Data Integrator. Since the last post, I’ve actually presented this topic on three different occasions. Once at each of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/2013/

Oracle Database 12cR1 - New Features for BI & DW

Oracle Database 12c Release 1 [http://www.oracle.com/us/corporate/press/1967380] came out last week, initially available for 64-bit Linux and Solaris (SPARC and x86_64), with the Windows and other versions presumably due over the next few months. So what's in this new release for