Teiid Designer 7.0 did not have support for the file/ws translators. What needs to happen is that the metadata for the file procedures needs to added to model in your project. The simpliest way may be to start a Teiid server with the sample text dynamic vdb, then import the MarketData metadata from the server through the JDBC metadata importer. This should give you a model with the getTextFiles procedure. You can then switch the translator to a file translator using the TextModel-ds. Teiid Designer 7.1 should address this short coming. To make this easier for others, I think we'll post sample physical models for the text and ws translators in a wiki article, but it may take me a day or two to get to that.
Thank you Very much. The article was really helpful. Now I am trying to do the same for Web service. I created a Souce model with Invoke as procedure and "binding, request, action , endpoint and response" as procedure parameters with Result as Return type. I m just trying to query the same. I am still trying to understand on hw to query using XML table and invoke as i get query error while trying to execute for the dynamicVDB also.
That was going to be my next blog/article, again we are working on it. It may take few more days for us to come up with it. I will send out a message to the teiid-users list once it ready. Here are instructions to subscribe to it.