9 Replies Latest reply on Mar 15, 2012 11:52 PM by rareddy

    Message Listening

      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
          rareddy

          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

            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

              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

                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

                  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

                    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

                      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

                        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

                          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.