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...