BI & Analytics

---

Our drivers offer the fastest and easiest way to connect real-time Azure Data Lake Storage data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Azure Data Lake Storage data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations

---

Alteryx Designer: Prepare, Blend, and Analyze Azure Data Lake Storage in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Azure Data Lake Storage in Amazon QuickSight Aqua Data Studio: Connect to Azure Data Lake Storage in Aqua Data Studio AWS Databricks: Process & Analyze Azure Data Lake Storage Data in Databricks (AWS) Birst: Build Visualizations of Azure Data Lake Storage in Birst BIRT: Design BIRT Reports on Azure Data Lake Storage Clear Analytics: Build Charts with Azure Data Lake Storage in Clear Analytics DBxtra: Build Dashboards with Azure Data Lake Storage in DBxtra Domo: Create Datasets from Azure Data Lake Storage in Domo Workbench Dundas BI: Build Dashboards with Azure Data Lake Storage in Dundas BI Excel (on Mac OS): Work with Azure Data Lake Storage Data in MS Excel on Mac OS X FineReport: Feed Azure Data Lake Storage into FineReport Google Sheets: Access Live Azure Data Lake Storage in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with Azure Data Lake Storage Infragistics Reveal: Analyze Azure Data Lake Storage Data in Infragistics Reval JasperServer: Create Azure Data Lake Storage Reports on JasperReports Server Jaspersoft BI Suite: Connect to Azure Data Lake Storage in Jaspersoft Studio JReport Designer: Integrate with Azure Data Lake Storage in JReport Designer Klipfolio: Create Azure Data Lake Storage-Connected Visualizations in Klipfolio KNIME: Enable the Azure Data Lake Storage JDBC Driver in KNIME LINQPad: Working with Azure Data Lake Storage in LINQPad Looker Studio: Create Reports from Azure Data Lake Storage in Looker Studio Metabase: Create Interactive Azure Data Lake Storage-Connected Metabase Dashboards Microsoft SSAS: Build an OLAP Cube in SSAS from Azure Data Lake Storage MicroStrategy: Connect to Live Azure Data Lake Storage in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Azure Data Lake Storage in MicroStrategy Web OBIEE: Azure Data Lake Storage Reporting in OBIEE with the Azure Data Lake Storage JDBC Driver pandas: Use pandas to Visualize Azure Data Lake Storage in Python Pentaho Report Designer: Integrate Azure Data Lake Storage in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Azure Data Lake Storage Power BI Service: Visualize Live Azure Data Lake Storage in the Power BI Service QlikView: Connect to and Query Azure Data Lake Storage in QlikView over ODBC R: Analyze Azure Data Lake Storage in R (JDBC) R: Analyze Azure Data Lake Storage in R (ODBC) RapidMiner: Connect to Azure Data Lake Storage in RapidMiner SAP Analytics Cloud: Analyze Azure Data Lake Storage in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Lake Storage SAP Crystal Reports: Publish Reports with Azure Data Lake Storage in Crystal Reports SAS: Use the CData ODBC Driver for Azure Data Lake Storage in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Azure Data Lake Storage in SAS JMP Sisense: Visualize Live Azure Data Lake Storage in Sisense Spago BI: Connect to Azure Data Lake Storage in SpagoBI Tableau: Visualize Azure Data Lake Storage in Tableau Desktop Tableau Cloud: Build Azure Data Lake Storage Visualizations in Tableau Cloud Tableau Server: Publish Azure Data Lake Storage-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Azure Data Lake Storage in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Azure Data Lake Storage from Spotfire Server

ETL, Replication, & Warehousing

---

From drivers and adapters that extend your favorite ETL tools with Azure Data Lake Storage connectivity to ETL/ELT tools for replication — our Azure Data Lake Storage integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Azure Data Lake Storage to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.

Popular Data Warehousing Integrations

---

Amazon Redshift: Automated Continuous Azure Data Lake Storage Replication to Amazon Redshift Amazon S3: Automated Continuous Azure Data Lake Storage Replication to Amazon S3 Apache Airflow: Bridge Azure Data Lake Storage Connectivity with Apache Airflow Apache Camel: Integrate with Azure Data Lake Storage using Apache Camel Apache NiFi: Bridge Azure Data Lake Storage Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Azure Data Lake Storage Data in Apache NiFi Azure Synapse: Automated Continuous Azure Data Lake Storage Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Azure Data Lake Storage to SQL Server CloverDX: Connect to Azure Data Lake Storage in CloverDX (formerly CloverETL) Databricks: Automated Continuous Azure Data Lake Storage Replication to Databricks FoxPro: Work with Azure Data Lake Storage in FoxPro Google AlloyDB: Automated Continuous Azure Data Lake Storage Replication to Google AlloyDB Google BigQuery: Automated Continuous Azure Data Lake Storage Replication to Google BigQuery Google Cloud SQL: Automated Continuous Azure Data Lake Storage Replication to Google Cloud SQL Google Data Fusion: Build Azure Data Lake Storage-Connected ETL Processes in Google Data Fusion HULFT Integrate: Connect to Azure Data Lake Storage in HULFT Integrate Informatica Cloud: Integrate Azure Data Lake Storage in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Azure Data Lake Storage Jaspersoft ETL: Connect to Azure Data Lake Storage in Jaspersoft Studio Microsoft Power Automate: Build Azure Data Lake Storage-Connected Automated Tasks with Power Automate (Desktop) Oracle Data Integrator: ETL Azure Data Lake Storage in Oracle Data Integrator petl: Extract, Transform, and Load Azure Data Lake Storage in Python Replicate to CSV: Replicate Azure Data Lake Storage to MySQL with PowerShell SAP HANA: Automated Continuous Azure Data Lake Storage Replication to SAP HANA SingleStore: Automated Continuous Azure Data Lake Storage Replication to SingleStore SnapLogic: Integrate Azure Data Lake Storage with External Services using SnapLogic Snowflake: Automated Continuous Azure Data Lake Storage Replication to Snowflake SQL Server Linked Server: Connect to Azure Data Lake Storage as a SQL Server Linked Server Talend: Connect to Azure Data Lake Storage and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Azure Data Lake Storage in UiPath Studio Vertica: Automated Continuous Azure Data Lake Storage Replication to a Vertica Database

Data Management

---

By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Azure Data Lake Storage data from a wide range of database management applications.

Popular Data Management Tool Integrations

---

Apache Solr: Import Azure Data Lake Storage Data into Apache Solr DB Artisan: Manage Azure Data Lake Storage in DBArtisan as a JDBC Source DB Artisan: Connect to Azure Data Lake Storage in DBArtisan DBeaver: Connect to Azure Data Lake Storage in DBeaver DbVisualizer: Connect to Azure Data Lake Storage in DBVisualizer Informatica Enterprise Data Catalog: Add Azure Data Lake Storage to Informatica Enterprise Data Catalog MySQL Workbench: Query Azure Data Lake Storage in MySQL Workbench (ODBC) QuerySurge: Validate Azure Data Lake Storage Data with QuerySurge RazorSQL: Connect to Azure Data Lake Storage in RazorSQL SQuirreL: Connect to Azure Data Lake Storage in Squirrel SQL Client

Workflow & Automation Tools

---

Connect to Azure Data Lake Storage from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Azure Data Lake Storage data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations

---

MuleSoft Anypoint: Access Azure Data Lake Storage in Anypoint Using SQL Power Automate: Integrate Azure Data Lake Storage into Power Automate Automated Tasks SSIS Import: Import Azure Data Lake Storage Data into SQL Server using SSIS

Developer Tools & Technologies

---

The easiest way to integrate with Azure Data Lake Storage from anywhere. Our Azure Data Lake Storage drivers offer a data-centric model for Azure Data Lake Storage that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:

• Pragmatic API Integration: from SDKs to Data Drivers
• Data APIs: Gateway to Data Driven Operation & Digital Transformation

Popular Developer Integrations

---

.NET Charts: DataBind Charts to Azure Data Lake Storage .NET QueryBuilder: Rapidly Develop Azure Data Lake Storage-Driven Apps with Active Query Builder Apache Spark: Work with Azure Data Lake Storage in Apache Spark Using SQL AppSheet: Create Azure Data Lake Storage-Connected Business Apps in AppSheet ColdFusion: Query Azure Data Lake Storage in ColdFusion Using JDBC ColdFusion: Query Azure Data Lake Storage in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Azure Data Lake Storage DevExpress: DataBind Azure Data Lake Storage to the DevExpress Data Grid EF - Code First: Access Azure Data Lake Storage with Entity Framework 6 EF - LINQ: LINQ to Azure Data Lake Storage EF - MVC: Build MVC Applications with Connectivity to Azure Data Lake Storage Filemaker Pro: Bidirectional Access to Azure Data Lake Storage from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Azure Data Lake Storage from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Azure Data Lake Storage on Linux Google Apps Script: Connect to Azure Data Lake Storage in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Azure Data Lake Storage Entities in Java IntelliJ: Connect to Azure Data Lake Storage in IntelliJ JBoss: Connect to Azure Data Lake Storage from a Connection Pool in JBoss JDBI: Create a Data Access Object for Azure Data Lake Storage using JDBI JRuby: Connect to Azure Data Lake Storage in JRuby Microsoft Power Apps: Integrate Live Azure Data Lake Storage into Custom Business Apps Built in Power Apps NodeJS: Query Azure Data Lake Storage in Node.js (via Connect Server) NodeJS: Query Azure Data Lake Storage through ODBC in Node.js PHP: Natively Connect to Azure Data Lake Storage in PHP PowerBuilder: Connect to Azure Data Lake Storage from PowerBuilder PowerShell: Pipe Azure Data Lake Storage to CSV in PowerShell PyCharm: Using the CData ODBC Driver for Azure Data Lake Storage in PyCharm Python: Connect to Azure Data Lake Storage in Python on Linux/UNIX Ruby: Connect to Azure Data Lake Storage in Ruby RunMyProcess: Connect to Azure Data Lake Storage in RunMyProcess RunMyProcess DSEC: Connect to Azure Data Lake Storage in DigitalSuite Studio through RunMyProcess DSEC Servoy: Build Azure Data Lake Storage-Connected Apps in Servoy Spring Boot: Access Live Azure Data Lake Storage Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Azure Data Lake Storage in Python Tomcat: Configure the CData JDBC Driver for Azure Data Lake Storage in a Connection Pool in Tomcat Unqork: Create Azure Data Lake Storage-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Azure Data Lake Storage WebLogic: Connect to Azure Data Lake Storage from a Connection Pool in WebLogic

Data Virtualization

---

Our drivers provide a virtual database abstraction on top of Azure Data Lake Storage data and support popular data virtualization features like query federation through advanced capabilities for query delegation / predicate pushdown.

Learn more about how our tools can be used in popular data virtualization scenarios below:

Popular Data Virtualization Tool Integrations

---

APOS Live Data Gateway: Build Semantic Layer Views for Azure Data Lake Storage Denodo: Create A Data Source for Azure Data Lake Storage in Denodo Platform Dremio: Connect to Azure Data Lake Storage as an External Source in Dremio MySQL Federated Tables: Connect to Azure Data Lake Storage as Federated Tables in MySQL Oracle Database: Access Azure Data Lake Storage as a Remote Oracle Database PostgreSQL FDW: A PostgreSQL Interface for Azure Data Lake Storage Salesforce Connect: Edit and Search Azure Data Lake Storage External Objects in Salesforce Connect SQL Server Linked Servers: Connect to Azure Data Lake Storage as a Linked Server SQL Server PolyBase: Connect to Azure Data Lake Storage as an External Data Source using PolyBase TIBCO Data Virtualization: Access Live Azure Data Lake Storage Data in TIBCO Data Virtualization