Data Sources

Page edited by Steven Hawkins


Changes (23)

Teiid provides the means (i.e., [Translators] and [JEE connectors|Deploying VDB Dependencies] ) to access a variety of types of data sources. The types of data sources that are currently accessible are:

# [Databases|JDBC Translator]
#* Oracle
#* PostgreSQL
...
#* Microsoft SQL Server
#* Sybase
#* Amazon Simple DB
#* Apache Cassandra DB
#* Microsoft Access
#* Derby
#* Greenplum
#* H2
#* HSQL
...
#* MetaMatrix
#* Teradata
#* Generic ANSI SQL - for any JDBC/ODBC source
# [Web Services|Web Services Translator]
#* SOAP
#* REST
#* Arbitrary HTTP(S)
# [OData|OData Translator]
# Big Data / No SQL / Search Engines / JCR and Other Sources
#* [Amazon SimpleDB|SimpleDB Translator]
#* [Apache Cassandra DB|Cassandra Translator]
#* [Hive / Hadoop|JDBC Translator#hive]
#* [Apache SOLR|Apache SOLR Translator]
#* [Mongo DB|MongoDB Translator]
#* [ModeShape JCR Repository|JDBC Translator#modeshape]
#* [Netezza data warehouse appliance|JDBC Translator#netezza]
#* [Greenplum|JDBC Translator#greenplum]
#* [Mondrian OLAP|OLAP Translator]
# Enterprise Systems
#* [SalesForce|Salesforce Translator]
#* [SAP Netweaver Gateway|SAP Netweaver Gateway Translator]
# Object Sources
#* [JDG / Infinispan|Object Translator]
#* [Intersystems Cache Object Database|JDBC Translator#intersystems-cache]
#* [JPA|JPA Translator] sources
# [LDAP|LDAP Translator]
#* RedHat Directory Server
#* Active Directory
# [Files|File Translator]
#* [Delimited / Fixed width|From Clause#TEXTTABLE]
#* [XML|From Clause#XMLTABLE]
# Files Spreadsheets
#* Delimited / Fixed width
#* XML
#* [Excel|JDBC Translator#excel-odbc]
#* [Google Spreadsheet|Google Spreadsheet Translator]

This represents data sources that have been validated to work using the available translators and connectors. However, this does not preclude a new data source from working. It can be as easy as extending an existing translator, to creating a new translator using the [Translator Development] extensions.

This represents data sources that have been validated to work using the available translators and connectors. However, this does not preclude a new data source from working. It can be as easy as extending an existing translator in order to adapt capabilities, to creating a new translator using the [Translator Development] extensions.

Take a look at the list of [Translators] that are used as the bridge between Teiid and the external system.

Full Content

Teiid provides the means (i.e., Translators and JEE connectors ) to access a variety of types of data sources. The types of data sources that are currently accessible are:

  1. Databases
    • Oracle
    • PostgreSQL
    • MySQL
    • DB2
    • Microsoft SQL Server
    • Sybase
    • Microsoft Access
    • Derby
    • H2
    • HSQL
    • Ingres
    • Informix
    • MetaMatrix
    • Teradata
    • Generic ANSI SQL - for any JDBC/ODBC source
  2. Web Services
    • SOAP
    • REST
    • Arbitrary HTTP(S)
  3. OData
  4. Big Data / No SQL / Search Engines / JCR and Other Sources
    • Amazon SimpleDB
    • Apache Cassandra DB
    • Hive / Hadoop
    • Apache SOLR
    • Mongo DB
    • ModeShape JCR Repository
    • Netezza data warehouse appliance
    • Greenplum
    • Mondrian OLAP
  5. Enterprise Systems
    • SalesForce
    • SAP Netweaver Gateway
  6. Object Sources
    • JDG / Infinispan
    • Intersystems Cache Object Database
    • JPA sources
  7. LDAP
    • RedHat Directory Server
    • Active Directory
  8. Files
    • Delimited / Fixed width
    • XML
  9. Spreadsheets
    • Excel
    • Google Spreadsheet

This represents data sources that have been validated to work using the available translators and connectors. However, this does not preclude a new data source from working. It can be as easy as extending an existing translator, to creating a new translator using the Translator Development extensions.

Take a look at the list of Translators that are used as the bridge between Teiid and the external system.

Stop watching space | Change email notification preferences
View Online | View Changes | Add Comment