Friday, September 18, 2015

Data Virtualization 6.2 Released!

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 at https://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+
-