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 […]
How to Use the New R ODBC Package to Connect to an Oracle Database Read More »
Databases, R, Women In TechOracle 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
Installing Oracle Data integrator Cloud Service (ODICS) Read More »
Cloud, ODI, Red Pill Analytics Tips, TipsFor 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.
Checkmate for OBI is Now Free Read More »
Checkmate, OBIEE, Red Pill Analytics Tips, Red Pill NewsDid 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
Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem Read More »
Big Data, Cloud, Events, SnowflakeWho 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
Because… Tradition? Read More »
Big DataMy 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
Hunters Eat Better Than Gatherers Read More »
Analytics, Business Intelligence, IT ManagementIn 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
Supply, Demand and Data Read More »
Data, Data ScienceI 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
That title sounds a little weird, tunnels go through the ground and clouds are those fluffy things that float in the sky. However when we are talking about Oracle Cloud and SSH tunneling things make a lot more sense. Although this blog is specific to the Oracle Cloud Database, tunneling is a generic technique and
Tunneling Through the Clouds Read More »
Cloud, linux, Security, SSHI’ve had some fun working with StreamSets Data Collector lately and wanted to share how to quickly get up and running on an Amazon Web Services (AWS) Elastic Compute Cloud (EC2) instance and build a simple pipeline. For anyone unaware, StreamSets Data Collector is, in their own words, a low-latency ingest infrastructure tool that lets
Stream Me Up (to the Cloud), Scotty Read More »
AWS, StreamSets