Technical GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 3: Setup Journalizing After a short vacation, some exciting news [https://twitter.com/oracleace/status/476771642883203073], and a busy few weeks (including KScope14 in Seattle, WA [https://www.rittmanmead.com/blog/2014/06/rittman-mead-at-odtug-kscope14-seattle/]), it's time to get the "GoldenGate and Oracle Data Integrator - A Perfect Match in 12c&
Technical Going Beyond the Summary Advisor with TimesTen for Exalytics I’m over in Seattle at the moment for ODTUG KScope’14 [http://kscope14.com], and one of the topics I’m presenting on this week is the use of TimesTen with OBIEE; what I’m going to talk about is taking TimesTen beyond its current use as an in-memory
Rittman Mead Rittman Mead at ODTUG KScope'14, Seattle Next week is ODTUG KScope’14 [http://kscope14.com] in Seattle, USA, and Rittman Mead will be delivering a number of presentations over the week. Coming over from Europe we have Jérôme Françoisse and myself, and we’ll be joined by Michael Rainey, Daniel Adams, Charles Elliott from Rittman Mead
Technical SampleApp v406 - Automatic startup of OBIEE Last week Oracle released v406 of SampleApp [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] . SampleApp is a one-stop-shop for a demonstration of pretty much any conceivable thing that OBIEE is capable of, and then some more on top of it. It is a VirtualBox [https://www.virtualbox.org/
Technical Introducing the Updated Oracle / Rittman Mead Information Management Reference Architecture Pt2. - Delivering the Data Factory In my previous post on our updated Oracle Information Management Reference Architecture [https://www.rittmanmead.com/blog/2014/06/introducing-the-updated-oracle-rittman-mead-information-management-reference-architecture-pt1-information-architecture-and-the-data-factory/] , jointly-developed with Oracle’s Enterprise Architecture team, we went through a conceptual and logical view of the information architecture, introducing new concepts like the Raw Data Reservoir, the Data Factory
Technical 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
Technical End-to-End ODI12c ETL on Oracle Big Data Appliance Pt.5 : Bulk Unload to Oracle All week I’ve been looking at what’s involved in moving data around Hadoop on the Oracle Big Data Appliance, using ODI12c to orchestrate the end-to-end process. Using web log data from the Rittman Mead website, I first landed the log data on HDFS using Apache Flume, then transformed
Technical End-to-End ODI12c ETL on Oracle Big Data Appliance Pt.4 : Transforming Data using Python & Hive Streaming This week I’m taking an in-depth look at ETL on the Oracle Big Data Appliance, using Oracle Data Integrator 12c to call the various bits of Hadoop functionality and orchestrate the whole process. So far, I’ve landed web log data into the Hadoop cluster using Flume, created a
Technical End-to-End ODI12c ETL on Oracle Big Data Appliance Pt.3 : Enhance with Oracle Reference Data via Sqoop, and CKMs In the first two posts in this series, I used the software on the Oracle Big Data Appliance 3.0 to ingest web log data from the Rittman Mead blog server, parse and load that data into a Hive table, and then join that table to another to add details
Technical The BI Survey 14 - Have Your Voice Heard! Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed
Technical 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
Technical End-to-End ODI12c ETL on Oracle Big Data Appliance Pt.2 : Hive Table Joins, Aggregation and Loading In this series of posts, I’m going to be looking at an end-to-end ETL process on Oracle Big Data Appliance, using Hadoop technologies to do the data manipulation and Oracle Data Integrator 12c to orchestrate the process. Over the five posts, I’ll be landing web server log data
End-to-End ODI12c ETL on Oracle Big Data Appliance Pt.1 : Flume to Initial Hive Table A few months ago I posted an article on the ODI12c examples in the new Oracle Big Data Appliance, and over the past few weeks I’ve been writing about the various components within the Cloudera CDH Hadoop stack [https://www.rittmanmead.com/blog/2014/05/list-of-our-recent-getting-started-hadoop-articles/], including Hive, Pig,
Technical Rittman Mead at the Oracle Virtual Technology Summit 2014 - "The Architecture of Analytics: Big Time Big Data and Business Intelligence" I’m pleased to announce that I’ll be presenting at the Oracle Technology Network (OTN) Virtual Technology Summit [http://event.on24.com/r.htm?e=796788&s=1&k=4A8AB16195363690B31C6F19FED113DF&partnerref=americasace] , an online event running over three days in early July. I’m speaking as
Goodbye to Stewart... We’re sad to announce that Stewart Bryson’s last day with Rittman Mead was last Friday, and he’s moving-on now to a new challenge. Five years ago Stewart co-founded Rittman Mead America with us, and most recently he’s been our Chief Innovation Officer, handing over the day-to-day
Technical Data Integration Tips: GoldenGate on RAC - Action Script for Windows I want to briefly interrupt my blog series on GoldenGate and ODI - A Perfect Match in 12c... [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] to provide another Data Integration Tip that was found during a recent client engagement. I was tasked with installing GoldenGate 11g into a 2-node
Technical Rittman Mead Announce New Partnerships with Cloudera and Amazon Web Services To complement our strategic partnership with Oracle Corporation, Rittman Mead are very pleased to announce two new technology partnerships to complement our Oracle-based services; with Cloudera [http://www.cloudera.com/content/cloudera/en/home.html], the industry-leading Hadoop software vendor, and with Amazon Web Services [http://aws.amazon.com], the
Technical GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 2: Journalizing Knowledge Module This is the second post in a blog series on the integration between Oracle Data Integrator (ODI) 12c and GoldenGate 12c. Thefirst post [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] focused on the latest, yet-to-be-released, Oracle Information Management Reference Architecture and some high-level features new to the 12c versions
Technical 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
Technical GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 1: Getting Started Over the years, I've blogged quite a bit about integration between Oracle Data Integrator and GoldenGate, and how to make it all work with the Oracle Reference Architecture. With the release of the 12c versions of ODI [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] and GoldenGate [https:
Technical Visual Regression Testing of OBIEE with PhantomCSS Earlier this year I wrote a couple of blogs posts (here [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction/] and here [https://www.rittmanmead.com/blog/2014/01/automated-regression-testing-for-obiee/]) discussing the topic of automated Regression Testing and OBIEE. One of the points that I was keen make was that OBIEE
Technical Trickle-Feeding Log Data into the HBase NoSQL Database using Flume The other day I posted an article on the blog around using Flume to transport Apache web log entries from our website into Hadoop [https://www.rittmanmead.com/blog/2014/05/trickle-feeding-webserver-log-files-to-hdfs-using-apache-flume/] , with the final destination for the entries being an HDFS file - with the HDFS file essentially mirroring
Technical Photos and Presentation Downloads from the Rittman Mead BI Forum 2014 Well we’re back in Brighton, UK now after the second successful week of the Rittman Mead BI Forum 2014. In Week 1, we went to the Seattle Hotel in Brighton (read the recap here [https://www.rittmanmead.com/blog/2014/05/rm-bi-forum-2014-brighton-is-a-wrap-now-on-to-atlanta/]), and then straight-after we flew over to
Technical List of our Recent "Getting Started" Hadoop Articles We’ve published a number of “getting started with Hadoop” articles over the past few months, but these aren’t always easy to find on the blog. I’ve therefore compiled a list of the more recent ones, which you’ll find below: * OBIEE, ODI and Hadoop Part 1: So
Technical Trickle-Feeding Log Files to HDFS using Apache Flume In some previous articles on the blog I’ve analysed Apache webserver log files sitting on a Hadoop cluster using Hive [https://www.rittmanmead.com/blog/2014/04/simple-data-manipulation-and-reporting-using-hive-impala-and-cdh5/] , Pig [https://www.rittmanmead.com/blog/2014/05/simple-hadoop-dataflows-using-apache-pig-and-cdh4-6/] and most recently, Apache Spark [https://www.rittmanmead.com/blog/2014/05/
