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 | use DDL importer or perform modeling manually |
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 |