4 Replies Latest reply on Apr 29, 2010 2:12 PM by kgoedert

    teiid and mdm

    kgoedert

      Hi,

       

      I just started reading about mdm and data integration, and some articles say it is possible to have mdm with teiid. I have what I believe is a very common situation, where two different applications have the same data, which actually should be a single one, or a single version of the information. Is it possible to integrate the data of these applications using teiid? and mantain them synchronized?

       

      Thanks

       

      Kelly

        • 1. Re: teiid and mdm
          rareddy

          Kelly,

           

          Yes, it is possible to keep the both sources in sync. However, It really depends upon the

           

          1) Type of the sources you are trying to keep in the sync. If they both support XA, then Teiid can support any update operation in a single transaction between both sources. I am assuming you want to write the same information in the both the sources.

           

          2) Whether you can change your applications that do the updates to use Teiid instead of directly going to the source. This way Teiid provides the abstraction for your data. If your application's access is only through Teiid, then you can map the access/update strategy any way you desire.

           

          If you are looking at Teiid for repliction between two data sources to keep them in sync, it does not support that.

           

          Ramesh..

          • 2. Re: teiid and mdm
            kgoedert

            Thanks,

            your answer helped, I am probably the one totally confused after days reading about mdm "paid for" solutions that seem to be a silver bullet and one open source one that doesn't have a useful documentation. And also I don't know much about the subject. My situation is the following:
            * I have application A where I have a client record with his name, phone and company information and application B has the same information replicated on it (by replicated I mean all the data has to be entered again manually).
            I would like to have a single point where this client information could be kept (updated/deleted...) for example updating client's phone number and applications A and B would be aware of this modification or would have their data in sync with the modified one.
            Is teiid suited for this?
            • 3. Re: teiid and mdm
              rareddy

              Use the same database and schema to store the application A's data and application B's data, then you do not need Teiid. You already get the synchronization you need.

               

              If you can not use same database, then Teiid can be used to integrate the data.

               

              Ramesh..

              • 4. Re: teiid and mdm
                kgoedert

                Thanks again.

                 

                Can you recommend any article/tutorial to get me started besides teiid documentation?