JBoss Data Virtualization: Integrating with Impala on Cloudera

Red Hat is proud to announce the release of JBoss Data Virtualization (JDV) 6.4

Overview

JBoss Data Virtualization is a data integration solution that sits in front of multiple data sources and allows them to be treated as a single source, delivering the right data, in the required form, at the right time to any application and/or user.

JDV 6.4 Features

The JBoss Data Virtualization 6.4 release focuses on supporting new and updating existing cloud, big data, and in-memory data sources.

The following new features and data source integrations are added in JDV 6.4:

OSISoft PI is a real-time data historian application with a highly efficient time-series database. Customers are using PI systems to record, analyze, and monitor real-time information such as manufacturing processes and product genealogy from raw material to final product. OSIsoft PI was released as a Technical Preview with JDV 6.3 and is fully supported with JDV 6.4.

Couchbase Server is an open-source, distributed NoSQL document-oriented database that is optimized for interactive applications that may serve many concurrent users. Couchbase is available as a Developer Preview on OpenShift.

Amazon Relational Database Service (RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides resizable capacity and automates administration tasks including database setup, patching, and backups. JDV 6.4 supports the following Amazon RDS database engines: PostgreSQL, MySQL, MariaDB, Oracle, and MS SQL Server.

Amazon S3 (Simple Storage Service) is a web service offered by Amazon Web Services (AWS) that provides storage through web services interfaces (REST, SOAP and BitTorrent). JDV exposes stored procedures to leverage S3 object resources by leveraging JDV’s Web Service resource adapter. This will commonly be used to access CSV or XML formatted data or other object files stored on Amazon S3.

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes from gigabytes to petabytes. Presto was designed for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organizations like Facebook, Airbnb, and Netflix.

JDG integration improvements: JBoss Data Grid (JDG) is designed for elastic scalability and fast access to large volumes of data. In JDV 6.3, we introduced support for JDG as a materialization target (in addition to JDG as a data source that was previously available). JDG provides scalable, fast and consistent performance for externally materialized views in JDV. In JDV 6.4, we significantly simplified the configuration of JDG as both a materialization target and a data source to make this important integration even easier.

Tooling Improvements

JDV 6.4 is released with JBDSIS 11.2.0.GA and JBDS 11.2.0.GA (Eclipse Oxygen)

For JDV 6.4, we improved the usability of Teiid Designer in several areas including:

  • Consolidate data source connection management into a single view
  • VDB Editor simplifications
  • UI support for JDG 7.1 integration

Data Services Builder (DSB, Tech Preview) is a web-based user interface that allows users to easily create new data services and test them in the same tool. This tool is targeted at giving new users and developers a tool to intuitively create simple data services and query them. This tool will be Technical Preview for JDV 6.4. Note that the Eclipse-based Teiid Designer remains fully supported in addition to the DSB.

Coming Soon…

OpenShift – JDV 6.4 is in the process of being supported on OpenShift and will be available to customers in March 2018. JDV on OpenShift will allow customers to easily expose multiple heterogeneous data sources, both on-prem and in the cloud, as data services with RESTful OData API’s. Note that the Data Services Builder WebUI will be available as a Developer Preview for JDV 6.4 on OpenShift so developers can easily create data services and test them with the same tool. This release of JDV 6.4 on OpenShift will also include the simplified configuration of JDG as a materialization target for JDV.

 

Additional resources

JDV 6.4 GA is available for download from

-       Developers.redhat.com

-       Customer Portal

JDV 6.4 Documentation

JDV 6.4 Supported Configurations

JDV on Redhat.com

Last updated: October 26, 2023