BI & Analytics

---

Our drivers offer the fastest and easiest way to connect real-time Azure Data Catalog data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Azure Data Catalog 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 Catalog in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Azure Data Catalog in Amazon QuickSight Aqua Data Studio: Connect to Azure Data Catalog in Aqua Data Studio AWS Databricks: Process & Analyze Azure Data Catalog Data in Databricks (AWS) Birst: Build Visualizations of Azure Data Catalog in Birst BIRT: Design BIRT Reports on Azure Data Catalog Clear Analytics: Build Charts with Azure Data Catalog in Clear Analytics DBxtra: Build Dashboards with Azure Data Catalog in DBxtra Domo: Create Datasets from Azure Data Catalog in Domo Workbench Dundas BI: Build Dashboards with Azure Data Catalog in Dundas BI Excel (on Mac OS): Work with Azure Data Catalog Data in MS Excel on Mac OS X FineReport: Feed Azure Data Catalog into FineReport Google Sheets: Access Live Azure Data Catalog in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with Azure Data Catalog Infragistics Reveal: Analyze Azure Data Catalog Data in Infragistics Reval JasperServer: Create Azure Data Catalog Reports on JasperReports Server Jaspersoft BI Suite: Connect to Azure Data Catalog in Jaspersoft Studio JReport Designer: Integrate with Azure Data Catalog in JReport Designer Klipfolio: Create Azure Data Catalog-Connected Visualizations in Klipfolio KNIME: Enable the Azure Data Catalog JDBC Driver in KNIME LINQPad: Working with Azure Data Catalog in LINQPad Looker Studio: Create Reports from Azure Data Catalog in Looker Studio Metabase: Create Interactive Azure Data Catalog-Connected Metabase Dashboards Microsoft SSAS: Build an OLAP Cube in SSAS from Azure Data Catalog MicroStrategy: Connect to Live Azure Data Catalog in MicroStrategy through Connect Server MicroStrategy: Use the CData JDBC Driver for Azure Data Catalog in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Azure Data Catalog in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Azure Data Catalog in MicroStrategy Web OBIEE: Azure Data Catalog Reporting in OBIEE with the Azure Data Catalog JDBC Driver pandas: Use pandas to Visualize Azure Data Catalog in Python Pentaho Report Designer: Integrate Azure Data Catalog in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Azure Data Catalog Power BI Service: Visualize Live Azure Data Catalog in the Power BI Service QlikView: Connect to and Query Azure Data Catalog in QlikView over ODBC R: Analyze Azure Data Catalog in R (JDBC) R: Analyze Azure Data Catalog in R (ODBC) RapidMiner: Connect to Azure Data Catalog in RapidMiner SAP Analytics Cloud: Analyze Azure Data Catalog in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Catalog SAP Crystal Reports: Publish Reports with Azure Data Catalog in Crystal Reports SAS: Use the CData ODBC Driver for Azure Data Catalog in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Azure Data Catalog in SAS JMP Sisense: Visualize Live Azure Data Catalog in Sisense Spago BI: Connect to Azure Data Catalog in SpagoBI Tableau: Visualize Azure Data Catalog in Tableau Desktop Tableau Cloud: Build Azure Data Catalog Visualizations in Tableau Cloud Tableau Server: Publish Azure Data Catalog-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Azure Data Catalog in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Azure Data Catalog from Spotfire Server

ETL, Replication, & Warehousing

---

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

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

Popular Data Management Tool Integrations

---

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

Workflow & Automation Tools

---

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

Our drivers and adapters provide straightforward access to Azure Data Catalog 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 Catalog in Anypoint Using SQL Power Automate: Integrate Azure Data Catalog into Power Automate Automated Tasks SSIS Import: Import Azure Data Catalog Data into SQL Server using SSIS

Developer Tools & Technologies

---

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

Data Virtualization

---

Our drivers provide a virtual database abstraction on top of Azure Data Catalog 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 Catalog Denodo: Create A Data Source for Azure Data Catalog in Denodo Platform Dremio: Connect to Azure Data Catalog as an External Source in Dremio MySQL Federated Tables: Connect to Azure Data Catalog as Federated Tables in MySQL Oracle Database: Access Azure Data Catalog as a Remote Oracle Database PostgreSQL FDW: A PostgreSQL Interface for Azure Data Catalog Salesforce Connect: Edit and Search Azure Data Catalog External Objects in Salesforce Connect SQL Server Linked Servers: Connect to Azure Data Catalog as a Linked Server SQL Server PolyBase: Connect to Azure Data Catalog as an External Data Source using PolyBase TIBCO Data Virtualization: Access Live Azure Data Catalog Data in TIBCO Data Virtualization