10.2. Multi-Source Model Configuration
To mark a model as multi-source, multisource can be set to
true
and then more than one source can be listed for the model in the vdb.xml
file. The following example shows a single model dynamic VDB with multiple sources defined.
<vdb name="vdbname" version="1"> <model visible="true" type="PHYSICAL" name="Customers" path="/Test/Customers.xmi"> <property name="multisource" value="true"/> <!-- optional properties <property name="multisource.columnName" value="somename"/> <property name="multisource.addColumn" value="true"/> --> <source name="chicago" translator-name="oracle" connection-jndi-name="chicago-customers"/> <source name="newyork" translator-name="oracle" connection-jndi-name="newyork-customers"/> <source name="la" translator-name="oracle" connection-jndi-name="la-customers"/> </model> </vdb>
Note
Currently the tooling support for managing the multi-source feature is limited, so if you need to use this feature build the VDB as usual in the Teiid Designer and then edit the
vdb.xml
file in the VDB archive using a Text editor to add the additional sources as defined above. You must deploy a separate data source for each source defined in the XML file.
In the above example, the VDB defined has single model called
Customers
, that has multiple sources (chicago
, newyork
, and la
) that define different instances of data.