We
are using BizTalk for essentially the same purpose. We use it to
translate Flat File and X12 EDI invoices into a SQL database. We only
have 15 suppliers right now and are processing 15-20 files a day
(~1000-2000 invoices). It is definitely overkill for this particular
application, but we plan on using BizTalk to replace older DTS packages
on our various databases and future projects.
I found the learning curve a bit steep, but once I got over the hurdles it is very easy to work with.
BizTalk
is a great solution because of its integration with other Microsoft
technologies. We use Visual Studio for other development project so all
of our developers are familiar with the tool set. We plan on using
SharePoint services to provide system information to management and the
JDE adapaters to communicate with our ERP.
IMO if your company
uses nothing but Microsoft OS’s for desktops/servers and your
development tools are all Microsoft, why buy a tool from another
company when Microsoft makes a similar tool…probably a better tool 🙂