odi12c Oracle Data Integrator 12c: Getting Started - Installation and Configuration I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. This week, I’m continuing the “[Oracle Data Integrator 12c: Getting Started]( http://ritt.md/odi12c-getting-started" target="_blank)” series with the next topic: Installation and Configuration. I don’t plan to
ODVD Oracle Data Visualization Desktop: Star Schemas and Multiple Fact Sources Once added to a project, columns I specified with my custom SQL query now shows up as one source. Now that I have a custom data source with only the data I want to explore, I can easily create an analysis without having to sift through multiple data sources. ** A
Creating Security Profiles in ODI 12c As a newcomer to ODI I enjoy hearing from the more seasoned veterans about common situations they encounter on projects. One of these recurring situations (especially if the company has a very small dev team) is the lack of security. I will not discuss how Oracle improved security by usingpublic/
DVD Combining Google Analytics and JSON data through Apache Drill in Oracle Data Visualization Desktop I've been talking a lot about Oracle's Data Visualization Desktop (DVD) recently, explaining DVD 12.2.2.0 new features [https://www.rittmanmead.com/blog/2016/10/data-visualisation-desktop-12-2-2-0-new-features-2/] and the details of Data Flow [https://www.rittmanmead.
training Whatever next? The battle to keep up with changes in technology I’ve been managing Rittman Mead’s Training services in the UK & Europe for over a year now, working closely with my colleagues in the US to ensure we continue to coherently deliver expert instructor led educational courses to the very highest standards. One thing I’ve noticed is
jq Using SQL to Query JSON Files with Apache Drill I wrote recently about what Apache Drill is [https://www.rittmanmead.com/blog/2016/08/an-introduction-to-apache-drill/], and how to use it with OBIEE [https://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/]. In this post I wanted to demonstrate its great power
DVD Connecting Oracle Data Visualization Desktop to Google Analytics and Google Drive To use Data Visualisation Desktop (DVD) with data from Google Analytics or Google Drive, you need to set up the necessary credentials on Google so that DVD can connect to it. You can see a YouTube of this process on this blog here [http://oracledataviz.blogspot.co.uk/2016/10/
OBIEE12c Performing a 12c Upgrade with a New Install Software updates often include new features, and while useful, these new features are often the only driving factors in upgrading software. There's no harm in wanting to play around with the shiny new toy but many software updates also include much more significant changes, such as resolving bugs
OOW16 Oracle OpenWorld 2016 - Data Integration Recap I know it's been about a month since Oracle OpenWorld 2016 concluded, but I wanted to give a brief recap on a few things that I thought were interesting in the data integration space. During the week prior to OpenWorld, I had the privilege to attend the Oracle
ODVD Data Visualization Desktop 12.2.2.0: Data Flow Component My previous post [https://www.rittmanmead.com/blog/2016/10/data-visualisation-desktop-12-2-2-0-new-features-2/] contained a brief description of Data Visualization Desktop (DVD) new features in 12.2.2.0, in terms of sources, visualisations and components. In this post we're going
ODVD Data Visualization Desktop 12.2.2.0 Yesterday Data Visualization Desktop (DVD) Version 12.2.2.0 [http://www.oracle.com/technetwork/middleware/oracle-data-visualization/downloads/oracle-data-visualization-desktop-2938957.html] was released. DVD, since its first release, aims to extend Oracle's Data Visualization portfolio by adding a desktop tool allowing data visualization
odi OBIEE, Big Data Discovery, and ODI security updates - October 2016 Oracle release their "Critical Patch Update" (CPU) notices every quarter, bundling together details of vulnerabilities and associated patches across their entire product line. October's was released yesterday [http://www.oracle.com/technetwork/security-advisory/cpuoct2016-2881722.html], with a few entries of note in the analytics
odi12c Oracle Data Integrator 12c: Getting Started - Components and Architecture I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. I’m writing a Getting Started series to help folks get interested in the product and maybe even teach a few old dogs (including myself) some new tricks. In my [last post](GHOST_URL/2016/
elasticsearch Streaming data from Oracle using Oracle GoldenGate and Kafka Connect This article was also posted on the Confluent blog [http://www.confluent.io/blog/streaming-data-oracle-using-oracle-goldengate-kafka-connect/] , head over there for more great Kafka-related content! -------------------------------------------------------------------------------- Kafka Connect [http://docs.confluent.io/3.0.0/connect/index.html] is part of the Confluent Platform [http:
obiee OTN Appreciation Day : OBIEE's BI Server Oracle Technology Network [http://www.oracle.com/technetwork/index.html] (OTN) is one you'll be familiar with if you do anything with Oracle software, from downloading the installers [http://www.oracle.com/technetwork/indexes/downloads/index.html], reading the documentation [http://www.oracle.com/technetwork/indexes/documentation/index.
obiee OTN Appreciation Day: OBIEE's Export to Excel Functionality Only kidding…. Do you know that almost any transformation doable in excel can be achieved in OBIEE, probably faster and with zero impact on your local workstation? Image credit https://twitter.com/fomin_andrew/status/749305992198881281Why bothering downloading data to Excel when you have pivot tables, conditional formatting and a
odi12c OTN Appreciation Day: Oracle Data Integrator 12c - Flexibility As you may already know by now, it’s [OTN Appreciation Day]( https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/" target="_blank)! The idea was thought up by Oracle ACE Director Tim Hall to give thanks to the Oracle Technical Network that we all love
Conferences POUG I've just attended my first user group in Poland, the very-excellent POUG [http://poug.org/en/]. This was the first international version of the conference, having been run previously just within Poland. Based on these two days, I would say it was a resounding success! There was
odi12c Oracle Data Integrator 12c: Getting Started - What is ODI? There is something about sharing stories with others about the technology you love that gets the blood flowing. I have written blog posts and articles, presented sessions at conferences, and recorded podcasts and tech tips about [Oracle Data Integrator]( http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html
obiee All You Ever Wanted to Know About OBIEE Performance…but were too afraid to ask At the Polish Oracle Users Group (POUG) conference [http://poug.org/en/timeline/] this week I'm presenting one of my favourite talks, [Still] No Silver Bullets - OBIEE Performance in the Real World [https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world] . This
OBIA Becky's BI Apps Corner: OBIA 11.1.1.10.2 New Features Part 1 - Health Check & ETL Diagnostics I have been working with BI Applications since OBIA switched to ODI in version 11.1.1.7.0. I have installed and worked with all of the 11.x versions using several different sources. This most recent version of OBIA may only be a Patch-Set release, but it
Analysing Social Media Data for the Lightyear Foundation - Part 2 In my last post [https://www.rittmanmead.com/blog/2016/08/analysing-social-media-data-for-the-lightyear-foundation-part-1/] , I described the basics around connecting to social media data sources using Python. This is in aid of collating information for the Lightyear Foundation [http://www.lightyearfoundation.org/], a
Rittman Mead Life Rittman Mead at Oracle OpenWorld 2016 The big show is upon us and once again Rittman Mead will be actively participating at [Oracle OpenWorld 2016]( https://www.oracle.com/openworld/index.html" target="_blank). Oracle's premier conference runs September 18–22 at the Moscone Center in beautiful San Francisco, California. I'
Oracle GoldenGate Using logdump to Troubleshoot the Oracle GoldenGate for Big Data Kafka Handler Oracle GoldenGate [http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html] for Big Data (OGG BD) supports sending transactions as messages to Kafka topics, both through the native Oracle handler [http://docs.oracle.com/goldengate/bd1221/gg-bd/GADBD/GUID-2561CA12-9BAC-454B-A2E3-2D36C5C60EE5.htm#GADBD449] as well
odi12c Oracle Data Integrator: Upgrade to ODI 12c - A Case Study We don’t often get a chance to share our customer success stories due to various reasons, such as required anonymity of the client or certain other legalities. But when we do, it sure feels great! Recently, Eurocontrol [www.eurocontrol.int] , a longtime Rittman Mead client in Brussels, Belgium, performed
