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.
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.
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.
Choose your data sources: Google Analytics, Salesforce, Facebook, Amazon MWS and more
Move your data into a target storage: Amazon Redshift, PostgreSQL, Google BigQuery, Snowflake and more
Analyze your combined data using the Business Intelligence tools of your choice: Looker, Tableau, Excel and more
All connector bundles charged annually
2 Week Trial
Try Pipes at no cost. Full functionality. No strings attached.
Choose 1 connector
Choose up to 3 connectors
Choose up to 5 connectors
most popular option