Version 2
Created by blafond on Mar 7, 2014 4:57 PM. Last modified by blafond on Mar 13, 2014 3:23 PM.

    Teiid provides the means (i.e., Translators and JEE connectors ) to access a variety o

     

    JDBC Data Source Information

     

    JDBC Data SourceTeiidTranslatorDesigner Import OptionHow-To DocumentConnection Profile
    OracleoracleJDBC ImporterModel JDBC data source
    PostgreSQLpostgresqlJDBC ImporterModel JDBC data source
    MySQLmysql5 (mysql)JDBC ImporterModel JDBC data source
    IBM DB2db2JDBC ImporterModel JDBC data source
    Microsoft SQL ServersqlserverJDBC ImporterModel JDBC data source
    SybasesybaseJDBC ImporterModel JDBC data source
    Microsoft AccessaccessJDBC ImporterModel JDBC data source
    DerbyderbyJDBC ImporterModel JDBC data source
    H2h2JDBC ImporterModel JDBC data source
    HSQLhsqlJDBC ImporterModel JDBC data source
    IngresingresJDBC ImporterModel JDBC data source
    InformixinformixJDBC ImporterModel JDBC data source
    MetaMatrixJDBC ImporterModel JDBC data source
    NetezzanetezzaJDBC ImporterModel JDBC data source
    TeradatateradataJDBC ImporterModel JDBC data source
    Generic ANSI SQL - for any JDBC/ODBC sourcejdbc-simpleJDBC ImporterModel JDBC data source

     

     

     

    Web Service SourceTeiid TranslatorTeiid Designer ImporterHow-To Document
    SOAP/WSDLwsWSDL or URL Importer
    REST/OdatawsFile Source (XML) Importer
    SAP GatewaywsFile Source (XML) Importer
    SAP R/3ws
    SAP Services RegistrywsWSDL or URL Importer
    Arbitrary HTTP(S)ws

     

    Odata/Big Data/No SQL/etc....TranslatorTeiid Designer ImporterHot-To Document
    Amazon Simple DBsimpledb
    Amazon Accumuloaccumulo
    Apache Cassandra DBcassandra
    Apache SOLRsolr
    Greenplumgreenplum
    Hive/Hadoophive
    Modeshape JCR Repository
    Mongo DB
    Mondrian OLAP
    Netezza data warehouse appliance
    ODataodata

     

    1. OData
    2. Enterprise Systems
    3. Object Sources
    4. LDAP
      • RedHat Directory Server
      • Active Directory
    5. Files
    6. Spreadsheets

    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.

    940 Views Categories: Tags: