BI & Analytics

---

Our drivers offer the fastest and easiest way to connect real-time Email data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Email 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 Email in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Email in Amazon QuickSight Aqua Data Studio: Connect to Email in Aqua Data Studio Birst: Build Visualizations of Email in Birst BIRT: Design BIRT Reports on Email Clear Analytics: Build Charts with Email in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Email in DBxtra Domo: Create Datasets from Email in Domo Workbench Dundas BI: Build Dashboards with Email in Dundas BI FineReport: Feed Email into FineReport Google Data Studio: Create Reports from Email in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Email JasperServer: Create Email Reports on JasperReports Server Jaspersoft BI Suite: Connect to Email in Jaspersoft Studio JReport Designer: Integrate with Email in JReport Designer KNIME: Enable the Email JDBC Driver in KNIME LINQPad: Working with Email in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Email Power BI Online: Visualize Live Email in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Email MicroStrategy: Use the CData JDBC Driver for Email in MicroStrategy OBIEE: Email Reporting in OBIEE with the Email JDBC Driver Pentaho Report Designer: Integrate Email in the Pentaho Report Designer QlikView: Connect to and Query Email in QlikView over ODBC R: Analyze Email in R RapidMiner : Connect to Email in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Email SAP Crystal Reports: Publish Reports with Email in Crystal Reports SAP Lumira: Consume Email OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Email in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Email in Sisense Spago BI: Connect to Email in SpagoBI Tableau: Visualize Email in Tableau Tableau Online: Build Email Visualizations in Tableau Online Tableau Server: Publish and Share Email Dashboards with Tableau Server TIBCO Spotfire: Visualize Email in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Email from Spotfire Server Visio: Link Visio Shapes to Email

ETL, Replication, & Warehousing

---

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

Connect your RDBMS or data warehouse with Email 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 Email Replication to Amazon Redshift Amazon S3: Automated Continuous Email Replication to Amazon S3 Apache Cassandra: Automated Continuous Email Replication to Apache Cassandra AWS Glue: Connect to Email in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Email to SQL Server CloverDX: Connect to Email in CloverDX (formerly CloverETL) CSV: Automated Continuous Email Replication to Local Delimited Files IBM DB2: Automated Continuous Email Replication to IBM DB2 FoxPro: Work with Email in FoxPro Google BigQuery: Automated Continuous Email Replication to Google BigQuery Google Cloud SQL: Automated Continuous Email Replication to Google Cloud SQL Google Data Fusion: Pipe Email in Google Data Fusion Heroku / Salesforce Connect: Replicate Email for Use in Salesforce Connect Informatica Cloud: Integrate Email in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Email Jaspersoft ETL: Connect to Email in Jaspersoft Studio Microsoft Access: Automated Continuous Email Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Email Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Email MongoDB: Automated Continuous Email Replication to MongoDB MySQL: Automated Continuous Email Replication to MySQL Oracle Data Integrator: ETL Email in Oracle Data Integrator Oracle Database: Automated Continuous Email Replication to Oracle PostgreSQL: Automated Continuous Email Replication to PostgreSQL Replicate to CSV: Replicate Email to MySQL with PowerShell Snowflake: Automated Continuous Email Replication to Snowflake SQL Server: Automated Continuous Email Replication to SQL Server SQLite: Automated Continuous Email Replication to SQLite Talend: Connect to Email and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Email in UiPath Studio

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 Email data from a wide range of database management applications.

Popular Data Management Tool Integrations

---

DBeaver: Connect to Email in DBeaver DbVisualizer: Connect to Email in DBVisualizer DB Artisan: Manage Email in DBArtisan as a JDBC Source DB Artisan: Connect to Email in DBArtisan Informatica Enterprise Data Catalog: Add Email to Informatica Enterprise Data Catalog MySQL Workbench: Query Email in MySQL Workbench RazorSQL: Connect to Email in RazorSQL SQuirreL: Connect to Email in Squirrel SQL Client

Workflow & Automation Tools

---

Connect to Email from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Email data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, PowerApps, Talend, and many more.

Popular Workflow & Automation Tool Integrations

---

BizTalk: How to Generate SQL Command Schemas for the CData BizTalk Adapter for Email BizTalk: Configure a One-Way Send Port for the CData BizTalk Adapter for Email BizTalk: Configure a CData Email Adapter Receive Location BizTalk: Configure a Solicit-Response Send Port for Email Microsoft Flow: Automate Tasks in Microsoft Flow Using API Server Microsoft Flow: Integrate Email into MS Flow Automated Tasks Microsoft PowerApps: Design Email Power Apps Microsoft PowerApps: Integrate Live Email into Custom Business Apps Built in PowerApps MuleSoft Anypoint: Access Email in Anypoint Using SQL SSIS Export: Export Data from SQL Server to Email through SSIS SSIS Import: Import Email Data into SQL Server using SSIS SSIS Lookup: Insert New or Update Existing Email Records from SQL Server MuleSoft Anypoint: Deploy CData Mule Connectors (On-Premise or Cloud)

Developer Tools & Technologies

---

The easiest way to integrate with Email from anywhere. Our Email drivers offer a data-centric model for Email 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 Email .NET QueryBuilder: Rapidly Develop Email-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Email Apache Spark: Work with Email in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Email IFTTT Flows in Azure App Service ColdFusion: Query Email in ColdFusion DevExpress: DataBind Email to the DevExpress Data Grid EF - Code First: Access Email with Entity Framework 6 EF - LINQ: LINQ to Email EF - MVC: Build MVC Applications with Connectivity to Email Filemaker Pro: Bidirectional Access to Email from FileMaker Pro Go: Write a Simple Go Application to work with Email on Linux Google Apps Script: Connect to Email in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Email Entities in Java IntelliJ: Connect to Email in IntelliJ JBoss: Connect to Email from a Connection Pool in JBoss JDBI: Create a Data Access Object for Email using JDBI JRuby: Connect to Email in JRuby NodeJS: Query Email from Node.js NodeJS: Query Email as a MySQL Database in Node.js PHP: Access Email in PHP through the Cloud Hub PHP: Natively Connect to Email in PHP PowerShell: Pipe Email to CSV in PowerShell PowerBuilder: Connect to Email from PowerBuilder PyCharm: Using the CData ODBC Driver for Email in PyCharm Python: Connect to Email in Python on Linux/UNIX Ruby: Connect to Email in Ruby SAP UI5: Integrate Real-Time Access to Email in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Email in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Email WebLogic: Connect to Email from a Connection Pool in WebLogic

Data Virtualization

---

Our drivers provide a virtual database abstraction on top of Email 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

---

Access Linked Tables: Update Email with a Microsoft Access Linked Table MySQL Federated Tables: Connect to Email as Federated Tables in MySQL MySQL Federated Tables: Connect to Email as Federated Tables in MySQL Oracle Database: Access Email as a Remote Oracle Database PostgreSQL FDW: A PostgreSQL Interface for Email Salesforce Connect: Edit and Search Email External Objects SharePoint External List: Access Email in SharePoint External Lists SQL Server Linked Servers: Connect to Email as a Linked Server SQL Server PolyBase: Connect to Email as an External Data Source using PolyBase