Learn more
 

Gmail Integration Guides and Tutorials


A list of guides and tutorials for connecting to and working with live Gmail data.

CData Software's connectivity tools enable users to connect directly to live Gmail data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live Gmail data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Gmail in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Gmail Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Gmail Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Gmail data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Gmail in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Gmail Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Gmail Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Gmail in Birst
BIRTJDBCDesign BIRT Reports on Gmail
Clear AnalyticsODBCBuild Charts with Gmail in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Gmail Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Gmail in DBxtra
DomoODBCCreate Datasets from Gmail in Domo Workbench
Dundas BIODBCBuild Dashboards with Gmail in Dundas BI
Excel (on Mac OS)ODBCWork with Gmail Data in MS Excel on Mac OS X
FineReportJDBCFeed Gmail into FineReport
Google SheetsConnect CloudAccess Live Gmail Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Gmail
Infragistics RevealConnect CloudAnalyze Gmail Data in Infragistics Reval
JasperServerJDBCCreate Gmail Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Gmail in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Gmail in JReport Designer
KlipfolioConnect CloudCreate Gmail-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Gmail JDBC Driver in KNIME
LINQPadADO.NETWorking with Gmail in LINQPad
LookerConnect CloudAnalyze Gmail Data in Looker
Looker StudioConnect CloudCreate Reports from Gmail Data in Looker Studio
MetabaseConnect CloudCreate Interactive Gmail-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Gmail Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Gmail Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Gmail
MicroStrategyConnect CloudConnect to Live Gmail Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Gmail in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Gmail in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Gmail in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Gmail-Connected Visualizations in Mode
OBIEEJDBCGmail Reporting in OBIEE with the Gmail JDBC Driver
pandasPythonUse pandas to Visualize Gmail in Python
Pentaho Report DesignerJDBCIntegrate Gmail in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Gmail
Power BI ServiceConnect CloudVisualize Live Gmail Data in the Power BI Service
Power PivotConnect CloudAccess Gmail Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Gmail Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Gmail Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Gmail in QlikView over ODBC
RJDBCAnalyze Gmail in R (JDBC)
RODBCAnalyze Gmail in R (ODBC)
RapidMinerJDBCConnect to Gmail in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live Gmail Data in Redash
SAP Analytics CloudConnect CloudAnalyze Gmail Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Gmail
SAP Crystal ReportsJDBCPublish Reports with Gmail in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Gmail in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for Gmail in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Gmail in SAS JMP
SAS ViyaConnect CloudAnalyze Live Gmail Data in SAS Viya
SisenseJDBCVisualize Live Gmail in Sisense
Spago BIJDBCConnect to Gmail in SpagoBI
TableauTableauVisualize Gmail in Tableau Desktop
TableauConnect CloudVisualize Gmail in Tableau Desktop (Connect Cloud)
Tableau CloudConnect CloudBuild Gmail Visualizations in Tableau Cloud
Tableau ServerTableauPublish Gmail-Connected Dashboards in Tableau Server
ThoughtSpotConnect CloudModel, Search, and Visualize Live Gmail Data in ThoughtSpot
TIBCO SpotfireADO.NETVisualize Gmail in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Gmail Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Gmail from Spotfire Server
VisioODBCLink Visio Shapes to Gmail
Zoho AnalyticsConnect CloudCreate Gmail-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Gmail Data in Airbyte ELT Pipelines
Apache AirflowJDBCBridge Gmail Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Gmail using Apache Camel
Apache NiFiJDBCBridge Gmail Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Gmail Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Gmail Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Gmail Data Using Azure Data Factory
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Gmail to SQL Server
CloverDXJDBCConnect to Gmail in CloverDX (formerly CloverETL)
ETL ValidatorJDBCHow to Work with Gmail in ETL Validator
FoxProODBCWork with Gmail in FoxPro
Google Data FusionJDBCBuild Gmail-Connected ETL Processes in Google Data Fusion
Google Data FusionJDBCBuild Pipelines with Live Gmail Data in Google Cloud Data Fusion (CData Connect Cloud)
HULFT IntegrateJDBCConnect to Gmail in HULFT Integrate
Informatica CloudJDBCIntegrate Gmail in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Gmail
Jaspersoft ETLJDBCConnect to Gmail in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to Gmail
Microsoft Power AutomateConnect CloudBuild Gmail-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Gmail in Oracle Data Integrator
petlPythonExtract, Transform, and Load Gmail in Python
Replicate to MySQLPowerShellReplicate Gmail to MySQL with PowerShell
SnapLogicJDBCIntegrate Gmail with External Services using SnapLogic (JDBC)
SnapLogicConnect CloudIntegration with Gmail Data in SnapLogic (Connect Cloud)
SQL Server Linked ServerConnect CloudConnect to Gmail Data as a SQL Server Linked Server
TalendJDBCConnect to Gmail and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Gmail in UiPath Studio
WorkatoConnect CloudBuild Automated Workflows with Live Gmail Data in Workato
ZapierConnect CloudBuild Automated Gmail-Connected Workflows in Zapier

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate Gmail with a Microsoft Access Linked Table
APOS Live Data GatewayJDBCBuild Semantic Layer Views for Gmail (JDBC)
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for Gmail Data (Connect Cloud)
DenodoJDBCCreate A Data Source for Gmail in Denodo Platform
DremioJDBCConnect to Gmail as an External Source in Dremio
MySQL Federated TablesODBCConnect to Gmail as Federated Tables in MySQL
Oracle DatabaseODBCAccess Gmail as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for Gmail
Salesforce ConnectConnect CloudEdit and Search Gmail External Objects in Salesforce Connect
Salesforce External ServicesConnect CloudConnect to Gmail through External Services in Salesforce
SQL Server Linked ServersODBCConnect to Gmail as a Linked Server
SQL Server PolyBaseConnect CloudConnect to Gmail Data using PolyBase with Connect Cloud
SQL Server PolyBaseODBCConnect to Gmail as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live Gmail Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Gmail Data in AWS Lambda
AxiosConnect CloudBuild Gmail-Connected Web Apps with Axios and CData Connect Cloud
.NET ChartsADO.NETDataBind Charts to Gmail
.NET QueryBuilderODBCRapidly Develop Gmail-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Gmail
Apache SparkJDBCWork with Gmail in Apache Spark Using SQL
AppSheetConnect CloudCreate Gmail-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Gmail-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to Gmail Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on Gmail Data in Choreo
ColdFusionJDBCQuery Gmail in ColdFusion Using JDBC
ColdFusionODBCQuery Gmail in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Gmail
DelphiODBCDataBind Controls to Gmail Data in Delphi
DevExpressADO.NETDataBind Gmail to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Gmail with Entity Framework 6
EF - LINQADO.NETLINQ to Gmail
EF - MVCADO.NETBuild MVC Applications with Connectivity to Gmail
Filemaker ProODBCBidirectional Access to Gmail from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Gmail from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Gmail on Linux
Google Apps ScriptConnect CloudConnect to Gmail Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Gmail Entities in Java
IntelliJJDBCConnect to Gmail in IntelliJ
JBossJDBCConnect to Gmail from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Gmail using JDBI
JitterbitConnect CloudIntegrate with Live Gmail Data in Jitterbit
JRubyJDBCConnect to Gmail in JRuby
MendixConnect CloudBuild Gmail-Connected Apps in Mendix (Connect Cloud)
MendixJDBCBuild Gmail-Connected Apps in Mendix (JDBC)
Microsoft Power AppsConnect CloudIntegrate Live Gmail Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Gmail Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Gmail through ODBC in Node.js
OutSystemsConnect CloudCreate Gmail-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Gmail in PHP through Connect Server
PHPODBCNatively Connect to Gmail in PHP
PowerBuilderADO.NETConnect to Gmail from PowerBuilder
PowerShellPowerShellPipe Gmail to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for Gmail in PyCharm
PythonODBCConnect to Gmail in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with Gmail Data
RubyODBCConnect to Gmail in Ruby
RunMyProcessConnect CloudConnect to Gmail Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Gmail in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Gmail in SAPUI5 MVC Apps
ServoyJDBCBuild Gmail-Connected Apps in Servoy
Spring BootJDBCAccess Live Gmail Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Gmail in Python
TomcatJDBCConfigure the CData JDBC Driver for Gmail in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Gmail-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Gmail
WebLogicJDBCConnect to Gmail from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport Gmail Data into Apache Solr
Coginiti ProJDBCAccess Live Gmail Data in Coginiti Pro
DataGripJDBCQeury Gmail Data in DataGrip
DB ArtisanJDBCManage Gmail in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to Gmail in DBArtisan
DBeaverJDBCConnect to Gmail in DBeaver
DbVisualizerJDBCConnect to Gmail in DBVisualizer
HeidiSQLConnect CloudConnect to Gmail Data in HeidiSQL
Informatica Enterprise Data CatalogJDBCAdd Gmail to Informatica Enterprise Data Catalog
MySQL WorkbenchConnect ServerQuery Gmail Data in MySQL Workbench (Connect Server)
MySQL WorkbenchODBCQuery Gmail in MySQL Workbench (ODBC)
QuerySurgeJDBCValidate Gmail Data with QuerySurge
RazorSQLJDBCConnect to Gmail in RazorSQL
SQuirreLJDBCConnect to Gmail in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
MuleSoft AnypointJDBCAccess Gmail in Anypoint Using SQL
Nintex Workflow CloudConnect CloudBuild Gmail-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate Gmail Data into Power Automate Automated Tasks
SSIS ExportSSISExport Data from SQL Server to Gmail through SSIS
SSIS ImportSSISImport Gmail Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing Gmail Records from SQL Server

Back to top

Ready to get started?

Learn more:

Gmail Connectivity Solutions

In this article

Related articles