When I start a new ETL project I often find it useful to have some idea how the source tables relate to each other. If I’m lucky there is documentation to guide me or even a diagram showing me how the tables link up (I do dream a lot). Of course, I could pull the […]
Last month a new R package was released called ODBC to improve the ability to connect to relational databases. By using these universal connection packages such as DBI and ODBC, you’ll be able to easily port your code to different databases. If you currently use RODBC to connect to Oracle, you’ll like ODBC more! ODBC […]
Oracle Data Integrator Cloud Service is a new-ish cloud service from Oracle that allows us to run ODI as a platform in the Oracle Cloud. There are a lot of moving parts to this cloud service, so the first part of this article will cover creating the Oracle Cloud Database, The Java Cloud Service, and […]
For those of you in the Oracle Business Intelligence space, you have likely heard us or some one else talk about Checkmate in the past. We have several posts on our blog about Checkmate, as well as a YouTube playlist dedicated to it, so I won’t spend too much time in this article evangelizing it. […]
The countdown is on for ODTUG’s Kscope17 in San Antonio, Texas and there is a packed lineup of impressive content, fun events, and a focus on emerging technologies. We know it will be tough to decide which sessions to attend but make sure you save some time to check out Red Pill Analytic’s sessions, listed […]
Did you miss Phil Goerdt and Mike Fuller‘s presentation about Cloud computing and storing data at MinneAnalytics #BIgDataTech last week? Let us share their presentation with you! Download it here! Cloud computing has changed how organizations use, access and store their data. While these paradigms have shifted, the traditional way of thinking about databases and data warehouses remain steadfast in […]
Who doesn’t love traditions? While I am not the most nostalgic guy, I certainly have a handful of traditions that I hold dear. I think as we blaze bravely ahead, it’s important to remember where we come from, both good and bad to influence a better future. Sure, we all have traditions on a personal […]
My last few blog posts have discussed how data failure happens, and how we can change failure into success (with a little economic thinking). Continuing with that train of thought, in this post I’ll be discussing how we can better implement analytic solutions by challenging the convention of requirements gathering. Don’t “Gather Requirements”. Hunt for […]
In my last blog post, I discussed how I think that the way most people talk about BI and analytics is incorrect, how data is fluid, and some of the biggest issues I see when helping clients. I’m going to continue that discussion in this blog post, but pivot the conversation from what is wrong […]
I had just gotten out of a discovery meeting with a client when she said “I’m sure we’re the worst you’ve seen”. The goal of the meeting was to better understand the process they were using, the data source, and how they were consuming that data. Turns out that data was entered into Share Point […]