Learn more
 

Ready to get started?

Learn more:

Azure Table Connectivity Solutions

In this article

Related articles

Azure Table Integration Guides and Tutorials


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

CData Software's connectivity tools enable users to connect directly to live Azure Table 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 Azure Table 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 Azure Table in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Azure Table Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Azure Table Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Azure Table data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Azure Table in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Azure Table Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Azure Table Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Azure Table in Birst
BIRTJDBCDesign BIRT Reports on Azure Table
Cognos Analytics (On-Prem)Connect CloudAnalyze Azure Table Data in Cognos Analytics
DomoODBCCreate Datasets from Azure Table in Domo Workbench
Excel (on Mac OS)ODBCWork with Azure Table Data in MS Excel on Mac OS X
FineReportJDBCFeed Azure Table into FineReport
Google SheetsConnect CloudAccess Live Azure Table Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Azure Table
Infragistics RevealConnect CloudAnalyze Azure Table Data in Infragistics Reval
KlipfolioConnect CloudCreate Azure Table-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Azure Table JDBC Driver in KNIME
LINQPadADO.NETWorking with Azure Table in LINQPad
LookerConnect CloudAnalyze Azure Table Data in Looker
Looker StudioConnect CloudCreate Reports from Azure Table Data in Looker Studio
MetabaseConnect CloudCreate Interactive Azure Table-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Azure Table Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Azure Table Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Azure Table
MicroStrategyConnect CloudConnect to Live Azure Table Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Azure Table in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Azure Table in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Azure Table in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Azure Table-Connected Visualizations in Mode
pandasPythonUse pandas to Visualize Azure Table in Python
Pentaho Report DesignerJDBCIntegrate Azure Table in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Azure Table
Power BI ServiceConnect CloudVisualize Live Azure Table Data in the Power BI Service
Power PivotConnect CloudAccess Azure Table Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Azure Table Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Azure Table Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Azure Table in QlikView over ODBC
RODBCAnalyze Azure Table in R (ODBC)
RapidMinerJDBCConnect to Azure Table in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live Azure Table Data in Redash
SAP Analytics CloudConnect CloudAnalyze Azure Table Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Table
SAP Crystal ReportsJDBCPublish Reports with Azure Table in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Azure Table in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for Azure Table in SAS for Real-Time Reporting and Analytics
SAS ViyaConnect CloudAnalyze Live Azure Table Data in SAS Viya
SisenseJDBCVisualize Live Azure Table in Sisense
Tableau CloudConnect CloudBuild Azure Table Visualizations in Tableau Cloud
TIBCO Spotfire ServerJDBCOperational Reporting on Azure Table from Spotfire Server
VisioODBCLink Visio Shapes to Azure Table
Zoho AnalyticsConnect CloudCreate Azure Table-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


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

Back to top

Data Virtualization


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

Back to top

Software Development


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

Back to top

Data Management


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

Back to top

Workflow Automation


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

Back to top