Oracle analytics cloud Analysing Social Media Activity with ADW and OAC Analysing Twitter Activity using the Oracle Text features within the Oracle Database, Oracle Analytics Cloud and SQL Developer Web!
json Parsing Badly Formatted JSON in Oracle DB with APEX_JSON Using APEX_JSON to parse malformed JSON documents allowing the extraction of all the information contained.
Tableau Getting Smarter in Renting with Tableau 10 Preface Not a long time ago a friend of mine spent a significant amount of time trying to find a flat to rent. And according to what he said it wasn't an easy task. It took him a decent time and efforts to find something that is big enough (but
spark Getting Started with Spark Streaming, Python, and Kafka Last month I wrote a series of articles in which I looked at the use of Spark for performing data transformation and manipulation. This was in the context of replatforming an existing Oracle-based ETL and datawarehouse solution onto cheaper and more elastic alternatives. The processing that I wrote was very
jq Using SQL to Query JSON Files with Apache Drill I wrote recently about what Apache Drill is, and how to use it with OBIEE. In this post I wanted to demonstrate its great power in action for a requirement that came up recently. We wanted to analyse our blog traffic, broken down by blog author. Whilst we have Google
apache drill Using Apache Drill with OBIEE 12c Apache Drill enables querying with SQL against a multitude of datasources including things like JSON files, Parquet and Avro, Hive tables, RDBMS and more. MapR have released an ODBC driver for it, and I thought it'd be neat to get it to work with OBIEE. It evidently does work for
Big Data Using SparkSQL and Pandas to Import Data into Hive and Big Data Discovery Big Data Discovery (BDD) is a great tool for exploring, transforming, and visualising data stored in your organisation’s Data Reservoir. I presented a workshop on it at a recent conference, and got an interesting question from the audience that I thought I’d explore further here. Currently the primary
