Project Description
A SSIS Data Source Component for SQL Server 2008 and SQL Server 2012 to load data from the Google Data API.

Release notes: Google API V3
The new version supports the Google Analytics API v3, OAuth 2.0 and multithreading. The version is not compatible with previous versions. The documentation will be updated in the coming days.
On my blog you can find some information about new features - unfortunately only in German.

Functions:
  • Load data from your Google Analytics Profile
  • Define different Metrics and Dimensions
  • Custom variables can be selected
  • Set Metrics and Dimensions Filter
  • Set Advanced Segments

Since Version 1.0.1.0 the SSIS GoogleAnalytics Source is available for SQL Server 2008 (R2) x86 and x64.
Since Version 1.1.0.0 the SSIS GoogleAnalytics Source is available for SQL Server 2012
Since Version 1.1.0.0 the SSIS GoogleAnalytics Source uses Google API v2.4
Since Version 1.6.0.0 the SSIS GoogleAnalytics Source uses Google API v3
Since Version 1.6.0.0 the SSIS GoogleAnalytics Source uses OAuth 2.0



Notice:
  • Not all dimensions and metrics can be queried together. Only certain dimensions and metrics can be used together to create valid combinations. Visit http://bit.ly/gBOjKp for more details.

GoogleAnalyticsSource Configuration GoogleAnalyticsSource Configuration GoogleAnalyticsSource Configuration

GoogleAnalyticsSource Configuration GoogleAnalyticsSource Configuration GoogleAnalyticsSource Configuration


When you are looking for more SSIS Tasks please visit my german blog http://www.ssis-components.net (Components).

Last edited Mar 23 at 9:22 AM by Tillmann, version 37