14.3. Multi-Source Binding Support

Teiid Designer allows you to define relational source models and binding them to multiple data sources.

Use Multi-source models to quickly access data in multiple sources with homogeneous metadata. When you have multiple instances using identical schema, Red Hat JBoss Data Virtualization can help you gather data across all the instances, using "multi-source" models. In this scenario, instead of creating/importing a model for every data source, one source model is defined to represents the schema and is configured with multiple data "sources" underneath it. During runtime when a query issued against this model, the query engine analyzes the information and gathers the required data from all sources configured and gathers the results and provides in a single result. Since all sources utilize the same physical metadata, this feature is most appropriate for accessing the same source type with multiple instances.

The VDB Editor's Models tab contains a simplified model table on the left and a new tabbed panel on the right containing Model Details and Source Binding Definition tabs. Click the Multi-source check box if you wish to add additional source bindings.