2.3. Translators in Red Hat JBoss Data Virtualization

The Amazon SimpleDB Translator, known by the type name simpledb, exposes querying functionality to Amazon SimpleDB Data Sources.

This translator provides an easy way connect to Amazon SimpleDB and provides relational way using SQL to add records from directly from user or from other sources that are integrated with Teiid. It also gives ability to read/update/delete existing records from SimpleDB store

The Red Hat JBoss Data Virtualization-specific Amazon SimpleDB Resource Adapter should be used with this translator.

The Apache Accumulo Translator, known by the type name accumulo, exposes querying functionality to Accumulo Data Sources. Apache Accumulo is a sorted, distributed key value store with robust, scalable, high performance data storage and retrieval system. This translator provides an easy way connect to Accumulo system and provides relational way using SQL to add records from directly from user or from other sources that are integrated with Teiid. It also gives ability to read/update/delete existing records from Accumulo store. Teiid has capability to pass-in logged in user's roles as visibility properties to restrict the data access.

The Red Hat JBoss Data Virtualization-specific Accumulo Resource Adapter should be used with this translator.

Support of Apache Cassandra brings support for the popular columnar NoSQL database to JDV customers.

With Apache Solr, JDV customers can take advantage of enterprise search capabilities for organized retrieval of structured and unstructured data.

You may create a delegating translator by extending the org.teiid.translator.BaseDelegatingExecutionFactory. Once your classes are then packaged as a custom translator, you will be able to wire another translator instance into your delegating translator at runtime in order to intercept all of the calls to the delegate. This base class does not provide any functionality on its own, other than delegation.

The JDBC Translator works with many relational databases.

Red Hat JBoss Data Virtualization Supported Configurations

The File Translator provides a procedural way to access the file system in order to handle text files.

The Google Spreadsheet Translator is used to connect to a Google Spreadsheet.

You can perform reads and writes to JDG. You can use it as an embedded cache or a remote cache.

The JPA translator, known by the type name jpa2, can reverse a JPA object model into a relational model, which can then be integrated with other relational or non-relational sources.

The LDAP Translator provides access to LDAP directory services.

The Loopback translator, known by the type name loopback, provides a quick testing solution. It supports all SQL constructs and returns default results, with some configurable behavior.

The Microsoft Excel Translator, known by the type name excel, exposes querying functionality to Excel documents using File Data Sources. This translator provides an easy way read a Excel spreadsheet and provide contents of the spreadsheet in the tabular form that can be integrated with other sources in Teiid.

The MongoDB translator, known by the type name mongodb, provides a relational view of data that resides in a MongoDB database. This translator is capable of converting Red Hat JBoss Data Virtualization SQL queries into MongoDB based queries. It supports a full range of SELECT, INSERT, UPDATE and DELETE calls.

The Object translator is a bridge for reading Java objects from external sources such as JBoss Data Grid (infinispan-cache) or Map Cache and delivering them to the engine for processing.

The OData translator exposes the OData V2 and V3 data sources and uses the Red Hat JBoss Data Virtualization WS resource adapter for making web service calls. This translator is an extension of the WS Translator.

The OData V4 translator, known by the type name "odata4" exposes the OData Version 4 data sources and uses the WS resource adapter for making web service calls. This translator is an extension of Web Services Translator.

The OLAP Services translator exposes stored procedures for calling analysis services backed by an OLAP server using MDX query language.

The Salesforce Translator works with Salesforce interfaces.

The SAP Gateway Translator, known by the type name sap-gateway, provides a translator for accessing the SAP Gateway using the OData protocol. This translator is extension of OData Translator and uses Teiid WS resource adapter for making web service calls.

The Web Services Translator provides procedural access to XML content by using web services.