How to connect H2 to R

Discover how to connect H2 to R and how to integrate H2 with other data sources to build an organization-wide data model.

WITH DATA VIRTUALITY PIPES
Replicate H2 into a target storage and analyze it with R.
How to connect H2 to R 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 R

R is a software environment and programming language supported by the R Foundation for statistical computing and for statistical graphics and computing. Data miners and statisticians use the language R for developing statistical software. Source code for the R software environment is primarily written in Fortran, C, and R.

What is Data Virtuality Pipes?

Data Virtuality Pipes is an easy to use data integration tool. It allows to connect with H2, R and more than 200 other cloud services and databases. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of Data Virtuality Pipes no longer have to worry about API changes. All connectors and data pipelines are fully maintained by us.

1

EXTRACT

Choose your data sources: Google Analytics, Salesforce, Facebook, Amazon MWS and more

2

LOAD

Move your data into a target storage: Amazon Redshift, PostgreSQL, Google BigQuery, Snowflake and more

3

ANALYZE

Analyze your combined data using the Business Intelligence tools of your choice: Looker, Tableau, Excel and more

PIPES PRICING

All connector bundles charged annually

2 Week Trial
unlimited connectors

FREE

Try Pipes at no cost. Full functionality. No strings attached.

Starter Bundle
Choose 1 connector

$249

/ month

Medium Bundle
Choose up to 3 connectors

$499

/ month

Large Bundle
Choose up to 5 connectors

$599

/ month

most popular option

Enterprise
Request more than 5 connectors