Oracle BI Suite EE Creating a Multi-Node Hadoop/Impala Cluster as a Datasource for OBIEE 11.1.1.7 The other day I posted an article on the blog about connecting OBIEE 11.1.1.7 to Cloudera Impala [http://www.rittmanmead.com/blog/2013/11/connecting-obiee-11-1-1-7-to-cloudera-impala/] , a new “in-memory” SQL engine for Hadoop that’s much faster than Hive for interactive queries. In this example, I connected OBIEE
Oracle BI Suite EE Connecting OBIEE 11.1.1.7 to Cloudera Impala A few months ago I posted a series of articles about connecting OBIEE 11.1.1.7 [http://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-1-so-what-is-hadoop-mapreduce-and-hive] , Exalytics [http://www.rittmanmead.com/blog/2013/07/accelerating-hadoophive-obiee-queries-using-exalytics-and-the-summary-advisor/] and ODI [http://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-3-a-closer-look-at-hive-hfds-and-cloudera-chd3/] to Apache Hadoop through Hive [http:
Technical Oracle Endeca Information Discovery 3.1 and Self- Service Data Mashup capability Oracle Endeca Information Discovery (OEID) 3.1 has been released yesterday, 7th of November. The new version is a good step forward to satisfy business users with providing much better self-service discovery capabilities. OEID 3.1 now enables its non-technical users to securely run agile business intelligence analysis on variety
Oracle BI Suite EE OEM12cR3: Holistic BI Platform Monitoring using Systems and Services Over the past few weeks myself and some of my colleagues have been posting articles on the blog about monitoring OBIEE using Enterprise Manager 12cR3’s BI Management Pack [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-1-introduction-to-oem12cr2/] . In the various articles we’ve looked at managing individual OBIEE installations and
Oracle BI Suite EE Monitoring OBIEE Performance for the End User with JMeter from EM12c This is the third article in my two-article set of posts (h/t [https://en.wikipedia.org/wiki/Trilogy_in_five_parts]) on extending the monitoring of OBIEE within EM12c. It comes after a brief interlude discussing Metric Extensions [https://www.rittmanmead.com/blog/2013/11/collecting-usage-tracking-data-with-metric-extensions-in-em12c/] as an alternative
Oracle BI Suite EE Collecting Usage Tracking Data with Metric Extensions in EM12c In my previous post [https://www.rittmanmead.com/blog/2013/11/building-alerts-in-em12c-with-obiee-usage-tracking-data/] I demonstrated how OBIEE’s Usage Tracking data could be monitored by EM12c through a Service Test. It was pointed out to me that an alternative for collecting the same data would be the use of EM12c’s
Technical Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 4: Initial Load and Replication This is the final post in my series on Oracle BI Apps 11.1.1.7.1 and GoldenGate Integration. If you have been following along up to this point, we have the Source Dependent Data Store schema setup and ready to accept data from the OLTP source via replication,
Technical 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 BI Suite EE Building alerts in EM12c with OBIEE Usage Tracking data Introduction Enterprise Manager 12c is the latest and greatest incarnation of Oracle’s toolset for Enterprise Management (the clue’s in the name), of which Cloud Control (neé Grid Control) is one of the key tools. It can be used for a unified overview of disparate services including servers, databases,
Technical Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 3: SDS and Parameter File Setup This is the third post in the four part series on Oracle BI Applications 11.1.1.7.1 and Oracle GoldenGate 11g. Last time, we made it through the initial setup of GoldenGate and created the necessary schemas for the Source Dependent Data Store (SDS) and GoldenGate on the
Technical My Journey to ODI 12c Most readers of this blog probably know me for my time spent with OBIEE (especially my work in repository development), but I'm guessing some of you long-time readers know that I grew up working with the Oracle Database. Many and many a year ago, I was a fledging
Technical Oracle GoldenGate 12c - New Release, New Features The latest release of Oracle's data replication tool, GoldenGate 12c, has many improvements. The release coincided with the Oracle Data Integrator 12c release [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] - and I wasn't about to let my colleague Jérôme Françoisse [https://twitter.com/JeromeFr]
Oracle BI Suite EE Rittman Mead / ODTUG India BI Masterclass Tour Roundup Over the past week Venkat, myself and the Rittman Mead India team have been running a series of BI Masterclasses [http://www.rittmanmead.com/indiabimasterclass2013/] at locations in India, in conjunction with ODTUG, the Oracle Development Tools User Group. Starting off in Bangalore, then traveling to Hyderabad and Mumbai, we
Technical Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 2: Setup and Configuration In my previous post, I introduced the steps necessary for integrating Oracle BI Applications 11.1.1.7.1 and GoldenGate (OGG). Now, I'm going to dive into the details and describe how to complete the setup and configuration of GoldenGate and the Source Dependent Data Store schema.
Technical 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
Oracle BI Suite EE OBIEE "Act As" (ActAs) vs "Impersonate" There will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside (it's
Technical Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 1: Introduction The release of Oracle Business Intelligence Applications 11.1.1.7.1 [http://www.oracle.com/technetwork/middleware/bi-applications/overview/default-458073.html] includes a major change in components, with Oracle Data Integrator replacing Informatica as the ETL application. The next logical step was to integrate Oracle’s data replication tool,
Rittman Mead Life UKOUG Apps 2013: Analytics Sponsors & Sessions The UK OUG Apps 2013 conference is a must attend for users of Oracle Applications. Held at the Brewery in London, there are three full days of content with 10 streams and over 150 speakers. Rittman Mead are proud to be the Analytics Sponsor for the event and have two
Technical Oracle Endeca Information Discovery, Text Enrichment and Customer-Defined Lists One of the data visualisations that you can use with Oracle Endeca Information Discovery is the “tag cloud”. You’ve probably seen tag clouds used in newspaper articles and other publications to show the most commonly found words or phrases in a document, the screenshot below shows a tag cloud
SampleApp v309R2 Now Available For Download on OTN The new v309R2 version of the OBIEE 11g SampleApp is now available for download on OTN [http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html] , based on the 11.1.1.7.1 version of OBIEE and with a number of new dashboards, analyses and integration examples. OBIEE 11.1.
Rittman Mead Thank You for Voting for Rittman Mead Earlier in the year I announced that we had been nominated in 5 categories [https://www.rittmanmead.com/blog/2013/09/ukoug-partner-of-the-year-2013/] for the UKOUG Partner of the Year Awards. The award ceremony was last night [http://www.ukoug.org/what-we-offer/news/press-release-uk-oracle-user-group-partner-of-the-year-2013-winners-announced/] and I’m proud to say that
Oracle BI Suite EE Tips and Tricks for the OBIEE linux sysadmin As well as industry-leading solution architecture, consultancy and training on Oracle BI, here at Rittman Mead we also provide expert services in implementation and support of such systems. In this blog I want to share some of the things I find useful when working with OBIEE on a Linux system.
Technical Interview with Stewart Bryson - Our New Chief Innovation Officer Regular readers of this blog will know Stewart Bryson, our US Managing Director and in his spare time, Oracle ACE, writer and presenter on Oracle BI &DW development topics. Those of you who've met Stewart will know that his first love has always been technology and how
Oracle BI Suite EE Openworld is Over - Now We're Coming to India..! Oracle Openworld 2013 is now over [https://www.rittmanmead.com/blog/2013/09/oracle-openworld-2013-reflections-on-product-announcements-and-strategy/] , but no sooner have we unpacked from that trip, we're packing again for our next one - our BI Masterclass Tour for India [http://www.rittmanmead.com/indiabimasterclass2013/], starting in a few week'
Oracle BI Suite EE Oracle Openworld 2013 : Reflections on Product Announcements and Strategy I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for
