How to connect Informix IBM to Pentaho

Discover how to connect Informix IBM to Pentaho and how to integrate Informix IBM with other data sources to build an organization-wide data model.

WITH PIPES OR PIPES PROFESSIONAL
How to connect Informix IBM to Pentaho with Pipes
WITH THE LOGICAL DATA WAREHOUSE
How to connect Informix IBM to Pentaho with Logical Data Warehouse


About Informix IBM

  IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix server supports the object-relational model, which has permitted IBM to offer extensions that support data types that are not a part of the SQL standard. The most widely used of these are the time series and spatial extensions, which provide both data type support and language extensions that allow high performance domain specific queries and efficient storage for datasets based on time series and spatial data.

About Pentaho

Pentaho provides Business Intellingence solutions with a community and an enterprise edition. Users can create reportings and factful dashboards as well as run data mining and extract, transform, load (ETL) processes with Pentaho.

What is Data Virtuality?

Data Virtuality enables companies to build an agile BI stack in 1 day. It connects to Informix IBM, Pentaho and more than 200 other databases and cloud services. All connected data sources can be directly queried with SQL and data can be moved into any analytical database. Customers of the Data Virtuality Logical Data Warehouse are digital businesses with the highest flexibility needs.

IMMEDIATE DATA ACCESS

Connect over 200+ databases, cloud services and files (XML, CSV, etc.) in minutes. Query data directly with your favourite business intelligence and analysis tools.

CENTRAL DATA MODEL

Build your single source of data truth and set uniform definitions for your data. Connect your business intelligence tools to Data Virtuality and make sure everyone in your organisation works with the right data.

ALL IN SQL

With Data Virtuality you can query all data sources with SQL regardless of the file format. NoSQL, CSV or XML File: We transform any connected data source in SQL.

REAL-TIME REPORTING

Data Virtuality controls the exchange of data between all databases, cloud services, and analysis tools to help everyone in your organization get the right information, in real-time if needed.