SSIS Google Analytics Source

SSIS Google Analytics Source connector can be used to read data from Google Analytics Service without learning complex API. Easy to use interface allows you extract large amount of data adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data.

Features

  • Intuitive user interface makes google analytics data integration super easy and fast without learning complex APIs or scripting language
  • Support for OAuth 2.0 Authentication and Google service account (*.p12 certificate file)
  • Support for Proxy Server
  • Easy to use interface with three different ways to query google analytics data (1) Build query from UI (2) Use built in query templates (3) Use direct query
  • Support for dynamic dimensions, metrics, segments, filters and sortby fields (e.g. supply these values at runtime)
  • Live preview support at design time
  • Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP)
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Google Data Connection UI – Access Google Analytics data using OAuth 2.0 authentication protocol

Google Data Connection UI - Access Google Analytics data using OAuth 2.0 authentication protocol

Google Data Connection UI – Access Google Analytics data using service account method (*.P12 Certificate file)

SSIS Google Analytics Connector - Access data using service account method (*.P12 Certificate file)

SSIS Google Analytics Connector UI – Automatic URL mode (Build your own query from UI)

SSIS Google Analytics Connector UI - Automatic URL mode (Build your own query from UI)

SSIS Google Analytics Connector UI – Manual URL mode (Supply predefined URL)

SSIS Google Analytics Connector UI - Manual URL mode (Supply predefined URL)

SSIS Google Analytics Connector UI – Predefined Reports mode

SSIS Google Analytics Connector UI - Predefined Reports mode

SSIS Google Analytics Connector UI – Predefined Report Preview

SSIS Google Analytics Connector UI - Predefined Report Preview

SSIS Google Analytics Connector UI – Select Web Profile

SSIS Google Analytics Connector UI - Select Web Profile

SSIS Google Analytics Connector UI – Select Dimensions

SSIS Google Analytics Connector UI - Select Dimensions

SSIS Google Analytics Connector UI – Select Metrics

SSIS Google Analytics Connector UI - Select Metrics

SSIS Google Analytics Connector UI – Select Filters

SSIS Google Analytics Connector UI - Select Filters

SSIS Google Analytics Connector UI – Select Segment

SSIS Google Analytics Connector UI - Select Segment

SSIS Package – Get data from Google Analytics and load into SQL Server

SSIS Package - Get data from Google Analytics and load into SQL Server

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This