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,