BigQuery Integration Guides and Tutorials

Ready to get started?

Learn more:

BigQuery Connectivity Solutions

In this article

Related articles


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

CData Software connectivity tools provide access to live BigQuery data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live BigQuery 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 BigQuery in Alteryx Designer
Amazon QuickSightConnect CloudBuild Interactive Dashboards from BigQuery in Amazon QuickSight
Aqua Data StudioJDBCConnect to BigQuery in Aqua Data Studio
BirstJDBCBuild Visualizations of BigQuery in Birst
BIRTJDBCDesign BIRT Reports on BigQuery
Clear AnalyticsODBCBuild Charts with BigQuery in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with BigQuery in DBxtra
DomoODBCCreate Datasets from BigQuery in Domo Workbench
Dundas BIODBCBuild Dashboards with BigQuery in Dundas BI
FineReportJDBCFeed BigQuery into FineReport
Google Data StudioConnect CloudCreate Reports from BigQuery in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with BigQuery
JasperServerJDBCCreate BigQuery Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to BigQuery in Jaspersoft Studio
JReport DesignerJDBCIntegrate with BigQuery in JReport Designer
KlipfolioConnect CloudCreate BigQuery-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the BigQuery JDBC Driver in KNIME
LINQPadADO.NETWorking with BigQuery in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time BigQuery
Power BI OnlineConnect CloudVisualize Live BigQuery in the Power BI Service
MetabaseConnect CloudCreate Interactive BigQuery-Connected Metabase Dashboards
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from BigQuery
MicroStrategyJDBCUse the CData JDBC Driver for BigQuery in MicroStrategy
OBIEEJDBCBigQuery Reporting in OBIEE with the BigQuery JDBC Driver
pandasPythonUse pandas to Visualize BigQuery in Python
Pentaho Report DesignerJDBCIntegrate BigQuery in the Pentaho Report Designer
QlikViewODBCConnect to and Query BigQuery in QlikView over ODBC
RJDBCAnalyze BigQuery in R
RapidMinerJDBCConnect to BigQuery in RapidMiner
RedashConnect ServerBuild BigQuery-Connected Dashboards in Redash
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for BigQuery
SAP Crystal ReportsJDBCPublish Reports with BigQuery in Crystal Reports
SAP LumiraAPI ServerConsume BigQuery OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for BigQuery in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live BigQuery in Sisense
Spago BIJDBCConnect to BigQuery in SpagoBI
TableauTableauVisualize BigQuery in Tableau Desktop
Tableau OnlineConnect CloudBuild BigQuery Visualizations in Tableau Online
Tableau ServerTableauPublish BigQuery-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize BigQuery in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on BigQuery from Spotfire Server
VisioODBCLink Visio Shapes to BigQuery

Back to top

ETL & Replication


ProductTechnologyArticle Title
Apache CamelJDBCIntegrate with BigQuery using Apache Camel
Apache CassandraCData SyncAutomated Continuous BigQuery Replication to Apache Cassandra
Apache NiFiJDBCBridge BigQuery Connectivity with Apache NiFi
AWS GlueJDBCConnect to BigQuery in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate BigQuery to SQL Server
CloverDXJDBCConnect to BigQuery in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous BigQuery Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous BigQuery Replication to IBM DB2
FoxProODBCWork with BigQuery in FoxPro
Heroku / Salesforce ConnectCData SyncReplicate BigQuery for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to BigQuery in HULFT Integrate
Informatica CloudJDBCIntegrate BigQuery in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for BigQuery
Jaspersoft ETLJDBCConnect to BigQuery in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous BigQuery Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous BigQuery Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to BigQuery
MongoDBCData SyncAutomated Continuous BigQuery Replication to MongoDB
MySQLCData SyncAutomated Continuous BigQuery Replication to MySQL
Oracle Data IntegratorJDBCETL BigQuery in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous BigQuery Replication to Oracle
petlPythonExtract, Transform, and Load BigQuery in Python
PostgreSQLCData SyncAutomated Continuous BigQuery Replication to PostgreSQL
SnapLogicJDBCIntegrate BigQuery with External Services using SnapLogic
Replicate to CSVPowerShellReplicate BigQuery to MySQL with PowerShell
SQL ServerCData SyncAutomated Continuous BigQuery Replication to SQL Server
SQLiteCData SyncAutomated Continuous BigQuery Replication to SQLite
TalendJDBCConnect to BigQuery and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to BigQuery in UiPath Studio

Back to top

Data Virtualization


ProductTechnologyArticle Title
Access Linked TablesODBCUpdate BigQuery with a Microsoft Access Linked Table
DenodoJDBCCreate A Data Source for BigQuery in Denodo Platform
DremioJDBCConnect to BigQuery as an External Source in Dremio
MySQL Federated TablesConnect ServerConnect to BigQuery as Federated Tables in MySQL
MySQL Federated TablesODBCConnect to BigQuery as Federated Tables in MySQL
Oracle DatabaseODBCAccess BigQuery as a Remote Oracle Database
PostgreSQL FDWJDBCA PostgreSQL Interface for BigQuery
Salesforce ConnectAPI ServerEdit and Search BigQuery External Objects
SharePoint External ListAPI ServerAccess BigQuery in SharePoint External Lists
SQL Server Linked ServersODBCConnect to BigQuery as a Linked Server
SQL Server PolyBaseODBCConnect to BigQuery as an External Data Source using PolyBase
TIBCO Data VirtualizationTIBCO DVAccess Live BigQuery Data in TIBCO Data Virtualization

Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to BigQuery
.NET QueryBuilderODBCRapidly Develop BigQuery-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with BigQuery
Apache SparkJDBCWork with BigQuery in Apache Spark Using SQL
AppSheetConnect CloudCreate BigQuery-Connected Business Apps in AppSheet
Microsoft Azure Logic AppsAPI ServerTrigger BigQuery IFTTT Flows in Azure App Service
ColdFusionJDBCQuery BigQuery in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on BigQuery
DevExpressADO.NETDataBind BigQuery to the DevExpress Data Grid
EF - Code FirstADO.NETAccess BigQuery with Entity Framework 6
EF - LINQADO.NETLINQ to BigQuery
EF - MVCADO.NETBuild MVC Applications with Connectivity to BigQuery
Filemaker ProJDBCBidirectional Access to BigQuery from FileMaker Pro
GoODBCWrite a Simple Go Application to work with BigQuery on Linux
Google Apps ScriptConnect CloudConnect to BigQuery in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with BigQuery Entities in Java
IntelliJJDBCConnect to BigQuery in IntelliJ
JBossJDBCConnect to BigQuery from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for BigQuery using JDBI
JRubyJDBCConnect to BigQuery in JRuby
NodeJSAPI ServerQuery BigQuery from Node.js
NodeJSConnect CloudQuery BigQuery as a MySQL Database in Node.js
NodeJSJDBCQuery BigQuery through ODBC in Node.js
PHPConnect ServerAccess BigQuery in PHP through the Cloud Hub
PHPODBCNatively Connect to BigQuery in PHP
PowerShellPowerShellPipe BigQuery to CSV in PowerShell
PowerBuilderADO.NETConnect to BigQuery from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for BigQuery in PyCharm
PythonODBCConnect to BigQuery in Python on Linux/UNIX
RubyODBCConnect to BigQuery in Ruby
SAP UI5API ServerIntegrate Real-Time Access to BigQuery in SAPUI5 MVC Apps
ServoyJDBCBuild BigQuery-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access BigQuery in Python
TomcatJDBCConfigure the CData JDBC Driver for BigQuery in a Connection Pool in Tomcat
UnqorkConnect CloudCreate BigQuery-Connected Applications in Unqork
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for BigQuery
WebLogicJDBCConnect to BigQuery from a Connection Pool in WebLogic

Back to top

Data Management


ProductTechnologyArticle Title
Apache SolrJDBCImport BigQuery Data into Apache Solr
DBeaverJDBCConnect to BigQuery in DBeaver
DbVisualizerJDBCConnect to BigQuery in DBVisualizer
DB ArtisanJDBCManage BigQuery in DBArtisan as a JDBC Source
DB ArtisanODBCConnect to BigQuery in DBArtisan
Informatica Enterprise Data CatalogJDBCAdd BigQuery to Informatica Enterprise Data Catalog
MySQL WorkbenchODBCQuery BigQuery in MySQL Workbench
RazorSQLJDBCConnect to BigQuery in RazorSQL
SQuirreLJDBCConnect to BigQuery in Squirrel SQL Client

Back to top

Workflow Automation


ProductTechnologyArticle Title
Power AutomateAPI ServerAutomate Tasks in Power Automate Using API Server
Power AutomateConnect ServerIntegrate BigQuery into Power Automate Automated Tasks
Microsoft Power AppsAPI ServerDesign BigQuery Power Apps
Nintex Workflow CloudConnect CloudBuild BigQuery-Connected Workflows in Nintex
Microsoft Power AppsConnect CloudIntegrate Live BigQuery into Custom Business Apps Built in Power Apps
MuleSoft AnypointJDBCAccess BigQuery in Anypoint Using SQL
SSIS ExportSSISExport Data from SQL Server to BigQuery through SSIS
SSIS ImportSSISImport BigQuery Data into SQL Server using SSIS
SSIS LookupSSISInsert New or Update Existing BigQuery Records from SQL Server

Back to top