Over a million developers have joined DZone.

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

Build APIs from SQL and NoSQL or Salesforce data sources in seconds. Read the Creating REST APIs white paper, 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 SourceTranslatorSupported DV VersionDriver
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 brought to you in partnership with CA Technologies.  Use CA Live API Creator to quickly create complete application backends, with secure APIs and robust application logic, in an easy to use interface.

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.

The best of DZone straight to your inbox.

SEE AN EXAMPLE
Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}