How to integrate H2 in Greenplum

Discover how to integrate H2 and Greenplum and instantly get access to your data.

WITH DATA VIRTUALITY PIPES
Replicate H2 data into Greenplum and analyze it with your BI Tool.
How to integrate H2 in Greenplum with Pipes


About H2

H2 is one of the leading open-source relational database management systems written in Java. It can be embedded in Java applications as well as run in the client-server mode. The main programming APIs of H2 are SQL and JDBC, however the database also supports the usage of the PostgreSQL ODBC driver by acting like a PostgreSQL server. The database engine delivers features like a browser based console application or  a small footprint around 1.5 MB jar file size.

About Greenplum

Greenplum Database is a fully featured, advanced and open-source data warehouse and provides rapid analytics on petabyte scale data volumes. Originally based on PostgreSQL Greenplum Database has added a good number of data warehouse innovations. The database architecture provides an automatic parallelization of all queries and data.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to H2, Greenplum and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.