Problem Description :

• Why do you need Google Sheet Connector?
• How Informatica customers can use Google Sheets Connector?
• Problems Google Sheets Connector can resolve
• Advantage of Infometry’s Google Sheet Connector over JDBC Driver?

Infometry’s Google Sheets Connector is the only Informatica Certified native Cloud connector available for the IDMC (Formerly known as IICS)
platform. Infometry’s Connectors are supporting the latest version of Google Sheets APIs, enabling seamless integration and real-time Data Analytics. Infometry’s Google Sheet Connector for Informatica enables easy application integration, data extraction for downstream applications, and ETL for Enterprise Data Warehouse support.

Why do You Need Google Sheets Connector?

Most of the customers are adopting Google Workspace (formerly called GSuite) which includes Google Sheets, Google Drive, Gmail, Google Calendar..etc for their office automation. Informatica Cloud Customers are leveraging Google Sheets to store data sets such as Sales Forecast, Goals, Lab Results, Headcount estimates, OpEx Budgets..etc which need to be further loaded into Enterprise Data Warehouse, Cloud Applications, and Data Lake.

The Data Warehouse team needs to automate the extraction of data from multiple Google Sheets having multiple tabs having complex formatting. Informatica customers need a wizard type of easy interface, without going through complex API documentation to implement the solution. Infometry Google Sheet connector provides UI based interface (ZERO codings required) to process data from Google sheets to multiple targets and vice-versa.

How Informatica customers can use Google Sheets Connector?

Pleaes refer to the following User Guide to understand how to use Google Sheet Connector

 DOWNLOAD DATASHEET

You can also refer to the following video tutorials explaining Read, Write and Delete operations

UPDATE

WRITE/INSERT

DELETE

Problems Google Sheets Connector can resolve.

Informatica Cloud Customers need a native Google Sheet connector that supports all the API operations including reading, Write, Updating, Deleting, Rangesearchng…etc. Using REST Connector to implement the Google Sheets connectivity is overly complex and the JDBC driver will not provide all the API interfaces.

Infometry’s Google Sheet Connector supports both CDI and CAI and supports unlimited endpoints. Our connectors follow the Informatica Cloud Connector release cycle and any enhancements will be automatically updated as part of the INFA cloud release.

Advantage of Infometry’s Google Sheets Connector over JDBC Driver? 

Infometry’s Google Sheet Connector provides UI based interface for all API operations supported by Google Sheets. Customers need not have to understand anything about APIs and token generation is also automated within the connector. All the data processing tasks can be automated and scheduled. Infometry’s Google Sheet Connector can be integrated with IDMC (Formerly known as IICS) or PowerCenter and supports on-premises and cloud applications. It can be easily integrated with Data Warehouse, MDM, and Data Lake.  It also supports Batch Mode (CDI) and Real-Time Integration (CAI). Infometry’s Google Sheet Connector has no limit on data processing and yet it is a fast and highly secured way to process data to Google Sheets.

You can perform insert, update, and delete operations on a Google Sheets target. You cannot perform upsert operations on a Google Sheets target.

The following table lists the Google Sheet Connector object types that you can include in Data Integration

tasks:

The standard objects are the Sheet Names that are present in the spreadsheet. The Sheet Names are dynamic and fetched automatically during data preview.

The following table lists the objects and task operations that Google Sheet Connector supports for Sheet

Names object:

• How to subscribe to Google Sheet Connector free trial?

Click on the link below to subscribe for a free trial or you can visit the Informatica marketplace to initiate your free trial.

• What are the other connectors available for Informatica?

We have Connectors available for Google Sheets, Google Drive, Google PubSub, Google BigTable, HubSpot, and Adaptive Insights.

• Is this connector certified by Informatica?

All Infometry’s Connectors are 100% Certified by Informatica and are listed on Informatica Marketplace.

• Can we automate the data manipulation/processing using Infometry’s Google Sheet Connector for Informatica?

Yes, Whether you perform a read, write or delete operation using Infometry’s Connector for Informatica, it can be automated or scheduled for a periodic update.