9 Replies Latest reply: Mar 15, 2012 11:52 PM by Ramesh Reddy RSS

Message Listening

Sharad Goyal Newbie

Is it possible that teiid listen to messages? Let us say someone is processing or receiveing live application xml file? I would like to refresh my teiid database or VDB based on the multiple xml received file.

 

Thanks

Sharad

  • 1. Re: Message Listening
    Ramesh Reddy Master

    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
    Sharad Goyal Newbie

    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
    Ramesh Reddy Master

    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
    Sharad Goyal Newbie

    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
    Ramesh Reddy Master

    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
    Sharad Goyal Newbie

    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
    Ramesh Reddy Master

    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
    Sharad Goyal Newbie

    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
    Ramesh Reddy Master

    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.