Extend BI & Reporting To More Data
While BI & Reporting tools offer rich support for interacting with relational databases, they often come up short when working with other data sources. Included connectors are often either too slow or too limited, if they even exist.
Our connectors extend your favorite application with live access to any data source through established standards, such as ODBC or JDBC. They deliver comprehensive access to any data source and deliver breadth, depth and performance that is light-years ahead.
- Easily integrates with BI or Reporting tools, like Microsoft Power BI, Tableau, Qlik, Sisense, etc.
- Connects all of your BI applications with real-time access to 100+ Enterprise Data Sources.
Optimized for BI & Reporting
Standards-Based Drivers for ODBC, JDBC, ADO.NET and more
Our data connectivity tools support a new era of analytics and cognitive computing. Modern users demand that applications retrieve and process massive data sets at speeds that were once inconceivable, and our drivers have been specifically engineered and optimized for data-intensive reporting and analysis. Benefits include:
Dynamic Metadata Discovery
Includes intelligent rowscan, type detection, relationship exploration, support for unstructured data, and more
Robust SQL-92 Support
Seamlessly handles the most complex queries. Supports bulk operations, push-down, client functions and aggregation
High-Performance Access
With meticulous optimization down to the socket level, our drivers offer unmatched performance.
Real-Time Data
All drivers offer real-time data access with full read, write, update, and delete (CRUD) capabilities where possible.
Dynamic Metadata Discovery
Our drivers deliver metadata information based on established standards, allowing BI tools, like Power BI, to identify data fields as text, numerical, location, date/time data, and more, to help BI tools generate meaningful charts and reports.
- Use server-side functionality and intelligent row-scanning to detect data types.
- Drill into unstructured data to parse column names and data types.
- Expose existing relationships based on foreign keys or parent-child structures.
See how dynamic metadata discovery facilitates data discovery from tools like Power BI:
Google BigQuery Data in Power BI
Complex Query Processing
Most analytics, reporting, and ETL tools allow users to generate complex SQL queries to create custom datasets for visualization and reporting. CData drivers contain an embedded SQL Engine that pushes supported SQL operations to the data source and processes unsupported operations client-side.
- Issue complex queries using SQL-92 compliant operations and clauses.
- Leverage server-side data processing for supported operations.
- Build new relationships and custom datasets.
Find out why our Salesforce Drivers are superior for reporting with BI tools like QlikView:
Salesforce Data in QlikView
High-Performance Data Delivery
Thanks to optimized socket-level streaming and compression capabilities, our drivers are capable of delivering truly exceptional data access. For tools capable of connecting to live data (like Tableau), our drivers empower real-time analysis and reporting.
- Enable real-time analytics through unmatched data processing.
- Request data as quickly as possible using server-side paging and bulk capabilities.
- Employ source-specific write functionality to perform rapid inserts and updates.
For more information, refer to our Knowledge Base articles and YouTube videos:
- Couchbase Data in Tableau [4:00]
- Salesforce Data in Tableau [2:32]
- Google Sheets Data in Tableau
Knowledge Base article
Universally Accessible
ODBC, JDBC, & ADO.NET are the most widely supported interfaces for connecting applications with data. The drivers work seamlessly with:
- Aqua Data Studio
- Clover ETL
- ColdFusion
- Crystal Reports
- DBeaver
- Cognos BI
- Crystal Reports
- FileMaker Pro
- FoxPro
- Microsoft Access
- DbVisualizer
- IBM WebSphere
- Informatica
- IntelliJ
- JBoss
- Microsoft Excel
- MicroStrategy
- Oracle DB
- Power Map
- Power Pivot
- Jetty
- NetBeans IDE
- Oracle WebLogic
- RazorSQL
- QlikView
- SAP Business Objects
- SharePoint Services
- Sisense
- Tableau
- and many more...