Load Google Analytics Data into SAP BW - Part I: The Data Flow

Overview

One of the most challenging part of Data Warehousing is to find the right way of extracting external data. Recently I have got a question about Google Analytics:

Google analytics data, is there any idea how to consume it in BW ?

For the first sight, I was thinking, "well it's challenging", because I went through the different standard tools for connecting data to BW and I didn't find an obvious solution:

  • SAP Service API ? No, Google is not an SAP source system
  • DB connect ? No, Google is not a DB system like Oracle or MSSQL
  • File ? Maybe yes, if I can manage the automatic download to csv...
  • Web Service ? Maybe yes, if I can manage the automatic download and conversion, but it's similar to the File interface problem...