How to join Cloudera Impala and Informix IBM
Discover how to join Cloudera Impala with Informix IBM for integrated analysis.
WITH DATA VIRTUALITY PIPES
Replicate Cloudera Impala and Informix IBM data into one target storage and analyze it with your BI Tool.

About Cloudera Impala
Cloudera Impala is an open-source massively parallel processing (MPP) SQL query engine for data running Apache Hadoop stored in computer clusters. This ways Impala brings scalable parallel database technology to Hadoop, enabling users to issue low-latency SQL queries to data stored in HDFS and Apache HBase without requiring data movement or transformation.
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.
MOVE YOUR DATA WITH PIPES
Pipes allows you to connect to Cloudera Impala, Informix IBM 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:
- Cloud/On-Premises Hosting
- Complex Data Transformations
- Advanced Jobs & Schedules
- Multiple Target Storages
- Custom Extraction Definitions
- Job Dependencies
- SQL Modelling Layer
- Complex Replication Types
- Custom Job Triggers