Google Analytics data via Teiid?

[mtawk]

Is there a way to read Google Analytics data from teiid?

[rareddy]

Not currently, but looks like Google Analytics API seems to provide access to the data, so writing a translator is possible. Also, I suggest to see if there is REST API for access and see if you can use WS translator and access the data.

Ramesh..

[mtawk]

I'll see if there is REST API provided.

Otherwise, I have found a google analytics jdbc driver :http://www.cdata.com/drivers/ganalytics/jdbc/

but will it work with teiid since it does not has the corresponding translator?

[rareddy]

We have generic JDBC translator that you can use. That is either "jdbc-ansi" or "jdbc-simple". Depending upon if the above driver supports ANSI style SQL choose former otherwise later one. Let us know if that works out. It is also lot more less work to extend the JDBC translator for specific datasource for customizing the behavior if the mentioned translators do not work for you.