How to Connect Google Drive to Informatica IDMC: Step-by-Step Guide

In today’s fast-paced data landscape, manual file transfers are a bottleneck. Whether you’re building pipelines or managing reports, integrating cloud storage like Google Drive directly with Informatica IDMC can save hours and ensure real-time access to business-critical data.

In this blog, we’ll walk you through a step-by-step guide to connect Google Drive to Informatica IDMC using Infometry’s certified Google Drive Connector — and how it transforms your file integration workflow.

Why Connect Google Drive to IDMC?

Organizations use Google Drive to store everything from CSVs and Excel sheets to documents and PDFs. But unless you have a native connector, getting those files into your IDMC environment means:

• Manually downloading and re-uploading
• Delays in ETL processing
• Version mismatches and access issues

By integrating with a certified connector, you can automate uploads, manage shared drives, and build real-time data pipelines—without writing any code.

What You Need

Before you begin, ensure you have:

• An active Informatica Intelligent Data Management Cloud (IDMC) account
• Access to the Informatica Marketplace
• A Google account with access to the Drive you want to connect
• Infometry’s Google Drive Connector for IDMC (Free trial available)

Step-by-Step: Connect Google Drive to Informatica IDMC

Step 1: Go to Informatica Marketplace

Head to the Informatica Marketplace and search for “Infometry Google Drive Connector”.

Click on the connector listing and choose Start Free Trial or Request License.

Step 2: Install the Connector in IDMC

Once approved, install the connector from your IDMC tenant. You’ll find it listed under Connections > Connectors.

Step 3: Configure Google Drive Credentials

Set up your Google OAuth 2.0 credentials or service account. The connector supports:

• OAuth access with refresh tokens
• Shared Drives and Team Drives
• Multiple Google accounts and environments

Step 4: Create a Secure Agent Connection

From Connections > New, select the Google Drive Connector as the type.

Enter your Client ID, Client Secret, and define the Drive scope (read/write permissions, shared drive access, etc.).

Step 5: Build Your Data Task

Whether you’re building a synchronization task, mapping task, or a full ETL pipeline, now you can:

• Upload or download files
• Access metadata, permissions, and comments
• Use Google Drive as both source and target

Pro Tip: Supported File Operations

With Infometry’s connector, you can automate:

• File Uploads/Downloads (.csv, .docx, .pdf, .json, etc.)
• File Search and Listing
• Comment & Reply Retrieval
• Permission Management
• Revision Tracking
• Support for “Shared with Me” & Team Drives

Real Use Cases

• Upload sales reports from Google Sheets into your Snowflake warehouse
• Auto-sync shared marketing folders for weekly BI dashboards
• Manage regional files across multiple Google accounts and business units

Benefits of Using Infometry’s Connector

• 100% Informatica Certified
• Unlimited file operations under one license
• Automation-ready and no-code deployment
• Scales across projects, teams, and data environments
• Fast support, enterprise reliability

Try It Today – No Strings Attached

Infometry’s Google Drive Connector for IDMC is available for free trial on the Informatica Marketplace. Whether you’re in IT, data engineering, or BI, this tool helps you streamline your file operations and unlock faster reporting.

Still stuck with manual exports? Let Infometry help you automate your cloud data flow.