Blog - Page 3 of 14 - Red Pill Analytics

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1

This post is part 1 of 4 about using the Baseline Validation Tool (BVT) with Oracle Business Intelligence (OBIEE). Overview of BVT With the 12c release of OBIEE, Oracle released a new tool called the Baseline Validation Tool or BVT. This tool allows you to run specific tests against your OBIEE reports, dashboards, and BI Publisher […]

Using Oracle’s Baseline Validation Tool with OBIEE — Part 1 Read More »

Coding, OBIEE, Oracle, Oracle 12c

Proof that Less can be More

Snowflake Data Warehouse release 2.11 (September 7, 2017) included the addition of an OVERWRITE parameter for the INSERT command. INSERT OVERWRITE effectively consolidates two commands, TRUNCATE TABLE and INSERT, into one. INSERT OVERWRITE also deletes the file load history and retains access control privileges on the target table; both of which are not insignificant details.

Proof that Less can be More Read More »

Red Pill Analytics Tips, Snowflake, Tips

Coding is Cool Again — Join us at JavaOne

Fall is here and we are gearing up to head to San Francisco for Oracle OpenWorld, October 1–5. However, this year Red Pill Analytics, an analytics consulting firm, will also be participating in JavaOne, October 1–5. So what is JavaOne and why are we there? Let’s start by pointing out that Stewart Bryson, one of

Coding is Cool Again — Join us at JavaOne Read More »

Coding, Events, Java, Red Pill News, SQL

Got Lunch Plans on User Group Sunday at Oracle OpenWorld?

Some of the best presentations at Oracle Open World are on User Group Sunday, on Oct 1st. It can be challenging to pay attention in sessions though when your stomach is growling because there’s no conference meal that day. Regional User Groups have the solution! Join regional user groups at the Children’s Museum next to

Got Lunch Plans on User Group Sunday at Oracle OpenWorld? Read More »

Events, Red Pill News, Women In Tech

To San Fran We Go!

Fall is here and that means a trip to San Francisco is on the calendar for Red Pill Analytics. Once again, we are thrilled to be joining an amazing group of presenters at Oracle’s largest conference of the year, Oracle OpenWorld/JavaOne. Red Pill Analytics has six sessions, three at Oracle OpenWorld and three at JavaOne.

To San Fran We Go! Read More »

Events, Red Pill Analytics Tips, Red Pill News

Joining It All Up

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

Joining It All Up Read More »

Oracle 12c, SQL, Tips

How to Use the New R ODBC Package to Connect to an Oracle Database

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 Tech

Installing Oracle Data integrator Cloud Service (ODICS)

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

Installing Oracle Data integrator Cloud Service (ODICS) Read More »

Cloud, ODI, Red Pill Analytics Tips, Tips

Checkmate for OBI is Now Free

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.

Checkmate for OBI is Now Free Read More »

Checkmate, OBIEE, Red Pill Analytics Tips, Red Pill News

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem

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

Big Data Tundra: Creating a Flexible Cloud Based Data Ecosystem Read More »

Big Data, Cloud, Events, Snowflake

RPA Blog