JBoss.orgCommunity Documentation
The matrix indicates for a given data source how a model can be created (Desginer Import Option) and how the data source is integrated (Translator) for data access.
The DDL Import option is an available option to build a source model for any data source. Its only indicated below when there's no specific importer created for that specific data source type.
Table A.1. Teiid Designer Supported Data Sources
| Data Source | Translator Type | Designer Import Option |
|---|---|---|
| Apache Derby | JDBC - derby | JDBC Importer |
| Files | file | File Importer |
| General JDBC | JDBC - jdbc-simple | JDBC Importer |
| HDFS (Hadoop) | hive | use DDL importer or perform modeling manually |
| HSQL | JDBC - hsql | JDBC Importer |
| H2 | JDBC - h2 | JDBC Importer |
| Ingres |
| JDBC Importer |
| IBM DB2 | JDBC - db2 | JDBC Importer |
| Informix | JDBC - informix | JDBC Importer |
| LDAP/ActiveDirectory | ldap | LDAP Importer |
| LoopBack | JDBC - loopback | use DDL importer or perform modeling manually |
| MetaMatrix | JDBC - metamatrix | JDBC Importer |
| ModeShape/JCR | JDBC - modeshape | JDBC Importer |
| Mondrian | olap | use DDL importer or perform modeling manually |
| MS Access | JDBC - access | JDBC Importer |
| MS Excel | JDBC - excel-odbc | JDBC Importer |
| MS SQL Server | JDBC - sqlserver | JDBC Importer |
| MySQL | JDBC - mysql5 (mysql) | JDBC Importer |
| Netezza | JDBC – netezza | JDBC Importer |
| Oracle | JDBC - oracle | JDBC Importer |
| PostgreSQL | JDBC - postgresql | JDBC Importer |
| Salesforce.com | salesforce | SalesForce Importer |
| SAP Gateway | ws | File Source (XML) Importer |
| SAP R/3 | ws | |
| SAP Services Registry | ws | WSDL Importer |
| Sybase ASE | JDBC - sybase | JDBC Importer |
| Teradata | JDBC - teradata | JDBC Importer |
| Teiid | JDBC - teiid | JDBC Importer |
| Web Services (SOAP/WSDL) | ws | WSDL or URL Importer |
| Web Services (Rest/OData) | ws | File Source (XML) Importer |