Google drive connector template (535.83 KB)

File Name: Google Drive Connector User Guide.pdf

File Size: 535.83 KB

File Type: Application/pdf

Last Modified: 4 years

Status: Available

Last checked: 6 days ago!

This Document Has Been Certified by a Professional

100% customizable

Language: English

We recommend downloading this file onto your computer

Summary

Informatica Confidential Google drive Template.doc
Google Drive Connector Template
Table of Contents
GOOGLE DRIVE CONNECTOR TEMPLATE .....................................................................................................1
TABLE OF CONTENTS..................................................................................................................................................1
INTRODUCTION TO GOOGLE DRIVE CONNECTOR .....................................................................................2
GOOGLE DRIVE CONNECTOR OVERVIEW (REQUIRED) ...............................................................................................2
GOOGLE DRIVE CONNECTOR TASK AND OBJECT TYPES (REQUIRED) ........................................................................2
GOOGLE DRIVE OBJECTS (BASED ON CONTENT) ........................................................................................................2
INTRODUCTION TO GOOGLE DRIVE ............................................................................................................................3
ADMINISTRATION OF GOOGLE DRIVE CONNECTOR (REQUIRED) ................................................................................3
GOOGLE DRIVE CONNECTIONS .........................................................................................................................4
GOOGLE DRIVE CONNECTION OVERVIEW ..................................................................................................................4
GOOGLE DRIVE CONNECTION PROPERTIES ................................................................................................................5
DATA SYNCHRONIZATION TASKS WITH GOOGLE DRIVE ........................................................................5
GOOGLE DRIVE SOURCES IN DATA SYNCHRONIZATION TASKS ..................................................................................5
GOOGLE DRIVE TARGETS IN DATA SYNCHRONIZATION TASKS ..................................................................................7
EXAMPLE GOOGLE DRIVE DATA SYNCHRONIZATION TASK (OPTIONAL) ....................................................................8
MAPPING AND MAPPING CONFIGURATION TASKS WITH GOOGLE DRIVE ...................................... 10
GOOGLE DRIVE SOURCE IN MAPPING AND MAPPING CONFIGURATION TASKS ......................................................... 10
GOOGLE DRIVE TARGETS IN MAPPING AND MAPPING CONFIGURATION TASKS ....................................................... 10
EXAMPLE GOOGLE DRIVE MAPPING AND MAPPING CONFIGURATION TASK (OPTIONAL) ......................................... 11
--Yogesh Prasad-- Page 1 6/14/2017
Informatica Confidential Google drive Template.doc
Google Drive Connector User Guide
Introduction to Google Drive Connector
Google Drive Connector can be used to Provide connectivity to Google Drive to and from variety of
external sources

Google Drive Connector Overview (Required)
Google Drive Connector can be used to upload, download and fetching the list of files. It can also be
used to create new file, update existing files or get the comments on files, replies on comments,
permissions of user over files. It can be used to fetch and update the details of revisions

Google Drive Connector Task and Object Types (Required)
This Connector is flat record based and it supports both Data Synchronization Task and Mapping
Configuration Task.Only Basic Filters is supported and Advanced Filters is not supported

The following table lists the Google Drive object types that you can include in Informatica Cloud tasks:
Task Type Source Target Lookup
Data synchronization Yes Yes Yes
Mapping configuration Yes Yes Yes
Google Drive Objects (Based on content)
You can work with the following types of Google Drive objects in Informatica Cloud:
Standard objects
The standard Objects supported by Google Drive are About, Changes_GetStartPageToken,
Changes_List, Comments_Create, Comments_List, Comments_Get, Comments_Update,
Comments_Delete, Files_List, Files_Get, Files_Create, Files_Update, Files_Delete, Permissions_Create,
Permissions_List, Permissions_Get, Permissions_Update, Permissions_Delete, Replies_Create,
Replies_List, Replies_Get, Replies_Get, Replies_Update, Replies_Delete, Revisions_List,
Revisions_Get, Revisions_Update, Revisions_Delete

Object Name Read Insert Update Delete Upsert
About Yes NA NA NA NA
Changes_GetStartPageToken Yes NA NA NA NA
Changes_List Yes NA NA NA NA
Comments_Create NA Yes NA NA NA
Comments_List Yes NA NA NA NA
Comments_Get Yes NA NA NA NA
Comments_Update NA NA Yes NA NA
Comments_Delete NA NA NA Yes NA
Files_List Yes NA NA NA NA
Files_Get Yes NA NA NA NA
Files_Create NA Yes NA NA NA
Files_Update NA NA Yes NA NA
Files_Delete NA NA NA Yes NA
Permissions_Create NA Yes NA NA NA
Permissions_List Yes NA NA NA NA
Permissions_Get Yes NA NA NA NA
Permissions_Update NA NA Yes NA NA
--Yogesh Prasad-- Page 2 6/14/2017
Informatica Confidential Google drive Template.doc
Permissions_Delete NA NA NA Yes NA
Replies_Create NA Yes NA NA NA
Replies_List Yes NA NA NA NA
Replies_Get Yes NA NA NA NA
Replies_Update NA NA Yes NA NA
Replies_Delete NA NA NA Yes NA
Revisions_List Yes NA NA NA NA
Revisions_Get Yes NA NA NA NA
Revisions_Update NA NA Yes NA NA
Revisions_Delete NA NA NA Yes NA
Introduction to Google Drive
Google Drive is a file storage and synchronization service. Google Drive allows users to store files in
cloud, synchronize files across devices, and share files. Google Drive encompasses Google Docs,
Sheets and Slides, an office suite that permits collaborative editing of documents, spreadsheets,
presentations, drawings, forms, and more. Files created and edited through the office suite are saved in
Google Drive

Administration of Google Drive Connector (required)
Before using the Google Drive connector, the following pre-requisites task must be completed:
1. Create Google Account to access Google Drive

2. Go to Google Developers Console (https://console.developers.google.com/)

3. Enable APIs for your project
Any application that calls Google APIs needs to enable those APIs in the API Console. To enable
the appropriate APIs for your project:
a) Open the Library page in the API Console

b) Select the project associated with your application. Create a project if you do not have one
already

c) Use the Library page to find each API that your application will use. Click on each API and
enable it for your project

4. Create authorization credentials
Any application that uses OAuth 2.0 to access Google APIs must have authorization credentials
that identify the application to Google's OAuth 2.0 server. The following steps explain how to
create credentials for your project. Your applications can then use the credentials to access APIs
that you have enabled for that project

a) Open the Credentials page in the API Console

b) Click Create credentials > OAuth client ID

c) Complete the form

5. Download the JSON file

6. Go through the following link that mention the process to get the Refresh token

https://developers.google.com/identity/protocols/OAuth2InstalledApp
--Yogesh Prasad-- Page 3 6/14/2017
Informatica Confidential Google drive Template.doc
Google Drive Connections
Create a Google Drive connection to read data from Google Drive source and write data to a Google
Drive target. You must create a connection for Google Drive Object that you want to connect to. You
can use Google Drive connections in Data Synchronization tasks, Mapping Configuration tasks and
mappings

Google Drive Connection Overview
Google Drive connector has 6 connection attributes and out of which 3 are mandatory

--Yogesh Prasad-- Page 4 6/14/2017
Informatica Confidential Google drive Template.doc
Create an Google Drive connection to access Google Drive data from Informatica Cloud. You can create
a connection on the Connections page or when you create a task. After you create a connection, it
becomes available to all users who have access to the organization

Google Drive Connection Properties
Connection Attributes Mandatory Description
Client ID Yes The Client ID from Google Developer Console
Client Secret Yes The Client Secret from Google Developer Console

Refresh Token Yes The Refresh Token recieved after exchanging authorization
code

File Download Path No The Directory where file needs to be downloaded

File Upload Path No The Directory where file is stored and needs to be uploaded

PageSize No The pagesize for the read operation(Default value is 10)
The following snapshot gives the connection information:
Data synchronization Tasks with Google Drive
Google Drive Sources in Data synchronization Tasks
About, Changes_GetStartPageToken, Changes_List, Comments_List, Comments_Get, Replies_List,
Replies_Get, Files_List, Files_Get, Permissions_List, Permissions_Get, Revisions_List and
Revisions_Get objects are supported under source

--Yogesh Prasad-- Page 5 6/14/2017
Informatica Confidential Google drive Template.doc
Only Basic Filters is supported and advanced Filters is not supported. Following are the examples of the
filters for the objects. Following tables gives information on filters for the Changes_List, Comments_List,
Comments_Get, Replies_List, Replies_Get, Files_List, Files_Get, Revisions_List, Revisions_Get,
Permissions_List and Permissions_Get objects

Changes_List:
fieldname Operator DataType Example
pageToken = String 4068
includeRemoved = Boolean true
restrictToMyDrive = Boolean false
spaces = String drive
Comments_List:
fieldname Operator DataType Example
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
Comments_Get:
fieldname Operator DataType Example
id = String AAAABDjWDCo
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
Replies_List:
fieldname Operator DataType Example
commentId = String AAAABDjWDCo
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
includeDeleted = Boolean false
pageToken = String null
Replies_Get:
fieldname Operator DataType Example
replyId = String AAAABNKRAno
commentId = String AAAABDjWDCo
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
includeDeleted = boolean false
--Yogesh Prasad-- Page 6 6/14/2017
Informatica Confidential Google drive Template.doc
Files_Get:
fieldname Operator DataType Example
id = String 0B4MM8Zr4yD5xVDFzcDFaVWs1c1U
Revisions_List:
fieldname Operator DataType Example
id = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
Revisions_Get:
fieldname Operator DataType Example
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
revisionId = String 5
acknowledgeAbuse = Boolean false
Permissions_List:
fieldname Operator DataType Example
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
Permissions_Get:
fieldname Operator DataType Example
permissionId = String 09378765391695072284
fileId = String 1PFA00v7Y7LCgeYXsHUPhE3hznGb2G97JdiLAJsh46YM
Google Drive Targets in Data synchronization Tasks
Comments_Create, Comments_Delete, Comments_Update, Replies_Create, Replies_Delete,
Replies_Update, Files_Create, Files_Delete, Files_Update, Permissions_Create, Permissions_Delete,
Permissions_Update, Revisions_Delete and Revisions_Update objects are supported under target

Example Google Drive Data synchronization Task (optional)
1. Files_List
Read:
1.The Data Synchronization Task for File List operation in which,Definition includes task name as
GoogleDrive_DSS and Task operation should be Insert
--Yogesh Prasad-- Page 7 6/14/2017
Informatica Confidential Google drive Template.doc
2. The Data Synchronization Task for File List operation in which, Source includes Connection name as
gck_gd_test and Source type should be Single and Source object should be Files_List

3.The Data Synchronization Task for File List operation in which, Target includes Connection name as
P_Flatfile and Target Object should be like Files_List.csv

--Yogesh Prasad-- Page 8 6/14/2017
Informatica Confidential Google drive Template.doc
4. The Data Synchronization Task for File List operation in which, Filed Mapping contains Source and
Target in which we have to map like this : kind will map with kind

--Yogesh Prasad-- Page 9 6/14/2017
Informatica Confidential Google drive Template.doc
Mapping and Mapping configuration Tasks with Google Drive
Google Drive Source in Mapping and Mapping configuration Tasks
About, Changes_GetStartPageToken, Changes_List, Comments_List, Comments_Get, Replies_List,
Replies_Get, Files_List, Files_Get, Permissions_List, Permissions_Get, Revisions_List and
Revisions_Get objects are supported under source

Google Drive Targets in Mapping and Mapping configuration Tasks
Comments_Create, Comments_Delete, Comments_Update, Replies_Create, Replies_Delete,
Replies_Update, Files_Create, Files_Delete, Files_Update, Permissions_Create, Permissions_Delete,
Permissions_Update, Revisions_Delete and Revisions_Update objects are supported under target

Example Google Drive Mapping and Mapping configuration Task (optional)
1.The Mapping Task for FileList operation in which Task name as GoogleDrive_Connector_Mapping1
and take New Source and New Target and give Properties to Source. Source includes connection name
as gck_gd_task and source type as single object and Object as Files_List
--Yogesh Prasad-- Page 10 6/14/2017
Informatica Confidential Google drive Template.doc
2.The Mapping Task for Files_List operation in which, in Target we have to give connection name as
P_Flatfile and Target type as single Object and Object as newFiles_List.csv and operation is insert

--Yogesh Prasad-- Page 11 6/14/2017
Informatica Confidential Google drive Template.doc
1.The Mapping configuration task for Files_List operation in which, Defination have task name as
GoogleDrive_MCT1 and Runtime environment as DESKTOP-N8SQ47H and task based on mapping and
mapping name we should give GoogleDrive_Connector_Mapping1

API References: https://developers.google.com/drive/v3/reference/
--Yogesh Prasad-- Page 12 6/14/2017

Informatica Confidential Google drive Template.doc --Yogesh Prasad-- Page 8 6/14/2017 2. The Data Synchronization Task for File List operation in which, Source includes Connection name as gck_gd_test and Source type should be Single and Source object should be Files_List. 3.The Data Synchronization Task for File List operation in which, Target

Download Now

Documemt Updated

› Guidelines Informed Consent Form Or Information Letter

› Gr Informative Writing Student Peer Teacher K

› Growing Your Business Checklist Pdf

› Guidance On Information Requests Ogc Guidance

› Guidance On Information Requests Ogc

› Guidelines For Release Of Health Information

› Generic Release Form Sefmd Home Page

› General Authorization For Release Of Information

› General Medical Records Release And

› General Consent To Release Information Form

› General Release Of Information Legalzoom

› Guardian Contact Form Datefecha Plate Black Alaska

› General Intake Form Bailey Galyen

› Greetings Grantees

› Guidance On Completing A Participant Information

› Grading Sheet Template Pdf Luwimaxilonavaweeblycom

› Guidance For The Participant Information Sheet

› G Staffing 2 Professional Staff Certification And

› General Information Form Lock Haven

› Google Slides Templates Blue Fundaciotallersorg

Popular Download

Frequently Asked Questions

What is the use of google drive?

Thank you. Google Drive is a file storage and synchronization service created by Google. It allows users to store files in the cloud, share files, and edit documents, spreadsheets, and presentations with collaborators. This connector is available in the following products and regions:

What type of authentication does google drive connector use?

Google Drive Connector uses the OAuth 2.0 authentication connection type, which uses access tokens provided by the authorization server to access protected data. See Also Introduction to Anypoint Connectors

How can i access google drive for free?

Access Google Drive with a free Google account (for personal use) or Google Workspace account (for business use).