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/
Technical Mobile App Designer mis-configuration error I've been doing some work recently with OBIEE's new Mobile App Designer [https://www.rittmanmead.com/blog/2013/08/a-first-look-at-the-obiee11g-mobile-app-designer/](MAD). It's a great bit of software that I'm genuinely impressed with, but it's got its little v1 quirks, and
Technical Exploring Apache Spark on the New BigDataLite 3.0 VM The latest version of Oracle’s BigDataLite VirtualBox VM [http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html] went up on OTN last week, and amongst other things it includes the latest CDH5.0 version of Cloudera Distribution including Hadoop [http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Release-Notes/
Technical The State of the OBIEE11g World as of May 2014 I’m conscious I’ve posted a lot on this blog over the past few months about hot new topics like big data, Hadoop and Oracle Advanced Analytics, and not so much about OBIEE, which traditionally has been the core of Rittman Mead’s business and what we’ve written
Technical RM BI Forum 2014 Brighton is a Wrap - Now on to Atlanta! I’m writing this sitting in my hotel room in Atlanta, having flown over from the UK on Saturday following the end of the Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014] in Brighton. I think it’s probably true to say that this year was our best
Adding Geocoding Capabilities to Pig through Custom UDFs In the previous two posts in this series, I’ve used Hive and Pig to process and analyse data from log files generated by the Rittman Mead Blog webserver. In the article on Hive [https://www.rittmanmead.com/blog/2014/04/simple-data-manipulation-and-reporting-using-hive-impala-and-cdh5/] , I created a relational table structure over a
Simple Hadoop Dataflows using Apache Pig and CDH4.6 The other day I took some logs from the Apache webserver that runs the Rittman Mead website, and analysed them using Hadoop CDH5, Apache Hive and Impala [https://www.rittmanmead.com/blog/2014/04/simple-data-manipulation-and-reporting-using-hive-impala-and-cdh5/] to get some basic metrics on number of hits per month, where the hits came
Technical New ODI12c Article, and Details of our Inaugural ODI12c Course in Brighton, May 12th-14th 2014 [http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34ba-2193422.html] Oracle have just published the May/June 2014 edition of Oracle Magazine [http://www.oracle.com/technetwork/issue-archive/2014/14-may/index.html], and my business analytics column this time round is on the new 12c release of Oracle Data Integrator.
Technical Previewing TimesTen, Endeca and Oracle DW Sessions at the Brighton BI Forum 2014 It’s under a week now to the first of the two Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014] events, with Brighton running next week at the Hotel Seattle and then Atlanta the week after, at the Renaissance Atlanta Midtown Hotel. Earlier in the week I went
Technical Extended Visualisation of OBIEE Performance Data with Grafana Recently I wrote about the new obi-metrics-agent [http://ritt.md/oma-intro] tool and how it enables easy collection of DMS data from OBIEE into whisper, the time-series based database behind graphite. In this post I’m going to show two things that take this idea further: 1. How easy it
Technical More Details on the Lars George Cloudera Hadoop Masterclass - RM BI Forum 2014, Brighton & Atlanta It’s just over a week until the first of the two Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014/] events take place in Brighton and Atlanta, and one of the highlights of the events for me will be Cloudera’s Lars George’s Hadoop Masterclass. Hadoop and
Rittman Mead Preview of the Rittman Mead BI Forum in Atlanta Mark has done a great job of previewing the upcoming content for both BI Forums, the one running locally for us in Atlanta, as well as the one in Brighton, UK. We have an exceptional Master Class this year with Lars George from Cloudera [https://twitter.com/larsgeorge], including an
Simple Data Manipulation and Reporting using Hive, Impala and CDH5 Althought I’m pretty clued-up on OBIEE, ODI, Oracle Database and so on, I’m relatively new to the worlds of Hadoop and Big Data, so most evenings and weekends I play around with Hadoop clusters on my home VMWare ESXi rig [https://www.rittmanmead.com/blog/2013/08/inside-my-home-office-development-lab-vmware-os-x-server/
Technical Previewing Three Oracle Data Visualization Sessions at the Atlanta US BI Forum 2014 Many of the sessions at the UK and US Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014/] events in May focus on the back-end of BI and data warehousing, with for example Chris Jenkins’ session on TimesTen giving us some tips and tricks from TimeTen product development, and
Technical Preview of Maria Colgan, and Andrew Bond/Stewart Bryson Sessions at RM BI Forum 2014 We’ve got a great selection of presentations at the two upcoming Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014] events in Brighton and Atlanta, including sessions on Endeca, TimesTen, OBIEE (of course), ODI, GoldenGate, Essbase and Big Data (full timetable for both events here [https://www.rittmanmead.
Technical Final Timetable and Agenda for the Brighton and Atlanta BI Forums, May 2014 It’s just a few weeks now until the Rittman Mead BI Forum 2014 events in Brighton and Atlanta, and there’s still a few spaces left at both events if you’d still like to come - check out the main BI Forum 2014 event page [http://www.rittmanmead.
Details on Two New Upcoming Courses in Brighton - Including ODI12c Just a quick note to mention two courses that are being run from our Brighton office soon, that might interested readers of the blog. Our OBIEE 11g Bootcamp course, newly updated for OBIEE 11.1.1.7, is a start-to-finish introduction to Oracle Business Intelligence Enterprise Edition 11g aimed at
Technical BI Forum 2014 preview - No Silver Bullets : OBIEE Performance in the Real World I'm honoured to have been accepted to speak at this year's Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2014/], the sixth year of this expert-level conference that draws some of the best Oracle BI/DW minds together from around the world. It's running
Technical Data Integration Tips: ODI 12c - Varchar2 (CHAR or BYTE) Continuing with our Data Integration Tips series, here's one that applies to both Oracle Data Integrator 11g and 12c. This "tip" was actually discovered as a part of a larger issue involving GoldenGate, Oracle Datapump, and ODI. Maybe a future post will dive deeper into those
Technical Visualising OBIEE DMS metrics with Graphite Assuming you have set up obi-metrics-agent and collectl as described in my previous post [https://www.rittmanmead.com/blog/2014/03/installing-obi-metrics-agent-graphite-and-collectl], you have a wealth of data at your disposal for graphing and exploring in Graphite, including: * OS (CPU, disk, network, memory) * OBIEE's metrics * Metrics about DMS
