Data Sources

Page edited by Steven Hawkins


Changes (34)

...

# [Databases|JDBC Translators]
#* [Oracle|Oracle Translator]
#* [PostgreSQL|PostgreSQL Translator]
#* [MySQL/MariaDB|MySQL Translators]
#* [DB2|DB2 Translator]
#* [Microsoft SQL Server|Microsoft SQL Server Translator]
#* [Sybase|Sybase Translator]
#* [Sybase IQ|SybaseIQ Translator]
#* [Microsoft Access|Microsoft Access Translators]
#* [Derby|Derby Translator]
#* [H2|H2 Translator]
#* [HSQL|HSQL Translator]
#* [Ingres|Ingres Translators]
#* [Informix|Informix Translator]
#* [MetaMatrix|Metamatrix Translator]
#* [Teradata|Teradata Translator]
#* [Vertica|Vertica Translator]
#* [Generic ANSI SQL|JDBC ANSI Translator] - for typical JDBC/ODBC sources
#* Generic ANSI SQL [Simple SQL|JDBC Simple Translator] - for any JDBC/ODBC source
# [Web Services|Web Services Translator]
#* SOAP
...
# [OData|OData Translator]
# Big Data / No SQL / Search Engines / JCR and Other Sources
#* [Actian Vector|JDBC Translators#Actian Vector in Hadoop]
#* [Actian Vector|Actian Vector Translator]
#* [Amazon SimpleDB|Amazon SimpleDB Translator]
#* [Apache Accumulo|Apache Accumulo Translator]
...
#* [Apache SOLR|Apache SOLR Translator]
#* [Apache Spark|JDBC Translators]
#* [Greenplum|JDBC Translators#greenplum]
#* [Greenplum|Greenplum Translator]
#* [Hive / Hadoop|JDBC Translators#hive] Hadoop|Hive Translator]
#* [Impala / Hadoop|JDBC Translators#impala] Hadoop|Cloudera Impala Translator]
#* [ModeShape JCR Repository|JDBC Translators#modeshape] Repository|ModeShape Translator]
#* [Mongo DB|MongoDB Translator]
#* [Mondrian OLAP|OLAP Translator]
#* [Netezza data warehouse appliance|JDBC Translators#netezza] appliance|Netezza Translator]
#* [Phoenix / HBase|JDBC Translators#hbase] HBase|Apache HBase Translator]
#* [PrestoDB |JDBC Translators#prestodb]
#* [PrestoDB |PrestoDB Translator]
# Enterprise Systems
#* [OSISoft PI|JDBC Translators#osisoft-pi]
#* [OSISoft PI|OSISoft PI Translator]
#* [SalesForce|Salesforce Translator]
#* [SAP Gateway|SAP Gateway Translator]
#* [SAP Hana|JDBC Translators]
#* [SAP Hana|SAP Hana Translator]
#* [Teiid|Teiid Translator]
# Object Sources
#* [JDG / Infinispan Library Mode |Infinispan Cache Translator]
#* [JDG / Infinispan Remote Cache Mode |Infinispan Cache DSL Translator]
#* [Intersystems Cache Object Database|JDBC Translators#intersystems-cache] Database|Intersystems Cache Translator]
#* [JPA|JPA Translator] sources
# [LDAP|LDAP 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/MariaDB
    • DB2
    • Microsoft SQL Server
    • Sybase
    • Sybase IQ
    • Microsoft Access
    • Derby
    • H2
    • HSQL
    • Ingres
    • Informix
    • MetaMatrix
    • Teradata
    • Vertica
    • Generic ANSI SQL - for typical JDBC/ODBC sources
    • Simple 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
    • Actian Vector
    • Amazon SimpleDB
    • Apache Accumulo
    • Apache Cassandra DB
    • Apache SOLR
    • Apache Spark
    • Greenplum
    • Hive / Hadoop
    • Impala / Hadoop
    • ModeShape JCR Repository
    • Mongo DB
    • Mondrian OLAP
    • Netezza data warehouse appliance
    • Phoenix / HBase
    • PrestoDB
  5. Enterprise Systems
    • OSISoft PI
    • SalesForce
    • SAP Gateway
    • SAP Hana
    • Teiid
  6. Object Sources
    • JDG / Infinispan Library Mode
    • JDG / Infinispan Remote Cache Mode
    • 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