Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
Appendix A. Configuration Information
A.1. Recommended Translators for Data Sources
The following table provides a list of data sources and translators that are supported by Red Hat.
Table A.1. Recommended Translators for Data Sources
Data Source | Driver | Translator |
---|---|---|
Actian Analytics Express 2.0
|
2.0
|
actian-vector
|
Amazon Redshift
|
postgresql 9.2
|
redshift
|
Apache Accumulo 1.5.0
|
N. A.
|
accumulo
|
Apache Cassandra 2.2.4
|
N. A.
|
cassandra
|
Apache Hive 2.0.0
|
2.0.0
|
hive
|
Apache Solr 4.9.0
|
N. A.
|
solr
|
Apache Spark 1.6.0
|
Hive 1.2.1
|
hive
|
Cloudera Hadoop 5.5.1
|
5.5.1
|
impala
|
EDS 5.x
|
current Teiid Driver
|
teiid
|
Files – delimited, fixed length
|
N. A.
|
file
|
Generic Datasource-JDBC ansi
|
N. A.
|
jdbc-ansi
|
Generic Datasource-JDBC simple (postgresql84)
|
postgresql 8.4
|
jdbc-simple
|
Greenplum 4.x
|
postgresql 9.0
|
greenplum
|
HBase 1.1
|
phoenix 4.5.1 HBase 1.1
|
hbase
|
Hortonworks Hadoop
|
2.3.4
|
hive
|
IBM DB2 10
|
4.12.55
|
db2
|
IBM DB2 9.7
|
4.12.55
|
db2
|
Informix 12.10
|
4.10.JC5DE
|
informix
|
Ingres 10
|
4.1.4
|
ingres
|
JBoss Data Grid 6.4 (library mode)
|
N. A.
|
infinispan-cache
|
JBoss Data Grid 6.4 (remote client - hotrod)
|
N. A.
|
infinispan-cache-dsl
|
LDAP/ActiveDirectory v3
|
N. A.
|
ldap
|
MariaDB
|
mysql 5.1.22
|
mysql5
|
ModeShape/JCR 3.1
|
3.8.4
|
modeshape
|
MongoDB 3.0
|
N. A.
|
mongodb
|
MS Access 2013
|
N. A.
|
access
|
MS Excel 2010
|
N. A.
|
excel
|
MS Excel 2013
|
N. A.
|
excel
|
MS SQL Server 2008
|
4.0.2206.100
|
sqlserver
|
MS SQL Server 2012
|
4.0.2206.100
|
sqlserver
|
MySQL 5.1
|
mysql 5.1.22
|
mysql5
|
MySQL 5.5
|
mysql 5.1.22
|
mysql5
|
Netezza 7.2.x
|
7.2.1.1
|
netezza
|
Oracle 11g RAC
|
12.1.0.2.0
|
oracle
|
Oracle 12c
|
12.1.0.2.0
|
oracle
|
PostgreSQL 8.4
|
postgresql 8.4
|
postgresql
|
PostgreSQL 9.2
|
postgresql 9.2
|
postgresql
|
REST/JSON over HTTP
|
N. A.
|
ws
|
RHDS 9.0
|
N. A.
|
ldap
|
Salesforce.com API 22.0
|
NA
|
salesforce
|
Salesforce.com API 34.0
|
NA
|
salesforce-34
|
SAP_Hana 1.00.102.01.1444147999
|
1.00.82.00_0394270-1510
|
hana
|
SAP Netweaver Gateway
|
odata 4
|
sap-nw-gateway
|
Sybase ASE 15
|
jconn4-26502
|
sybase
|
Sybase IQ 16 Express
|
jconn4-v7
|
sybaseIQ
|
Teradata Express 15
|
15.10.00.05
|
teradata
|
Vertica 7.2.1
|
7.2.1-0
|
vertica
|
Webservices
|
N. A.
|
ws
|
XML Files
|
N. A.
|
FILE
|
Note
MS Excel is supported in so much as there is a write procedure.
Note
The MySQL InnoDB storage engine is not suitable for use as an external materialization target.