Does anyone have experience using Microsoft’s Biztalk? In short, how does it work?

At its most basic it’s a tool for creating a data/service bus(es) for use when you need to repeat connections from systems to systems. It helps you avoid replicating connections over and over again.

The alternative is a point-to-point integration with a tool like Sequel Server Integration Services (SSIS)