Help Index - Google Services

Google Services components are SSIS components from SSIS Productivity Pack which facilitate codeless integration with various Google Services APIs.

The SSIS Productivity Pack currently supports connecting to and retrieving data from Google Analytics and Google Ads as well as connecting to and retrieving and writing data to Google Sheets, Google Cloud Storage, and Google BigQuery.

Google Ads Components

• Google Ads Connection Manager
  • Facilitates connecting to a Google Ads customer account through the Google Ads REST API.
    
• Google Ads Source
  • Facilitates retrieving Google Ads data from specified Report Type, Date Range, and other user-defined filters and variables.

Google Analytics Components

• Google Analytics Connection Manager
  • Facilitates connection to a Google Analytics account through the Google Analytics REST API.
• Google Analytics Source Component
  • Facilitates retrieving Google Analytics data, supports custom segments, dimensions and metrics.

Google BigQuery Components

• Google BigQuery Connection Manager
  • Facilitates connection to Google BigQuery through a Google account and the Google BigQuery REST API.
• Google BiqQuery Source Component
  • Supports retrieving data from Google BigQuery from Project, Dataset, Job, Table, TableData, or Query objects.
• Google BigQuery Destination Component
  • Support writing data to Google BigQuery through Project, Dataset, Job, Table, or TableData objects.

Google Cloud Storage Components

• Google Cloud Storage Connection Manager
  • Used to establish the connection to Google Cloud Storage from within SSIS.
• Google Cloud Storage Source Component
  • An SSIS data flow component that facilitates retrieving data from Google Cloud Storage with various item retrieval modes such as retrieving files and folder or only files or choosing whether sub items should be retrieved as well.
• Google Cloud Storage Destination Component
  • An SSIS data flow component that facilitates writing data to Google Cloud Storage. The component supports the options to create, delete, move or upsert objects to the cloud server.

Google Drive Components

• Google Drive Connection Manager
  • Used to establish the connection to Google Drive from within SSIS.
• Google Drive Source Component
  • An SSIS data flow pipeline component that can be used to read / retrieve data from Google Drive.
• Google Drive Destination Component
  • An SSIS data flow pipeline component that can be used to write data to Google Drive.

Google Sheets Components

• Google Sheets Connection Manager
  • Facilitates connection to a Google Sheets document through a Google account and the Google Sheets REST API.
• Google Sheets Source Component
  • An SSIS data flow component which facilitates retrieving data from a Google Sheet.
• Google Sheets Destination Component
  • An SSIS data flow component which is used to facilitate writing data to a Google Sheet. Developers will be able to specify if they would like to Append, Update, Clear, CopyTo, Create, or Batch Update when writing to Google Sheets.

Shared Utilities

• Google Services Token Manager
  • The Google Services Token Manager is used when development and deployment occur on different machines. It is a utility external to SSIS for adding, removing, importing or exporting Tokens from machine to machine.

Video Resources