Integration scenarios are usually very diverse and it’s difficult to find a one-size fits all solution, even in the same platform. So here are the various flavors available on the Microsoft platform.
- Data extraction, transform, and load (ETL) – SQL Server Integration Services (SSIS)
- Data replication between systems – SQL Server Replication
- User provisioning – Microsoft Identity Lifecycle Manager 2010
- Business integration scenario (standards based B2B or Enterprise Application Integration) using a message-delivery model; single-sign-on; business process automation – Microsoft BizTalk Server
- Integrate date from external systems with your portal – SharePoint Business Connectivity Services