How to use the Snowflake Data Warehouse destination in StreamSets Data Collector to replicate an OLTP database StreamSets Data Collector offers incredible flexibility while creating data integration pipelines by allowing developers to either create a custom stage (an origin, processor, executor, or destination) completely from scratch, tailor a universal stage to a specific requirement, or use [...]
In a recent blog titled Managing Snowflake Data Warehouse Compute in OBIEE, I explained how to assign application users and roles to use designated compute clusters (warehouses) in Snowflake. The idea of specifying a Snowflake warehouse on a per user (or groups of users) basis is not specific to OBIEE and can be achieved with [...]
How to dynamically set a Snowflake virtual warehouse Congratulations! You just configured Oracle Business Intelligence Enterprise Edition (OBIEE) to connect to your freshly loaded Snowflake Data Warehouseinstance and you’re feeling pretty good. Maybe your OBIEE dashboards are finally meeting SLAs, you’re not sitting with a DBA trying to tune SQL statements, your data is finally all in one [...]
With Thanksgiving sneaking up on us, we’d like to share a charity befitting the turkey season, Hungry for a Day. H4AD was co-founded by one of Red Pill’s own, David Huey. Watch David’s short video on the program and the families they have helped: H4AD began seven years ago with the idea that life was [...]
Serverless computing is here to stay, and while the term “serverless” is a bit of a misnomer, the concept offers many benefits. Most notably, serverless computing allows developers to focus on writing code and not concern themselves with provisioning, configuring, or maintaining servers. One such example of serverless computing is AWS Lambda. Although there are [...]
As a vendor, it’s rare to leave a conference feeling totally energized and fulfilled; thankfully, Looker Join broke the mold for Red Pill Analytics. Spoiler alert: we’ll definitely be going back next year. Mike Jelen addressing the @LookerData Partner Summit on how @RedPillA provides Real-TimeBusiness Analytics to customers. The week kicked off at the Partner [...]
October 27, 2017 was our second annual U Girls Code event at University of Utah. The idea for this event came from Tyra Crockett, from Oracle Academy, and I. We convinced University of Utah’s TEK Club to host the event as it is good exposure for their program to have the girls in a university [...]
This post is part 4 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). The previous posts are: Post 1: An intro to BVT Post 2: Setting up BVT Post 3: Running the Tests Interpreting the BVT Results As described in my third post in this series, here’s how to […]
ODTUG Kscope has two new reasons for being the best conference in the Oracle community. This year, Red Pill Analytics Co-founder and CEO Stewart Bryson was recognized for his accomplishments twice — with the Innovation Award, and the Best Speaker Award in the Big Data & Data Warehousing Track. These kudos added to a week […]
Do your summer plans include Orlando and Kscope18? Ours do! We are excited to be part of the amazing lineup at the Swan and Dolphin in Orlando, FL on June 10–14. We know it’s tough to decide which sessions to attend but make sure to add these Red Pill Analytics’ sessions to your schedule builder. Let […]