H2 data connector

Centralize access to H2 for analytics, reporting, data management, and application integration with CData Virtuality.


Start The Product Tour Request a Demo
Diagram
H2 Logo



About H2

H2 is a popular open-source relational database management system developed in Java. It can be integrated into Java applications or used in client-server mode. H2 primarily uses SQL and JDBC APIs, but also supports the PostgreSQL ODBC driver. The database engine offers features like a browser-based console and a compact 1.5 MB jar file size.

Bi-modal H2 data integration

The only bi-modal integration stack to connect replicated and live data, providing real-time data access across enterprise apps and hybrid infrastructures. CData Virtuality enables users to easily integrate H2 data with any application or process across your entire organization.

Analytics & reporting

Rapidly integrate H2 data with any of your organizations analytics or reporting processes. Access data in real-time, or leverage data movement capabilities to integrate H2 data into enterprise data pipelines.

  • Demand on data: Ensure BI tools use the most current H2 data. Query H2 data alongside other data sources through a virtual layer.
  • Integrate with BI: Seamlessly connect with tools like Tableau, Power BI, and Qlik for reporting and dashboards.
  • Enhance performance: Speed up large data processing with intelligent in-memory caching, push-down to source systems, and physical data movement to 3rd party databases for repeated queries (materialization).
Analytics & reporting
Analytics & reporting

Data integration (ETL/ELT/Rev ETL)

CData Virtuality is a powerful integration tool that combines data virtualization and automated ETL processes. Create an agile data infrastructure by extracting, integrating and processing a wide variety of data sources, including H2.

  • Automate replication: Create a copy of H2 data in a database or a cloud data warehouse and keep it up-to-date automatically.
  • Manage data changes: Synchronize H2 schema with data storage and even update it when new fields are added to replicated objects.

Automation & workflow

Enable seamless H2 data flow, automation, and orchestration across different systems through one consolidated connectivity platform

  • RPA tools integration: Integrates with Robotic Process Automation (RPA) tools like UiPath, Blue Prism, and Automation Anywhere to automate repetitive tasks and data flows involving workflow applications.
  • BPM tools integration: Connects with Business Process Management (BPM) tools like Camunda, Bizagi, and Pega to orchestrate and manage complex workflows.
Automation workflow
Data governance

Data Governance & Management

With CData Virtuality, you can establish centralized controls and audit capabilities to ensure high data quality, security, and compliance.

  • Manage access: Includes a robust permission system, customizing visibility and actions per user role.
  • Data lineage: Automatically track data journeys and transformations, clarifying origins, changes, and usage.
  • Secure data: Secure sensitive data with column masking and fine-tune access at row and column levels for privacy and compliance.
  • Track metadata: Keep a detailed history of metadata changes for effective tracking and reverting, ensuring data integrity.

H2 & data virtualization

CData's Virtuality Platform™ revolutionizes enterprise data connectivity, enabling seamless integration with any data source. With hundreds of enterprise-class data connectors — and more continually being added — CData ensures instant access to data wherever it resides. This empowers analysts and data scientists with rapid, high-performance access to all data sources, driving faster, more insightful decisions and propelling organizational agility to new heights.

Ready to get started?

Get started with CData Virtuality today