We are pleased to announce the release of Data Virtualization 6.2. This is a minor release and the highlights are:
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 following table provides a list of data sources and translators that are supported by Red Hat.
- EAP 6.4 Support
- Teiid Designer usability improvements
- Kerberos passthrough for Cloudera, Oracle and MS SQL Server
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).
- Download JBDS 8.1.0 : https://www.jboss.org/products/devstudio/download/
- Add DV tooling via the JBoss Central panel select the Software/Updates tab, check JBoss Data Virtualization option and click the Install/Update button.
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 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+
|
-
|