-
1. Re: Message Listening
rareddy Mar 15, 2012 7:02 PM (in response to goyal.sharad)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.
Ramesh..
-
2. Re: Message Listening
goyal.sharad Mar 15, 2012 7:14 PM (in response to rareddy)Ramesh
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.
Thanks
Sharad
-
3. Re: Message Listening
rareddy Mar 15, 2012 7:26 PM (in response to goyal.sharad)How is this XML file intended to be processed in Teiid? Are you trying to insert/update into couple different sources underneath?
-
4. Re: Message Listening
goyal.sharad Mar 15, 2012 7:31 PM (in response to rareddy)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.
-
5. Re: Message Listening
rareddy Mar 15, 2012 7:43 PM (in response to goyal.sharad)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?
-
6. Re: Message Listening
goyal.sharad Mar 15, 2012 7:50 PM (in response to rareddy)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?
-
7. Re: Message Listening
rareddy Mar 15, 2012 7:59 PM (in response to goyal.sharad)I think we are talking past each other. Tell me when teiid gets the email in XML, what you would like Teiid do?
-
8. Re: Message Listening
goyal.sharad Mar 15, 2012 8:06 PM (in response to rareddy)1. Teiid receives XML file
<transId>2</transId>
<transDesc>3</transDesc>
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
<response>Success</Success>
or
<response>Failure</Success>
<Reason>Failure</Reason>
-
9. Re: Message Listening
rareddy Mar 15, 2012 11:52 PM (in response to goyal.sharad)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.