Data Sources

Page edited by Van Halbert


Changes (2)

...
#* [XML|From Clause#XMLTABLE]
# Spreadsheets
#* [Excel|JDBC Translator#excel-odbc]
#* [Excel|Microsoft Excel Translator]
#* [Google Spreadsheet|Google Spreadsheet Translator]

...

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 Accumulo
    • Apache Cassandra DB
    • Apache SOLR
    • Greenplum
    • Hive / Hadoop
    • ModeShape JCR Repository
    • Mongo DB
    • Mondrian OLAP
    • Netezza data warehouse appliance
  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