So, the XML file is data file? if that is case then when you update the file on the disk, the next time you issue the query against it, it will have the new results if you did not cache the results. If not you would have explain the usecase little more.
The user is submitting new transaction in every 5-10 minutes in an xml file. We would like to receive these transactions automatically and process it. Let me know if you need more details.
How is this XML file intended to be processed in Teiid? Are you trying to insert/update into couple different sources underneath?
Currently I just want to see the new data coming in asynchronous mode in table format however in future I might want to insert/update data underneath.
Reading the XML data as relational table is already you can do with Teiid, as long as you keep replacing the XML file, in the location you configured you will get the new data each time you submit a query. However, do want to read the data from Teiid in async mode? Explain the client application interaction you have in mind that is reading the data from Teiid?
Let me specify a very simple example. I am sending xml file by email to teiid. What you are saying in that case I will loose my old data. Right?
I think we are talking past each other. Tell me when teiid gets the email in XML, what you would like Teiid do?
1. Teiid receives XML file
2. The teiid will refresh table by making new entry in trans_table
3. Teiid confirms successfully delivery of transaction receiving
4. Send a response back with sucess or failure
What you need to JBoss ESB. You can use any database in place of Teiid. Teiid is data integration engine, it does not keep data for tables, it translates and integrates the data from multiple sources at its core.