Supported Metadata Models

Version 1

    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