Technical Data Integration Tips: ODI - One Data Server with several Physical Schemas Yes, I'm hijacking the "Data Integration Tips" series [http://www.rittmanmead.com/tag/data-integration-tips/] of my colleague Michael Rainey [http://www.rittmanmead.com/author/michael-rainey/] (@mRainey [https://twitter.com/mRainey]) and I have no shame! DISCLAIMER This tip is intended for newcomers in the ODI world
Technical Connecting OBIEE11g on Windows to a Kerberos-Secured CDH5 Hadoop Cluster using Cloudera HiveServer2 ODBC Drivers In a few previous posts and magazine articles [http://www.oracle.com/technetwork/issue-archive/2014/14-sep/o54ba-2279189.html] I’ve covered connecting OBIEE11g to a Hadoop cluster [https://www.rittmanmead.com/blog/2014/01/obiee-11-1-1-7-cloudera-hadoop-hiveimpala-part-2-load-data-into-hivehcatalog-analyze-using-impala/] , using OBIEE 11.1.1.7 and Cloudera CDH4 and CDH5 as the examples. Things
Rittman Mead Happy Christmas from Rittman Mead, and Where To Find Us in 2015 It’s the day before Christmas Eve over in the UK, and we’re finishing up for the Christmas break and looking forward to seeing friends and family over the next few days. To all of our readers, customers, friends and partners, have a great Holiday season and New Year,
Technical TIMESTAMPS and Presentation Variables TIMESTAMPS and Presentation Variables can be some of the most useful tools a report creator can use to invent robust, repeatable reports while maximizing user flexibility. I intend to transform you into an expert with these functions and by the end of this page you will certainly be able to
OBIEE Enterprise Security The Rittman Mead Global Services team have recently been involved in a number of security architecture implementations and produced a security model which meets a diverse set of requirements. Using our experience and standards we have been able to deliver a robust model that addresses the common questions we routinely
Technical OBIEE and ODI on Hadoop : Next-Generation Initiatives To Improve Hive Performance The other week I posted a three-part series (part 1 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-1-why-mapreduce-is-only-for-batch-processing/] , part 2 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-2-introducing-apache-yarn-and-apache-tez/] and part 3 [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-3-introducing-apache-spark/] ) on going beyond MapReduce for Hadoop-based ETL, where I l
Technical Rittman Mead BI Forum 2015 Call for Papers Now Open! I’m very pleased to announce that the Call for Papers for the Rittman Mead BI Forum 2015 [https://docs.google.com/a/rittmanmead.com/forms/d/18XWPmrzr3te55rloDJyB8vFP9j8AUNKKryvOToGHBlA/viewform] is now open, with abstract submissions open to January 18th 2015. As in previous years the BI Forum will run over
Technical Rittman Mead's Bar Optimizer [http://lab.ritt.md/bar-optimizer.png] At Rittman Mead R&D, we have the privilege of solving some of our clients’ most challenging data problems. We recently built a set of customized data products that leverage the power of Oracle and Cloudera platforms and wanted to share some of
Technical Linux cluster sysadmin -- OS metric monitoring with colmux In this mini-series of blog posts I'm taking a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines. This may be a Hadoop cluster, or just a plain simple set of 'normal' machines on
Technical Linux cluster sysadmin -- Parallel command execution with PDSH In this series of blog posts I'm taking a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines easier. This may be a Hadoop cluster, or just a plain simple set of 'normal' machines
Technical Linux cluster sysadmin -- SSH keys In this short series of blog posts I'm going to take a look at a few very useful tools that can make your life as the sysadmin of a cluster of Linux machines easier. This may be a Hadoop cluster, or just a plain simple set of '
Going Beyond MapReduce for Hadoop ETL Pt.3 : Introducing Apache Spark In the first two posts in this three part series on going beyond MapReduce for Hadoop ETL, we looked at why MapReduce and Hadoop 1.0 was only really suitable for batch processing, and how the new Apache Tez framework enabled by Apache YARN on the Hadoop 2.0 platform
Technical Six Months an ACE…”Boy, that escalated quickly" Boy, that escalated quickly [http://youtu.be/FONN-0uoTHI]. I mean, my path to becoming an Oracle ACE since joining Rittman Mead! When I began with Rittman Mead back in March 2012, I wasn't planning on joining the ACE program. In fact, I really wasn't sure what
Technical Going Beyond MapReduce for Hadoop ETL Pt.2 : Introducing Apache YARN and Apache Tez In the first post [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-1-why-mapreduce-is-only-for-batch-processing/] in this three part series on going beyond MapReduce for Hadoop ETL, I looked at how a typical Apache Pig script gets compiled into a series of MapReduce jobs, and those MapReduce jobs pass data between themselves by
Technical Going Beyond MapReduce for Hadoop ETL Pt.1 : Why MapReduce Is Only for Batch Processing Over the previous few months I’ve been looking at the various ways you can load data into Hadoop, process it and then report on it using Oracle tools [https://www.rittmanmead.com/blog/2013/11/why-odi-dw-and-obiee-developers-should-be-interested-in-hadoop/] . We’ve looked at Apache Hive and how it provides a SQL layer
Private or Public Training? (and a Discount Code) Rittman Mead offers world class training [http://www.rittmanmead.com/training] that covers various Business Intelligence, Data Warehousing and Data Integration tools. Rittman Mead currently offers two types of training, Public and Private - so what is the best option for your organization? Both Private and Public options are staffed
Technical Rittman Mead Founder Member of the Red Expert Alliance At Rittman Mead we’re always keen to collaborate with our peers and partners in the Oracle industry, running events such as the BI Forum in Brighton and Atlanta each year and speaking at user groups in the UK, Europe, USA and around the world. We were pleased therefore to
Technical OBIEE SampleApp v406 Amazon EC2 AMI - available for public use I wrote a while ago about converting Oracle's superb OBIEE SampleApp from a VirtualBox image into an EC2-hosted instance [https://www.rittmanmead.com/blog/2014/09/obiee-sampleapp-in-the-cloud-importing-virtualbox-machines-to-aws-ec2/] . I'm pleased to announce that Oracle have agreed for us to make the image (AMI) on Amazon available publicly.
Technical 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
Technical Auditing OBIEE Presentation Catalog Activity with Custom Log Filters A question that I’ve noticed coming up a few times on the OBIEE OTN forums goes along the lines of “How can I find out who deleted a report from the Presentation Catalog?”. And whilst the BI Server’s Usage Tracking is superb for auditing who ran what report,
Technical Analytics with Kibana and Elasticsearch through Hadoop - part 3 - Visualising the data in Kibana In this post we will see how Kibana can be used to create visualisations over various sets of data that we have combined together. Kibana is a graphical front end for data held in ElasticSearch, which also provides the analytic capabilities. Previously we looked at where the data came from
Technical Analytics with Kibana and Elasticsearch through Hadoop - part 2 - Getting data into Elasticsearch Introduction In the first part of this series [https://www.rittmanmead.com/blog/2014/11/analytics-with-kibana-and-elasticsearch-through-hadoop-part-1-introduction/] I described how I made several sets of data relating to the Rittman Mead blog from various sources available through Hive. This included blog hits from the Apache webserver log, tweets, and metadata from
Technical Analytics with Kibana and Elasticsearch through Hadoop - part 1 - Introduction Introduction I’ve recently started learning more about the tools and technologies that fall under the loose umbrella term of Big Data [http://cdn.meme.am/instances/500x/47510205.jpg], following a lot of the blogs that Mark Rittman has written, including getting Apache log data into Hadoop [https://www.
User Groups & Conferences UKOUG Partner of the Year Awards A few days ago Rittman Mead won 5 awards at the UKOUG Partner of the Year Awards [http://www.ukoug.org/membership-new/partner-area/partner-of-the-year-awards/2014winners/] . * Business Intelligence Partner of the Year (Silver) * Training Partner of the Year (Silver) * Managed Services (Outsourcing and Operations) Partner of the Year (Silver) * Emerging (New
Technical Oracle BI Cloud Service for SaaS Application Reporting Part 1: Integrating BICS to Salesforce.com using REST APIs Last monthMark Rittman [http://www.rittmanmead.com/author/mark-rittman/]covered a series of posts detailing theOracle BI Cloud Service (BICS) [https://cloud.oracle.com/business_intelligence], aimed at departmental users who want the power of OBIEE 11g without the need to stand-up their own infrastructure. If you’re coming in
