Oracle OBIEE and ODI meet NoSQL MongoDB

Oracle OBIEE and ODI meet NoSQL MongoDB

Posted on May 29, 2015 0 Comments

Sumit Sarkar reviews his experience at Rittman Mead BI Forum 2015 and shares some tips for making sense of NoSQL data in OBIEE.

DataDirect is the leading vendor neutral vendor for data connectivity. Our goal is to connect BI developers and consultants with NoSQL data, as well as with BI and NoSQL vendors. I can't think of a better place to do this than Rittman Mead BI Forum 2015 in Atlanta. I was at the show as part of my NoSQL BI evangelism tour, and enjoyed the opportunity to to meet with Oracle analytics professionals from across the world.

I had a speaking slot at the show which I used to help attendees make sense of NoSQL data in Oracle BI Enterprise Edition (OIBEE). During the session, I covered:

  • What Oracle analytics professionals should know about NoSQL
  • How SQL on NoSQL works across OBIEE and ODI
  • Examples of enterprise reporting versus analytics use cases for NoSQL
  • "Gotchas" and lessons learned from our experience

Here’s the recap from Twitter:

The DataDirect Difference for MongoDB Explained

Below is an example of one of several thousand MongoDB documents from the database I used during my demo. This illustrates the challenge of using SQL to connect a varying number of documents with varying current and future reporting database preferences:

{
 "_id" : "5537f1a41867375916706e8d",
 "index" : 592,
 "guid" : "5b6ceafb-3743-42ef-a0a1-f815ed9cadad",
 "isActive" : true,
 "balance" : "$3,825.13",
 "picture" : "http://placehold.it/32x32",
 "age" : 20,
 "eyeColor" : "brown",
 "name" : "Stacie Lang",
 "gender" : "female",
 "company" : "ISOTRONIC",
 "email" : "stacielang@isotronic.com",
 "phone" : "+1 (983) 590-3177",
 "address" : "578 Bryant Street, Lowgap, Colorado, 6814",
 "about" : "Veniam consequat adipisicing do minim pariatur laborum sunt l
 aboris officia ad fugiat voluptate cupidatat. Consectetur nulla veniam irure des
 erunt duis in do. Eiusmod aliquip exercitation do est laboris est id Lorem non c
 upidatat occaecat cillum Lorem. Cupidatat laborum labore reprehenderit irure qui
 s aliqua quis adipisicing sit veniam incididunt dolor exercitation culpa. Culpa
 ex enim occaecat mollit laborum proident nisi sit mollit ex nisi minim ea dolor.
 \r\n",
 "registered" : "2015-04-04T22:29:02 +04:00",
 "latitude" : -11.711396,
 "longitude" : -118.650697,
 "tags" : [
 "Lorem",
 "fugiat",
 "ex",
 "ullamco",
 "excepteur",
 "laboris",
 "laboris"
 ],
 "colleagues" : [
 {
 "id" : 0,
 "name" : "Alexandria Finley",
 "reportingDBs" : [
 {
 "Current" : [
 "MySQL",
 "Microsoft Access"
 ],
 "Next" : "SQL Server"
 }
 ]
 },
 {
 "id" : 1,
 "name" : "Alyce Sweeney",
 "reportingDBs" : [
 {
 "Current" : [
 "SQL Server"
 ],
 "Next" : "PostgreSQL"
 }
 ]
 },
 {
 "id" : 2,
 "name" : "Hamilton Mercer",
 "reportingDBs" : [
 {
 "Current" : [
 "PostgreSQL"
 ],
 "Next" : "Oracle"
 }
 ]
 },
 {
 "id" : 3,
 "name" : "Harrington Meyer",
 "reportingDBs" : [
 {
 "Current" : [
 "Redis",
 "Oracle",
 "Redis"
 ],
 "Next" : "MongoDB"
 }
 ]
 }
 ],
 "greeting" : "Hello, Stacie Lang! You have 7 unread messages."
 }
Here’s what that database looks like in the OBIEE Admin tool when using Progress® DataDirect®,  the industry’s first and most reliable ODBC/JDBC connector to MongoDB supporting unlimited levels of normalization:
OBIEE-MongoDB-Normalized

Connecting to OBIEE with DataDirect drivers

And here’s what flattening JSON documents looks like. This is what competing solutions do and it's just plain UGLY.

OBIEE-MongoDB-flat

Connecting to OBIEE using other drivers

I caught the reaction to that flattened schema from BI developers.  Everyone was grateful for DataDirect!

Get started with NoSQL for OBIEE

With DataDirect drivers, using NoSQL data with OBIEE couldn't be easier. If you’re interested in connecting OBIEE, you can download our 32-bit ODBC Windows Driver for the BI Admin Tool or our 64-bit ODBC driver for the platform of choice for the BI server. If you’re interested in ODI for data integration instead, you can download our JDBC driver. For any other questions you may have, leave me a comment or give us a call to connect with a data connectivity professional today.

Also, come say "hello" to me at MongoDB World next week!

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments

Comments are disabled in preview mode.
Topics

Sitefinity Training and Certification Now Available.

Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.

Learn More
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

Loading animation