5 Replies Latest reply on Nov 3, 2010 5:15 PM by rareddy

    How easy/productive/performant is it going to be ?

    balaji.seshadri

      Currently we have architecture explain in the attached visio.

       

      We are pulling data from different datasource and serialize it as .ser file having java objects and load it in memory using java serialization.

       

      We use JAX-WS as our service layer to expose data.

       

      We would like to replace it with Teiid,how easy/productive/performant will it be if we replace in Teiid.

       

      We would like to replace our JAX-WS layer with teiid's webservice layer,how easy will it be.

        • 1. Re: How easy/productive/performant is it going to be ?
          balaji.seshadri

          I would explain the terminologies used in the architecture diagram.

           

          EPC- Enterprise Product Catalog.

           

          CORP - Is where some of our geographical data is stored

           

          MKTG- Marketing Data

           

          Echodata-Java API layer to access the web services(data services)

           

          Pricer,API,POET & RConnect etc are all Apps.

          • 2. Re: How easy/productive/performant is it going to be ?
            rareddy

            easy/productive = You can not beat Teiid in these respect. Teiid has done the hard work already it can save many months development (if not more) if you were to home grow the solution. Do not underestimate the complexity of data integration. We provide a flexible and well defined way integrate your sources along with tooling and monitoring etc. Ultimately, if you understand product it makes it easy and productive. Redhat is in works to provide commercial support for this project in very soon (if needed by your company to deploy in production environment).

             

            performent =  In most scenarios we can match or beat user scenarios. However since Teiid accounts for all the possible scenarios, one could always write code to match their exact usecase and might get little better numbers. We provide facilities like cost based planning, join hints, buffering, batching and caching to improve performance.

             

            Finally, it is relative to what you are comparing with? Do you have some numbers you think are better with custom coding or other products than Teiid. We are open for suggestions from our community to improve it. Just note this process is always improving and we are providing more and more features.

             

            Let me know if there is any help I can do make your decision.

             

            Ramesh..

            • 3. Re: How easy/productive/performant is it going to be ?
              balaji.seshadri

              I have been asked to evaluate the product and implement certain usecases in teiid.

               

              I have done the XML to Relational conversion for some of our templates in EPC and persisted them to database.

               

              Now i need to do some data services (web services) with the XML data as input and measure the performance with existing services.

               

              Do you guys have any step by step guide on how to create webservices ?.

              • 4. Re: How easy/productive/performant is it going to be ?
                balaji.seshadri

                Thanks for explaining things clearly by the way.

                • 5. Re: How easy/productive/performant is it going to be ?
                  rareddy

                  Balaji,

                   

                  There are couple different ways you can do the web-services stuff.

                   

                  You can code the stored procedures in Teiid using the SQL/XML that returns XML object, and write your own web-service to call/execute the procedure or you can use Designer, to generate web-service model on top of this procedure and generate the war file.

                   

                  Another way is based on a schema file, create a XML model and provide transformations to generate the needed XML, then use a web services model on top this model and expose the web service by generating the WAR file.

                   

                  Here are some links for the Web Service stuff. Also, check the Teiid Designer documentation on the XML stuff.

                   

                  http://community.jboss.org/docs/DOC-15891

                  http://community.jboss.org/docs/DOC-15978

                   

                  These are more of the consuming the web-services in the Teiid

                  http://community.jboss.org/people/jdoyle/blog/2010/10/04/modeling-soap-services-with-teiid-designer

                  http://community.jboss.org/people/jdoyle/blog/2010/10/15/modeling-soap-services-with-teiid-designer--part-ii

                   

                  My comments above may be over simplistic, however read the documents (work through the example) and play with Teiid Designer (see XML modeling) and ask us any questions if need.

                   

                  Ramesh..