Ready to get started?

Azure Data Lake Storage Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live Azure Data Lake Storage data.

CData Software's connectivity tools enable users to connect directly to live Azure Data Lake Storage 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 Data Lake Storage 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 Data Lake Storage in Alteryx Designer (ODBC)
Amazon QuickSightConnect ServerBuild Interactive Dashboards from Azure Data Lake Storage Data in Amazon QuickSight
Aqua Data StudioJDBCConnect to Azure Data Lake Storage in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Azure Data Lake Storage Data in Databricks (AWS)
BirstJDBCBuild Visualizations of Azure Data Lake Storage in Birst
BIRTJDBCDesign BIRT Reports on Azure Data Lake Storage
Clear AnalyticsODBCBuild Charts with Azure Data Lake Storage in Clear Analytics
DBxtraODBCBuild Dashboards with Azure Data Lake Storage in DBxtra
DomoODBCCreate Datasets from Azure Data Lake Storage in Domo Workbench
Dundas BIODBCBuild Dashboards with Azure Data Lake Storage in Dundas BI
Excel (on Mac OS)ODBCWork with Azure Data Lake Storage Data in MS Excel on Mac OS X
FineReportJDBCFeed Azure Data Lake Storage into FineReport
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Azure Data Lake Storage
Infragistics RevealConnect ServerAnalyze Azure Data Lake Storage Data in Infragistics Reval
JasperServerJDBCCreate Azure Data Lake Storage Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Azure Data Lake Storage in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Azure Data Lake Storage in JReport Designer
KlipfolioConnect ServerCreate Azure Data Lake Storage-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Azure Data Lake Storage JDBC Driver in KNIME
LINQPadADO.NETWorking with Azure Data Lake Storage in LINQPad
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Azure Data Lake Storage
MicroStrategyConnect ServerConnect to Live Azure Data Lake Storage Data in MicroStrategy through Connect Server
MicroStrategyJDBCUse the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy Web
OBIEEJDBCAzure Data Lake Storage Reporting in OBIEE with the Azure Data Lake Storage JDBC Driver
pandasPythonUse pandas to Visualize Azure Data Lake Storage in Python
Pentaho Report DesignerJDBCIntegrate Azure Data Lake Storage in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Azure Data Lake Storage
Power BI ServiceConnect ServerVisualize Live Azure Data Lake Storage Data in the Power BI Service
Power PivotConnect ServerAccess Azure Data Lake Storage Data in Microsoft Power Pivot
Power QueryConnect ServerAccess Azure Data Lake Storage Data in Microsoft Power Query
Qlik CloudConnect ServerCreate Apps from Azure Data Lake Storage Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Azure Data Lake Storage in QlikView over ODBC
RJDBCAnalyze Azure Data Lake Storage in R (JDBC)
RODBCAnalyze Azure Data Lake Storage in R (ODBC)
RapidMinerJDBCConnect to Azure Data Lake Storage in RapidMiner
RedashConnect ServerBuild Azure Data Lake Storage-Connected Dashboards in Redash
SAP Analytics CloudConnect ServerAnalyze Azure Data Lake Storage Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Lake Storage
SAP Crystal ReportsJDBCPublish Reports with Azure Data Lake Storage in Crystal Reports
SASODBCUse the CData ODBC Driver for Azure Data Lake Storage in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Azure Data Lake Storage in SAS JMP
SisenseJDBCVisualize Live Azure Data Lake Storage in Sisense
Spago BIJDBCConnect to Azure Data Lake Storage in SpagoBI
TableauTableauVisualize Azure Data Lake Storage in Tableau Desktop
Tableau CloudConnect ServerBuild Azure Data Lake Storage Visualizations in Tableau Cloud
Tableau ServerTableauPublish Azure Data Lake Storage-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Azure Data Lake Storage in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Azure Data Lake Storage Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Azure Data Lake Storage from Spotfire Server

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Azure Data Lake Storage Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Azure Data Lake Storage Replication to Amazon S3
Apache AirflowJDBCBridge Azure Data Lake Storage Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Azure Data Lake Storage using Apache Camel
Apache CassandraCData SyncAutomated Continuous Azure Data Lake Storage Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Azure Data Lake Storage Replication to Apache Kafka
Apache NiFiJDBCBridge Azure Data Lake Storage Connectivity with Apache NiFi
Azure SynapseCData SyncAutomated Continuous Azure Data Lake Storage Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Azure Data Lake Storage to SQL Server
CloverDXJDBCConnect to Azure Data Lake Storage in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous Azure Data Lake Storage Replication to Couchbase
CSVCData SyncAutomated Continuous Azure Data Lake Storage Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Azure Data Lake Storage Replication to Databricks
FoxProODBCWork with Azure Data Lake Storage in FoxPro
Google AlloyDBCData SyncAutomated Continuous Azure Data Lake Storage Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Azure Data Lake Storage Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Azure Data Lake Storage Replication to Google Cloud SQL
Google Data FusionJDBCBuild Azure Data Lake Storage-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Azure Data Lake Storage for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Azure Data Lake Storage in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Azure Data Lake Storage Replication to IBM DB2
Informatica CloudJDBCIntegrate Azure Data Lake Storage in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Azure Data Lake Storage
Jaspersoft ETLJDBCConnect to Azure Data Lake Storage in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Azure Data Lake Storage Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Azure Data Lake Storage Replication to Azure SQL
Microsoft Power AutomateConnect ServerBuild Azure Data Lake Storage-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Azure Data Lake Storage Replication to MongoDB
MySQLCData SyncAutomated Continuous Azure Data Lake Storage Replication to MySQL
Oracle Data IntegratorJDBCETL Azure Data Lake Storage in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Azure Data Lake Storage Replication to Oracle
petlPythonExtract, Transform, and Load Azure Data Lake Storage in Python
PostgreSQLCData SyncAutomated Continuous Azure Data Lake Storage Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate Azure Data Lake Storage to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Azure Data Lake Storage Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Azure Data Lake Storage Replication to SingleStore
SnapLogicJDBCIntegrate Azure Data Lake Storage with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Azure Data Lake Storage Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Azure Data Lake Storage Replication to SQL Server
SQL Server Linked ServerConnect ServerConnect to Azure Data Lake Storage Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Azure Data Lake Storage Replication to SQLite
TalendJDBCConnect to Azure Data Lake Storage and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Azure Data Lake Storage in UiPath Studio
VerticaCData SyncAutomated Continuous Azure Data Lake Storage Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top