Teiid Designer is a metadata modeling tool intended to assist in creating, editing, managing and packaging the artifacts required for data access through a running Teiid server instance.

The following are the supported model types for Teiid Designer 7.4 release.

Relational Source Model

• Tables, Columns, Keys, Procedures, Views, etc..
• Represents structural nature of RDBS objects
• *.xmi format

Relational View Model

• Tables, Columns, Keys, Procedures, Views, etc...
• Provides complex and multi-source data integration through user-defined SQL
• *.xmi format

XML View Model

• Documents, Elements, Attributes, Mapping Classes, etc...
• XML structure backed by mapping classes (tables)  backed by complex and multi-source data integration through user-defined SQL
• *.xmi format

XML Schema Model

• Standard *.xsd files
• Backing for XML View model structure

Web Service Model

• Interfaces, Operations, Input/Output Messages, etc...
• Represents XML messaging of Web services
• Messaging backed by Operations backed by SQL querying XML View Models
• *.xmi format

Functions Model

• Scalar Functions, Input/Output Parameters
• Requires Teiid-deployed jars containing compiled java source
• Allows customization and data manipulation within view SQL
• *.xmi format

Extension Model

• Enables application of additional metadata properties on other metamodel objects
• Used by custom translators to interpret/construct full custom data
• *.xmi format