September 30, 2016

|

by: pete.scott

|

Categories: Big Data, ODI, Snowflake

One of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available). […]

September 29, 2016

|

by: Mike Fuller

|

Categories: OBIEE, Snowflake, SQL

Employees at the Minneapolis Red Pill Analytics office recently had the luxury of sitting with Snowflake’s Steve Herskovitz for some on-site education. Among other things, one of my key takeaways from the exercise was how simple it is to query JSON data in the Snowflake Data Warehouse. The syntax is straightforward and makes the process […]

September 26, 2016

|

by: Kathryn Watson

|

Categories: Events

This past week, I had the honor of not only attending, but speaking at Oracle Open World 2016. After a decade of working with Oracle technologies in the data integration, BI & analytics, and big data domains, attending and speaking at this event marked a much-anticipated career milestone on my end. With >60,000 attendees and […]

August 31, 2016

|

by: Phil Goerdt

|

Categories: OBIEE, Snowflake

In my last post, I discussed Snowflake’s unique cloud offering, and how to get it connected to OBIEE. In this post, I’ll give a brief overview of what Snowflake’s Time Travel feature is, how to use it from a query perspective, and how to integrate this feature into OBIEE. [pexyoutube pex_attr_src=”https://www.youtube.com/watch?v=fCjsUxbNmIs”][/pexyoutube]Where We’re Going… We Don’t Need […]

August 26, 2016

|

by: Stewart Bryson

|

Categories: OBIEE, Oracle 12c

If you’ve followed me for any length of time, you know I’m a fan of the Groovy language. It’s unfettered support for closures has made it a popular choice for writing domain-specific language (DSL) projects such as Gradle and Jenkins, and the healthy dose of syntactic sugar spooned in at runtime means that developers spend less time boiler-plating and more time […]

June 24, 2016

|

by: Michelle Kolbe

|

Categories: Code, Data Science, R, Twitter

This is a topic that I was teaching about last night in my Digital Analytics class at the University of Utah and instead of only sharing what I found with my students, I thought I’d share here in the blogosphere. What I’ve found was yes it’s easy to pull Twitter posts into R for analysis! […]

June 16, 2016

|

by: Phil Goerdt

|

Categories: OBIEE

If you’re reading this post, you’ve probably seen my other post on connecting OBIEE to Amazon Web Services’ Redshift database offering. If not, thanks for joining in for this part of the adventure. To summarize the last post, cloud applications are becoming increasingly more common, and because of this fact, more of the data that is produced […]