Load Google Analytics Data into SAP BW - PART V: Query and Excel

Load Google Analytics Data into SAP BW is possbile

Overview

In the previous post, I have initialized our Analytics Client with OAuth. As I promised, we are over the hard part of the authentication. This is where things get interesting. In this post I will be implementing the remaining 2 steps in our workflow. As a result, we will be able to Execute a Query and Save it to a CSV file. By the end of this post, we will have a working prototype of our Google Analytics Extractor that can generate a file interface for uploading it to BW.

Load Google Analytics Data into SAP BW - Part III: Preparation of Extractor with Console Application

Overview

In my previous post I have showed the usage of the Google Api Query Explorer and I chose the right parameters for my query after some testing. Now it's time to start implementing our extractor. In this post I will be preparing the skeleton of the solution that I feel as a very important step. In the past, I was always jumping directly to coding without knowing exactly how I want my solution works. In most of the cases it was a big failure since I can get lost in the details very fast. So in order to keep focused on my problem, I design first the skeleton of my program with empty methods expressing my intention about how I expect the solution should work. It's very good to start thinking only on high level because it will be a safety belt that we can grab when digging into the details. Start always with surprisingly simple things and solve more and more complex problems step by step! That worked for me so many times!