none
Why BizTalk RRS feed

  • Question

  • Trying to explain to a client on the merits of BizTalk solution compared to custom .net and SQL

    Description about the project: Poll DB and do some mapping to create standard(for most part) XML messages(there are somne modification/XML flavours change based on Client needs) out. Hence I was looking a dynamic map pattern in Biztalk, so its easier or limits to just create the new maps(No orchestration changes) based on new customer and keep them isolated and reduce regression testing etc with each deploy. The solution is expected to high volume.

    Currently : Have a dynamic map orchestartion to process out message with the respective map based on client need.

    The new proposed .net/sql application is based on a template in the sql db and they create new templates faster by just repliacting templates with small mods as needed When compared to biztalk maps and xslt and deploying.

    BizTalk Benefits I can think of are: 
    Scaling out as needed., when volume goes high.
    Centralized Governance
    Error handling..

    Any other thoughts that are worth highlighting woukd be helpful.


    Raja

    Friday, July 27, 2018 4:34 PM

Answers

  • You get quite a few things out of the box with BTS

    • Ease of maintenance
    • Error handling
    • Reporting
    • Etc

    But BTS is a bit of a monolith and yes the system can be scaled easily using eg virtual servers, but still is hardware dependent and the constant patching comes with a cost

    If the client is ready for the e-train, look at Azure, Logic Apps etc, and create a highly versatile micros service achitecure which can be scaled almost instantly

    /Peter


    When asking a question please be as thoroughly as possible this will make it easier to assist you http://www.catb.org/esr/faqs/smart-questions.html

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Friday, July 27, 2018 5:53 PM
  • Your BizTalk on-premise environment is running only this processes or your application is just one of many. If your company is already paying for BizTalk hardware, I mean there is a case for simply, why not use it. I wouldn't recommend continuing with BizTalk just for this app though as the cost will offset the benefits. 

    It's still not clear when you said templates, I don't understand that, can you please elaborate. Do you mean, your .Net app will execute some stored procedure which will return an XML dataset and the mapping from SQL tables to XML will be part of the said stored procedure or it will just return the data and mapping will be done in the yours.Net app.

     If this is the case, yes definitely you will save on mapping efforts in the stored procedure (or in the .Net app), however, that is not efficient mapping, you are inherently loading your memory with the entire data and converting. i.e. you are loosing on performance when the volumes are high. Also, for.Net you need to add explicit scheduling mechanism which is an added overhead.  Also, other textbook BizTalk advantages will apply obviously.

    Integration and mapping is a native functionality of BizTalk server and going with.Net app just to save on mapping is a wrong approach because BizTalk in a way hides the challenging part of all this and do this most efficiently. In the maps, BizTalk uses XSLCompiledTransform which is very efficient http://www.quicklearn.com/blog/2017/03/02/usingxslcompiledtransform/

    Mark it as Answer OR Please Vote as Helpful by clicking the upward arrow mark 

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Friday, July 27, 2018 6:27 PM
  • Hi,

    Custom .NET/SQL vs BizTalk will always been a debating topic, from Integration Vision perspective here are complete list of features BizTalk contains.

    Note: according to market research Microsoft BizTalk have 16% market share in Integration World which is impressive figure(https://discovery.hgdata.com/product/biztalk-server and https://idatalabs.com/tech/products/biztalk-server)

    • It is basically an Integration server with inbuild adapters for communication. It helps in Integrating Enterprise Applications at one common point.
    • Solutions can be developed really fast with BizTalk Server. Effort spent will be less.
    • Support, Maintenance and updates are easy to manage and maintained.
    • Its provide guaranty that message will never loss in BizTalk if any technical issue occurs.
    • It has retried mechanism as well as alternative transport mechanism for message processing.
    • BizTalk is designed to operate in Multi Server Environment. We can run the application on various servers to manage load and highly Availability.
    • Advantage for customers on cost saving in terms of development time.
    • BizTalk has BAM Portal (Business Activity Monitoring Portal) to tracking the message information inside the BizTalk for the Business guys.
    • BizTalk has a number of Tools like BRE, SSO which be effectively used.
    • It can be used to communicate with wide range of Legacy Applications. There is always a scope to develop custom

    HTH


    Hope this Helps!!!! Regards, Note: Please Mark As Answered if you satisfy with Reply.

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Saturday, July 28, 2018 1:51 PM

All replies

  • You get quite a few things out of the box with BTS

    • Ease of maintenance
    • Error handling
    • Reporting
    • Etc

    But BTS is a bit of a monolith and yes the system can be scaled easily using eg virtual servers, but still is hardware dependent and the constant patching comes with a cost

    If the client is ready for the e-train, look at Azure, Logic Apps etc, and create a highly versatile micros service achitecure which can be scaled almost instantly

    /Peter


    When asking a question please be as thoroughly as possible this will make it easier to assist you http://www.catb.org/esr/faqs/smart-questions.html

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Friday, July 27, 2018 5:53 PM
  • Your BizTalk on-premise environment is running only this processes or your application is just one of many. If your company is already paying for BizTalk hardware, I mean there is a case for simply, why not use it. I wouldn't recommend continuing with BizTalk just for this app though as the cost will offset the benefits. 

    It's still not clear when you said templates, I don't understand that, can you please elaborate. Do you mean, your .Net app will execute some stored procedure which will return an XML dataset and the mapping from SQL tables to XML will be part of the said stored procedure or it will just return the data and mapping will be done in the yours.Net app.

     If this is the case, yes definitely you will save on mapping efforts in the stored procedure (or in the .Net app), however, that is not efficient mapping, you are inherently loading your memory with the entire data and converting. i.e. you are loosing on performance when the volumes are high. Also, for.Net you need to add explicit scheduling mechanism which is an added overhead.  Also, other textbook BizTalk advantages will apply obviously.

    Integration and mapping is a native functionality of BizTalk server and going with.Net app just to save on mapping is a wrong approach because BizTalk in a way hides the challenging part of all this and do this most efficiently. In the maps, BizTalk uses XSLCompiledTransform which is very efficient http://www.quicklearn.com/blog/2017/03/02/usingxslcompiledtransform/

    Mark it as Answer OR Please Vote as Helpful by clicking the upward arrow mark 

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Friday, July 27, 2018 6:27 PM
  • Hi,

    Custom .NET/SQL vs BizTalk will always been a debating topic, from Integration Vision perspective here are complete list of features BizTalk contains.

    Note: according to market research Microsoft BizTalk have 16% market share in Integration World which is impressive figure(https://discovery.hgdata.com/product/biztalk-server and https://idatalabs.com/tech/products/biztalk-server)

    • It is basically an Integration server with inbuild adapters for communication. It helps in Integrating Enterprise Applications at one common point.
    • Solutions can be developed really fast with BizTalk Server. Effort spent will be less.
    • Support, Maintenance and updates are easy to manage and maintained.
    • Its provide guaranty that message will never loss in BizTalk if any technical issue occurs.
    • It has retried mechanism as well as alternative transport mechanism for message processing.
    • BizTalk is designed to operate in Multi Server Environment. We can run the application on various servers to manage load and highly Availability.
    • Advantage for customers on cost saving in terms of development time.
    • BizTalk has BAM Portal (Business Activity Monitoring Portal) to tracking the message information inside the BizTalk for the Business guys.
    • BizTalk has a number of Tools like BRE, SSO which be effectively used.
    • It can be used to communicate with wide range of Legacy Applications. There is always a scope to develop custom

    HTH


    Hope this Helps!!!! Regards, Note: Please Mark As Answered if you satisfy with Reply.

    • Marked as answer by Sax001 Monday, July 30, 2018 6:57 PM
    Saturday, July 28, 2018 1:51 PM