Tuesday, July 21, 2015

Tested Integrations for Data Virtualization

Every JBoss® Data Virtualization (JDV) release is tested and supported on a variety of market-leading operating systems, Java™ Virtual Machines (JVMs), and database combinations. In addition, Red Hat provides a tool to help plan your JBoss Data Virtualization deployment JBoss Data Virtualization Sizing Architecture Tool

The following databases and database drivers were tested as part of the JBoss Data Virtualization release process for use as a persistence store for platform components. A persistence store is used by product components to store state or other information. Product components include the ModeShape hierarchical database, S-RAMP repository and Teiid/JDV external materialized views.

DatabasesJDBC Driver
IBM DB2 9.7IBM DB2 JDBC Universal Driver Architecture 4
Oracle 12cOracle JDBC Driver v12
Oracle 11gOracle JDBC Driver v11
MySQL 5.5MySQL Connector/J 5
Microsoft SQL Server 2012Microsoft SQL Server JDBC Driver 4
Microsoft SQL Server 2008 R2 SP2Microsoft SQL Server JDBC Driver 4
PostgreSQL 9.2JDBC4 Postgresql Driver, Version 9

The following were tested as part of the JBoss Data Virtualization release process as data sources that may be accessed through the platform.

Data sourceDatabase Driver/Supported Interface/Notes
Oracle 12cOracle JDBC Driver v12
Oracle 11g R2Oracle JDBC Driver v11
Oracle 10g R2Oracle JDBC Driver v10
IBM DB2 9.7IBM DB2 JDBC Universal Driver Architecture v4
Microsoft SQL Server 2008, 2012Microsoft SQL Server JDBC Driver 4
Sybase ASE 15jConnect for JDBC3.0 v7
MySQL 5.5mysql-connector-java v5.5
MySQL 5.1mysql-connector-java v5.1
PostgreSQL 9.2JDBC4 PostgreSQL Driver, Version 9.2
PostgreSQL 8.4JDBC4 PostgreSQL Driver, Version 8.3
Teradata 12Teradata JDBC driver, v13.00
Netezza 6.0.2Netezza JDBC driver, v6
Greenplum Database 4.1JDBC3 PostgreSQL Driver, Version 8.3
Ingres 10Ingres JDBC driver, v3.0
MongoDB v2.4via Teiid MongoDB resource adapter
Apache Cassandra 2.1 (technical preview)via Teiid Cassandra resource adapter
JBoss Data Grid 6.4via Data Grid HotRod client
JBoss Data Services Platform 5.xJBoss Data Services Platform (Teiid) JDBC Driver
MetaMatrix 5.5.4MetaMatrix 5.5.4 JDBC Driver
LDAP 3via Teiid LDAP resource adapter
Salesforce.comAPI version 22
SAP NetWeaver GatewayOData + SAP Annotations for OData v2.0
ModeShape Hierarchical Databasevia bundled ModeShape JDBC driver
FilesDelimited and Fixed-length
XML Files
XML over HTTPHTTP 1.1
SOAP Web ServicesSOAP 1.1, WSDL 1.2
Cloudera CDH 5v2.1 Impala JDBC Driver
v0.13, 0.14 Hive JDBC Driver
Hortonworks Data Platform 2v0.13, 0.14 Hive JDBC driver
Apache Hive 0.12, 0.13, 0.14v0.12, 0.13, 0.14 Hive JDBC driver
Google Spreadsheetsvia Teiid Google resource adapter
Microsoft Excel 2010Apache POI
Microsoft Access 2010JDBC-ODBC bridge driver