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 and generate build meaningful charts and reports.

  • Utilize 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.

For more information refer to our Knowledge Base article:

Google BigQuery Data in Power BI

Complex Query Processing

Most analytics, reporting, and ETL tools (for example, QlikView) allows 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.

For more information refer to our Knowledge Base article:

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 article:

Google Sheets Data in Tableau