Home | Teiid Designer User Guide | Data Virtualization |

Teiid Designer Examples

Welcome to the Teiid Designer Examples page - our central location for Teiid Designer modeling examples and how-to articles!  The examples below are grouped according to data source type, so feel free to jump directly to your area of interest.

Sample Data
We have compiled some test data for your convenience and made it available here - Teiid Designer - Sample Data  .  This test data may prove useful while exploring the examples below.

Examples

  Relational Database - via JDBC

• Relational Database source modeling
• Relational Database source - example including Model Project Set

  Cloud Database (Azure) - via JDBC

• Access a Cloud Database (Azure) as a Source

  Flat Files

• Connect to a Flat File source
• Text File as a source - example including Model Project Set
• Remote Flat File Data Source Example

  XML Files

• Connect to XML over HTTP using Teiid

  Google Spreadsheets

• Connect to a Google Spreadsheet Source

  Microsoft Excel Spreadsheet

• Microsoft Excel Document into Relational Table

  Web Services

• Consuming Web Services as a Datasource in Teiid Designer Just Got WAY Easier!
• SOAP Service as a source - example including Model Project Set
• Expose a teiid source as a Web Service - example including Model Project Set

  Big Data

• Connect to a Hadoop source using Hive2
• Connect to a MongoDB source

  OData

• Connect to an OData source
• Producing and Consuming OData in Teiid and Teiid Designer
• Expose any source as an OData feed using Data Virtualization

  Salesforce

• Connect to a Salesforce source
• Salesforce as a REST service using Data Virtualization

  General

• Federate 2 data sources
• User-defined function (UDF) Example
• Create and deploy a web service war
• Generating a JBossWS-CXF War from Web Service Models in Teiid Designer
• Provision Data Virtualization on OpenShift and Connect from Teiid Designer