How to connect H2 to IBM Cognos

Discover how to connect H2 to IBM Cognos 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 IBM Cognos.
How to connect H2 to IBM Cognos 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 IBM Cognos

IBM Cognos is an integrated, web-based business intelligence suite developed by IBM. Companies use IBM Cognos for  reporting, scorecarding, analysis and monitoring of metrics and events. Thereover IBM Cognos offers product support, certified training and educational material such as white papers, analyst papers, videos, or customer stories.

What is Data Virtuality Pipes?

Data Virtuality Pipes is an easy to use data integration tool. It allows to connect with H2, IBM Cognos 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