3 Replies Latest reply on Nov 29, 2010 11:27 AM by shawkins

    Does Teiid support auto-update/auto-delete if there are many third-party systems?

    jalen

      For example, the Teiid connect to many third-party systems like that:

      Snap1.jpg

       

      So when updating/deleting data using Teiid, does Teiid internally know which systems to update/delete? Or User must mannually write in the update/delete procedure of Teiid to retrieve the data? What would happen if Teiid uses WS to retrieve/update data from/to third-party systems?

        • 1. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
          rareddy

          Jalen,

           

          Teiid can help you configure the systems the way you have shown, however you would have write the view layer with Teiid provided tools to define the behavior. There is nothing automatically happening, you would have to manually define them.  The source system can be relational database or web-service it depends upon your usecase, and you can use any type of source systems.

           

          By the way were you not doing usecase already with web-services for which we have been answering questions? I am confused as what is new you are bringing to this thread? If I am misinterpreting something please let me know.

           

          Thanks

           

          Ramesh..

          • 2. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
            jalen

            Remesh,

             

            Thanks for your patience.

             

            We have tried the Web-Service. This problem is related to multi-systems instead of Web-Service connector.

             

            Our current solution for multi-systems is to write the following procedures in every "base table":

            if(data from system1)

                 begin

                      --(every system has its own schemas)

                 end

            else if(data from sytem2)

                 begin

                      ...

                 end

            else if(...)

            ...

             

            This solution means if we want to add a new third-party system, we have to change every "base table" to add the "else if" clause. It is bothering. So we ask this question here.

             

            Thank you.

            • 3. Re: Does Teiid support auto-update/auto-delete if there are many third-party systems?
              shawkins

              Please see https://jira.jboss.org/browse/TEIID-1349 and https://jira.jboss.org/browse/TEIID-1351 for upcoming enhancments to update processing.  If your scenario is described by TEIID-1349, then we'll be able to handle the update automatically.  If it's not (cascading deletes, multiple table updates, check option, etc.), there's still time to get in an enhancement request.

               

              Steve