3 Replies Latest reply on Nov 16, 2011 11:01 AM by Julio Faerman

    Encapsulation

    Julio Faerman Novice

      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?