Microsoft Biz Talk Accelerator for SWIFT Published April

Microsoft Biz. Talk Accelerator for SWIFT Published: April 2007 Harnessing the power of SWIFT for enterprise financial messaging

Solution Overview Solution Business Challenge • Developing, implementing, and managing custom point-to-point connections for each bank that the Microsoft Treasury group communicated with was extremely expensive to design, deploy, and manage. • Microsoft implemented Biz. Talk Server 2006 and the Biz. Talk Accelerator for SWIFT to enable communication with its financial partners over the SWIFT secure IP network. Results/Benefits • • • Greater visibility into cash assets Standardized business process for end-of-day bank statements Greater security, reliability, and efficiency in communication Increased scalability Compliance with regulatory standards

Products and Technology ● ● ● Biz. Talk Accelerator for SWIFT Biz. Talk Server 2006 Office Info. Path 2006 SQL Server 2005 Windows Server 2003 Office Share. Point Server 2007

Treasury Group Operations ● ● ● Microsoft Treasury group’s responsibilities: ● Allocating resources to subsidiaries ● Reconciling transactions ● Transferring money ● Investing excess cash resources Microsoft has 1, 000+ bank accounts spread among 95 banks worldwide Managing these accounts accurately maximizes revenue

Business Challenge: Multiple Custom Connections

Business Challenge: New Banking Relationships ● ● ● Microsoft establishes new banking relationships as new markets emerge Custom point-to-point connections can be costly and take months to develop Investment of time and money may deter Microsoft from making new, advantageous partnerships with banks

Business Challenge: System Reliability and Timeliness of Data

Business Challenge: Employee Productivity ● ● ● Disparate systems for cash management and account management affected transaction reconciliation Different communication methods meant different statement formats and dispersion of data Employees spent time tracking money instead of analyzing ways to invest it

Integration Solution ● ● Treasury group reviewed its business process to identify solution requirements SWIFTNet is a highly secure and reliable network that uses standard message formats and protocols Direct integration with SWIFT provided the best way to standardize the communication process Biz. Talk Server acts as a message broker between SWIFTNet and the ERP system

Integration Solution ● ● Treasury group can view statement data stored in SAP by using a familiar interface Share. Point Server 2007 Web site is a central place for creating messages to banking partners Members access SWIFTNet by using a dedicated line and SWIFT interface products SWIFTNet advantages include a single method of communication with banking partners and standardized message formats

Integration Solution

Connectivity Through Biz. Talk Server ● Biz. Talk Server services: ● ● ● Application integration services Data normalization Orchestration services Business Rule Engine Business Activity Monitoring

Biz. Talk Accelerator for SWIFT ● A 4 SWIFT includes tools and components that enable integration with SWIFTNet ● ● ● XSD schemas for FIN messages BRE policy for FIN messages Receive pipeline disassembler component Send pipeline assembler component Orchestrations for repairing invalid messages Info. Path form templates for FIN messages

Enriched Content Through Biz. Talk Server ● ● ● SWIFTNet integration project required minimal custom coding Microsoft IT and SAP team created a Biz. Talk Server schema that represented the data structure for the SAP system Microsoft IT created a canonical schema that is used exclusively during Biz. Talk Server processing

Automation of Financial Calculations ● ● ● Microsoft IT created Biz. Talk Server maps to define how to transform data from one structure to another Functoids enrich and manipulate data as required One calculation enables automation of statement reconciliation

Custom Business Processes

Additional Orchestrations ● ● ● Microsoft IT created orchestrations for MT 995 and MT 996 message types Share. Point library is the storage location and UI for MT 995, MT 996, and MT 999 messages If a process throws an exception, the message goes to a custom exception handling process

Integration with SWIFTNet ● ● ● Biz. Talk Server coordinates and facilitates communication among the SWIFTAlliance Access device, SAP, and Share. Point Server 2007 Microsoft IT used out-of-the-box Biz. Talk Server adapters to configure the connection to each system Microsoft IT deployed a computer running Windows Server 2003 and MOSeries for Windows to solve a connection problem

Physical Design Topology

Best Practices and Lessons Learned ● ● ● Holistic approach helps create a viable solution Reusability of code saves time Use of components depends on their business value Design considerations include how components can work together in a complete solution Communicating over SWIFTNet requires learning the nuances of each banking partner

Benefits Gained ● ● ● ● Single view of enterprise assets Standardization of business processes Simplification of connectivity Reduced cost and time creating new connections Guaranteed delivery Increased scalability Reduced latency Regulatory compliance

Conclusion ● ● ● Biz. Talk Server 2006 solution resolved problems in communication methods between Microsoft and dozens of banks Benefits of a direct, standardized line of communication include reduced operating costs This implementation serves as a foundation for additional processes that will provide greater business value

For More Information ● Additional content on Microsoft IT deployments and best practices can be found on http: //www. microsoft. com ● ● Microsoft IT Showcase Webcasts http: //www. microsoft. com/howmicrosoftdoesitw ebcasts Microsoft Tech. Net http: //www. microsoft. com/technet/itshowcase

This document is provided for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS DOCUMENT. © 2007 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY. Microsoft, Biz. Talk, Info. Path, Share. Point, Windows, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.