Encapsulation

[jmfaerman]

Reading the quick start guide i noticed that teiid uses specific text-file funcions to load them as tables:

select product.symbol, stock.price, company_name from product, (call MarketData.getTextFiles('*.txt')) f, TEXTTABLE(f.file COLUMNS symbol string, price bigdecimal HEADER) stock where product.symbol=stock.symbol

Is it possible to define this in the configuration (instad of in the query) so that if this data source changes from text file to a RDBMS i do not have to change the client?

[rareddy]

Julio,

The exact usecase as you define, no you can not do that. However there may be other options available. Can you explain your usecase in detail, so that we can see if there any other options available in Teiid.

Thanks

Ramesh..

[shawkins]

Julio,

You would use a view to encapsulate the details of a query from a client.  That is not yet possible with dynamic vdbs, which is what Ramesh is indicating.  But you can use Teiid Designer to create a full virtual database containing whatever view layers you may need to abstract the access details.

Steve

[jmfaerman]

Teiid designer made things much more clear and the view models will work for me, thanks a lot.