Which is better option to use adapter or custom .net dll code. RRS feed

  • General discussion

  • Hi ,

    In my case,I want to do insert record sap to mysql through BizTalk. I downloaded Two Connect ODBC adapter for this.

    But I want to know which is better option using ODBC adapter or create stored procedure and call from .net code.

    Kind Regards

    Anurag Prajesh

    Kind Regards, Anurag Prajesh

    Friday, May 15, 2015 6:03 AM

All replies

  • One of the reasons for getting BizTalk in the first place, is all of its built-in capacities, such as the retry logic connected with all Send Ports.

    So if you want to bypass the Send Ports, my next question would be, why use BizTalk at all?

    Morten la Cour

    Friday, May 15, 2015 6:18 AM
  • Disclaimer:  I adopted the OCBC Adapter so I'm definitely bias when I say that's what you should use.

    However, as la Cour correctly points out, Adapters are how you integrate your BizTalk app with other systems so if there is an Adapter option, that is the way to go.

    Friday, May 15, 2015 11:06 AM