Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Data Virtualization 6.2 Released!

DZone's Guide to

Data Virtualization 6.2 Released!

Data Virtualization 6.2 is out! New features include Teiid Designer improvements, Kerberos passthrough, and EAP 6.4 compatibility.

· Integration Zone
Free Resource

Modernize your application architectures with microservices and APIs with best practices from this free virtual summit series. Brought to you in partnership with CA Technologies.

We are pleased to announce the release of Data Virtualization 6.2. This is a minor release and the highlights are:

  • EAP 6.4 Support
  • Teiid Designer usability improvements
  • Kerberos passthrough for Cloudera, Oracle and MS SQL Server

You can download the product from http://www.jboss.org/products/datavirt/download/ or from the Customer Support Portal (CSP) at https://access.redhat.com/.   You will also need to download EAP 6.4 and the EAP 6.4.3 roll up patch to install DV 6.2.  Also you can access the updated documentation at https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Virtualization/6.2/index.html


To install Data Virtualization 6.2:

1. Install EAP 6.4 after downloading from http://www.jboss.org/products/eap/download/

2. Install the EAP 6.4.3 roll up patch from the Customer Support Portal https://access.redhat.com/jbossnetwork/restricted/softwareDownload.html?softwareId=39353

3. Install DV 6.2 after downloading from the above link.


The Data Virtualization 6.2 tooling (Teiid Designer 9.0.3.Final) is available.  Note that testers have verified this Designer version with JBDS 8.1.0 (Eclipse Luna).  

  1. Download JBDS 8.1.0 : https://www.jboss.org/products/devstudio/download/
  2. Add DV tooling via the JBoss Central panel select the Software/Updates tab, check JBoss Data Virtualization option and click the Install/Update button.

You could also install Teiid Designer 9.0.3 into an 8.0/8.1 version using this update site https://devstudio.redhat.com/updates/8.0/

To help you get started we created a getting started example with CSV and XML sources in a customer context scenario. Run one of 3 options to get you started easily.

  • Run with JBDS
  • Run without JBDS
  • Run with Docker  

The Teiid Project is included in the repository so you can take a look at the views and preview data before deployment.  Take a look athttps://github.com/jbossdemocentral/dv-gettingstarted and get started with Data Virtualization 6.2.  


The following table provides a list of data sources and translators that are supported by Red Hat.


Data Source Translator Supported DV Version Driver
Apache Hive 12 - 6.0+ -
Apache Solr solr 6.1+ -
Cloudera Hadoop - 6.1+ -
EDS 5.x teiid 6.0+ -
Files – delimited, fixed length file 6.0+ -
Generic Datasource-JDBC ansi jdbc-ansi 6.0+ -
Generic Datasource-JDBC simple (postgresql84) jdbc-simple 6.0+ -
Google Spreadsheet - 6.0+ -
Greenplum 4.x postgresql 6.0+ -
Hortonworks Hadoop - 6.1.+ -
HSQL (for test/examples only) - - -
IBM DB2 10 db2 6.1+ Universal Driver v4.x
IBM DB2 9.7 db2 6.0+ Universal Driver v4.x
Ingres 10 ingres 6.0+ -
Intel Hadoop - 6.1+ -
JBoss Data Grid 6.4 (remote client - hotrod) infinispan-cache-dsl 6.2+ -
JBoss Data Grid 6.4 (library mode) infinispan-cache 6.0 - post GA, 6.1+ -
LDAP/ActiveDirectory v3 ldap 6.0+ -
Mainframe (CICS,IMS,VSAM) - 6.0+ -
MariaDB mysql5 6.1+ -
ModeShape/JCR 3.1 - 6.0+ -
MongoDB 2.2 mongodb 6.0 - post GA, 6.1+ -
MS Access 2010 - 6.0+ -
MS Access 2013 - 6.0+ -
MS Excel 2010 excel 6.0+ -
MS Excel 2013 excel 6.0+ -
MS SQL Server 2008 sqlserver 6.0+ Microsoft SQL Server JDBC Driver 4
MS SQL Server 2012 sqlserver 6.0+ Microsoft SQL Server JDBC Driver 4
MySQL 5.1 mysql5 6.0+ V5.1
MySQL 5.5 mysql5 6.0+ V5.5
Netezza 6.0.2 netezza 6.0+ -
Oracle 10g R2 oracle 6.0+ Oracle JDBC Driver v10
Oracle 11g RAC oracle 6.0+ Oracle JDBC Driver v11
Oracle 12c oracle 6.0 - post GA, 6.1+ Oracle JDBC Driver v12
PostgreSQL 8.4 postgresql 6.0+ -
PostgreSQL 9.2 postgresql 6.0+ -
REST/JSON over HTTP ws - -
RHEL 5.5/6 PostgreSQL config - 6.0+ -
Salesforce.com API 22 salesforce 6.0+ -
SAP Netweaver Gateway (OData) sap-nw-gateway 6.1+ -
Support SAP Service Registry as a Data Source - 6.2+ -
Sybase ASE 15 sybase 6.0+ jConnect JDBC3.0 v7
Teradata Express 12 teradata 6.0+ -
Webservices ws 6.0+ -
XML Files FILE 6.0+ -

The Integration Zone is proudly sponsored by CA Technologies. Learn from expert microservices and API presentations at the Modernizing Application Architectures Virtual Summit Series.

Topics:
integration ,ei ,enterprise integration

Published at DZone with permission of Kenneth Peeples, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}