BizTalk integration with Informix db

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk integration with Informix db

Viewing 1 reply thread
  • Author
    Posts
    • #20005

       Just curious, what would be a good way to connect from BizTalk to an informix database? I need to perform lookups and updates in Informix ? 

      So far, I know there’s an adapter available with Attunity Inc for informix but it doesn’t work with 64bit version of informix that we use. Besides, it is way too expensive to use. Has anyone tried using the open source ODBC Adapter for BizTalk and if so, were u able to use it for Informix. This is the odbc adapter: http://blogs.msdn.com/cvidotto/archive/2006/03/22/557250.aspx

      Another option we’re considering is using IBM’s .Net data provider for Informix, but obviously it won’t work for lookups straight w/o needing some orchestration work.

      so just checking what our options are.. any advise is appreciated.

      Thanks,

    • #20057

      Unless you’re prepared to shell out a small fortune for the Attunity adapter, I would suggest you go for the ODBC adapter. I have used it briefly with Informix and it works reasonably well.

      If you go for the IBM .Net provider, I would suggest developing a custom adapter rather than invoking the provider via a helper class in an orchestration – its not best practice and can cause headaches.

      Cheers, Nick.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.