Architecture selection
Each solution has benefits and risks that we can use to make a final decision.
|
BizTalk Server | |
|---|---|
|
Benefits Out-of-the-box adapters to multiple target formats, including SQL Server and Oracle database Reliable messaging infrastructure which can guarantee message delivery Architecture built to support routing messages based on content |
Risks Lack of in-house expertise will require extensive training of both the developer and operations staff Would take longer to build and deploy solutions that are purely code-based |
|
SQL Server | |
|
Benefits Leverages in-house expertise with SQL Server tools Encourages master data approach which provides a unified frontend to clients Can natively communicate with our target database formats |
Risks Incapable of processing real-time data requests Different implementation techniques based on the type of target database |
|
WCF and Windows Server AppFabric | |
|
Benefits Rapid, lightweight way to build service-oriented solutions Built... |
