Data Integration

Red Hat Integration 2019-04

Red Hat Integration

Integration Documentation Team Integration Support Team http://access.redhat.com/support

Abstract

Combine data from multiple sources so applications can connect to a single, virtual data model

Chapter 1. Overview of Data integration

Red Hat Data Integration is a container-native data virtualization service, based on the Teiid data virtualization project. Red Hat Data Integration combines data from multiple heterogeneous sources, such as relational databases, files, web services, and SaaS repositories. You deploy virtual databases as container-native services on OpenShift and design your own logical views of the data. An embedded query optimizer executes queries across your data sources so that all of your data becomes available to your applications through a single, uniform API.

For information about how to get started using Red Hat Data Integration, see the Additional Resources.

Note

Red Hat Data Integration is a Technology Preview feature only. Technology Preview features are not supported with Red Hat production service level agreements (SLAs) and might not be functionally complete. Red Hat does not recommend using them in production. These features provide early access to upcoming product features, enabling customers to test functionality and provide feedback during the development process. For more information about the support scope of Red Hat Technology Preview features, see link:https://access.redhat.com/support/offerings/techpreview/.

Available features

  • Combine data from multiple sources and types (relational, file, excel, MongoDB, and REST) into a single, customized virtual database view that provides microservice developers with live access to data.
  • Represent virtual database views in DDL (SQL + SQL/MED).
  • Enjoy fast query performance through the implementation of internally stored materialized views, which store pre-computed snapshots of join and aggregation operations that commonly against the data sources.

  • Take advantage of built-in integration with Fuse and 3scale for enterprise integration and API management.

    • Make OData APIs discoverable automatically via 3scale.
    • Automatically generate Open API definitions for OData endpoints.
  • Monitor database usage and performance in real-time via Prometheus-based metrics.
  • Securely distribute data source credentials by injecting them into the container as secrets.

Client access

  • OData/REST access for data-driven APIs.
  • ODBC/JDBC access for traditional clients to consume virtual database views for analytics.

Deployment

  • Maven-based build and deploy of your data projects.
  • Specify user-defined functions (UDFs) as Spring beans.

Limitations

  • Technology Preview 1 provides a Spring Boot-based runtime only. No GUI is available.
  • Each container can have only one virtual database. Virtual databases can have any number of views.
  • Virtual databases cannot be deployed on the Red Hat JBoss Enterprise Application Platform.
  • No access from SOAP-based clients.
  • You cannot use custom resources that are based on the Java EE Connector Architecture (JCA). If you want to use JCA resources, you must migrate them to Spring Boot equivalents.
  • Developers cannot access the ModeShape data store directly.
  • You must use DDL to define virtual databases. You cannot define virtual databases via an XML document model or in .vdb files developed in Teiid Designer.

Chapter 2. Migration from Red Hat Data Virtualization

The following list highlights key points to consider for existing Red Hat Data Virtualization customers. The list is not comprehensive, and remains subject to change.

  • A provided migration utility enables you to convert XML-based virtual databases to DDL.
  • Runtime compatibility mode for connecting virtual databases created in Red Hat Data Virtualization 6.4.
  • You might need to update custom extensions that you created for user-defined functions or user-defined aggregate functions.

Legal Notice

Copyright © 2019 Red Hat, Inc.
The text of and illustrations in this document are licensed by Red Hat under a Creative Commons Attribution–Share Alike 3.0 Unported license ("CC-BY-SA"). An explanation of CC-BY-SA is available at http://creativecommons.org/licenses/by-sa/3.0/. In accordance with CC-BY-SA, if you distribute this document or an adaptation of it, you must provide the URL for the original version.
Red Hat, as the licensor of this document, waives the right to enforce, and agrees not to assert, Section 4d of CC-BY-SA to the fullest extent permitted by applicable law.
Red Hat, Red Hat Enterprise Linux, the Shadowman logo, the Red Hat logo, JBoss, OpenShift, Fedora, the Infinity logo, and RHCE are trademarks of Red Hat, Inc., registered in the United States and other countries.
Linux® is the registered trademark of Linus Torvalds in the United States and other countries.
Java® is a registered trademark of Oracle and/or its affiliates.
XFS® is a trademark of Silicon Graphics International Corp. or its subsidiaries in the United States and/or other countries.
MySQL® is a registered trademark of MySQL AB in the United States, the European Union and other countries.
Node.js® is an official trademark of Joyent. Red Hat is not formally related to or endorsed by the official Joyent Node.js open source or commercial project.
The OpenStack® Word Mark and OpenStack logo are either registered trademarks/service marks or trademarks/service marks of the OpenStack Foundation, in the United States and other countries and are used with the OpenStack Foundation's permission. We are not affiliated with, endorsed or sponsored by the OpenStack Foundation, or the OpenStack community.
All other trademarks are the property of their respective owners.