Help Index - Google Services

The Google Services SSIS Components from our SSIS Productivity Pack facilitate codeless integration with various Google Services APIs.

---

The SSIS Productivity Pack currently supports connecting to and retrieving data from Google Analytics, Google Maps and YouTube Analytics, as well as connecting to, retrieving and writing data to Google Ads, Google AlloyDB, Google BigQuery, Google Calendar, Google Classroom, Google Cloud SQL, Google Cloud Storage, Google Drive, Google Maps, Google Forms, Google People, and Google Sheets.

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 Destination Source
  • Facilitates writing data to Google Ads services.

Google AlloyDB Components

• Google AlloyDB Connection Manager
  • Facilitates connections with Google AlloyDB instances.
• Google AlloyDB Source Component
  • Supports reading and retrieving data from Google AlloyDB instance databases.
• Google AlloyDB Destination Component
  • Support writing to a Destination table in a Google AlloyDB instance.
• Google AlloyDB Command Task Component
  • This component can be used to run commands to the Google AlloyDB instance directly at the control flow level, execute queries, and also to get the output in a required manner.

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 Calendar Components

• Google Calendar Connection Manager
  • Facilitates bi-directional connections with Google Calendar.
• Google Calendar Source Component
  • An SSIS data flow component which facilitates retrieving data from Google Calendar.
• Google Calendar Destination Component
  • An SSIS data flow component which is used to facilitate writing data to Google Calendar.

Google Classroom Components

• Google Classroom Connection Manager
  • Facilitates connection to Google Classroom.
• Google Classroom Source Component
  • An SSIS data flow component which facilitates retrieving data from Google Classroom.
• Google Classroom Destination Component
  • An SSIS data flow component which is used to facilitate writing data to Google Classroom.

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 Cloud SQL Components

• Google Cloud SQL Connection Manager
  • Facilitates connections with Google Cloud SQL databases.
• Google Cloud SQL Source Component
  • Supports reading and retrieving data from Google Cloud SQL.
• Google Cloud SQL Destination Component
  • Support writing to a Destination table in a Google Cloud SQL instance.

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 Forms Components

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

Google Maps Components

• Google Maps Connection Manager
  • Facilitates connections with Google Maps instances.
    
• Google Maps Source Component
  • Supports reading and retrieving data from Google Maps instance databases.

Google People Components

• Google People Connection Manager
  • Facilitates connection to Google People API.
• Google People Source Component
  • An SSIS data flow component which facilitates retrieving data from Google People.
• Google People Destination Component
  • An SSIS data flow component which is used to facilitate writing data to Google People.
    

Google Search Console Components

• Google Search Console Connection Manager
  • Facilitates connection to Google Search Console.
• Google Search Console Source Component
  • An SSIS data flow component which facilitates retrieving data from Google Search Console.
• Google Search Console Destination Component
  • An SSIS data flow component which is used to facilitate writing data to Google Search Console.

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.

Google Tag Manager Components

• Google Tag Manager Connection Manager
  • Facilitates bi-directional connections with Google Tag Manager.
• Google Tag Manager Source Component
  • An SSIS data flow component which facilitates retrieving data from Google Tag Manager.
• Google Tag Manager Destination Component
  • An SSIS data flow component which is used to facilitate writing data to Google Tag Manager.
    

YouTube Analytics Components

• YouTube Analytics Connection Manager
  • Facilitates the connection to a YouTube Analytics account through the YouTube Analytics REST API.
• YouTube Analytics Source Component
  • Facilitates the retrieval of YouTube Analytics data.

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