[DDB-11] SQL/MED connector for Google Analytics

[dynamobi-build]

[reporter="ngoodman", created="Fri, 22 Jan 2010 10:45:17 -0800"]

Build a SQL/MED connector for Google anlaytics data

http://code.google.com/apis/analytics/docs/gdata/gdataReferenceDataFeed.html

[dynamobi-build]

[author="ngoodman", created="Tue, 8 Jun 2010 21:06:37 -0700"]

Reference the SFDC connector (//open/dy/dev/extensions/conn/sfdc) for examples.

Need to:

• Present overall design for foreign data wrapper
• Build project structure, including ant targets for building, testing, and packaging
• Build a foreign data connector
• Build any necessary foreign schema browse routines
• Ensure that simple push down rules are followed
• Build test suite that comprehensively tests a variety of push down rules, and data access
• Research/setup test account? How the heck will we do this since results should be static for testing purposes

Background Links:
http://farrago.sourceforge.net/design/sqlmed.html
http://p4webhost.eigenbase.org:8080/@md=d&cd=//open/dy/dev/extensions/conn/&pgc=y@//open/dy/dev/extensions/conn/sfdc/?ac=83

[dynamobi-build]

[author="ngoodman", created="Tue, 8 Jun 2010 21:16:51 -0700"]

Also, appears there's a Google Analytics Data Export API in Java already. Awesome.
http://code.google.com/apis/analytics/docs/gdata/2.0/gdataJava.html

It looks like getting the raw data may be tough. Somehow we need to get the non metric dictionary and also get the lowest level grain of Metrics (granularity of cube). Also, I think we'll have to completely ignore the calculated metrics (but they'd make a great Mondrian cube).