Windows and NET for i Series Interoperability Charles

Windows and. NET for i. Series Interoperability Charles Machalani, Solution Architect Charles. machalani@microsoft. com Karen Mc. Gregor, . NET Architect Evangelist Karen. mcgregor@microsoft. com Microsoft Canada

Microsoft. NET Software to connect information, people, systems and devices Our vision: provide the platform to rapidly build and evolve connected applications Information People Systems Devices

UI Process and UI User Interface Layers ASP. NET Web. Forms Digital Dashboard WEB BROWSER UI ASP. NET Mobile Toolkit . NET Windows Forms UI Components SMART CLIENT THIN DEVICE UI WEB UI DOCUMENT I/O UI WINDOWS UI ASP. NET Office XP OFFLINE CLIENT Sharepoint Server USER DOC WORKFLOW UI Process Components XML Web Services Outlook XP Exchange Forms MESSAGING UI Exchange Workflow COLLAB. WORKFLOW

Business Workflows, Components, Entities and Service Interfaces Services Layer Biz. Talk Messaging Biz Document Exchange MSMQ Listeners . NET Remoting & DCOM Persistent Application Service Interfaces Messaging Endpoints ASP. NET Web Services XML Web Services Biz. Talk Server Enterprise Services (Windows) . NET frameworks Business Process Automation Business Component Hosting XML Document Management Business Biz Document Transformation Workflows Long-Running Conversations Business Role-Based Security Components Distributed Transaction Mgmt Business XML-Serializable Objects Entities ADO. NET Data. Sets

Data Access and Services Agents. NET Framework Data Access Logic Components Data Access Components SQL Server ADO. NET Providers Data Other Sources Application Data SQL DB 2 VS. NET Web Proxy Biz. Talk Adaptors (300+) Service Agents Web Service Legacy Exchange 2005 Adapters WSE Messaging Data Legacy Systems LDAP XML Web Services Web. Sphere CICS CRM / ERP Other Services i. Series

. NET Roadmap 2006 2007 Database Developer Beta Windows Workflow 2005 Enterprise Library 2. 0 Beta 2005 Beta

Networking UNIX Systems Data Management Integration Identity Industry Standards Applications Languages Legacy Hosts XML Web Services

Integration Examples l Get more value from your i. Series…. Ø Ø Ø For EAI/B 2 B using Visual Studio. NET, IIS and Biz. Talk Server (inc. Host Adapters) For BI using Microsoft SQL Server 2005 Analysis and Reporting Services For BPA and Human Workflow using Biz. Talk Server 2006 and Share. Point Services

Raedschelders "This project improves our services and lays the foundation for further automation. The data on the i. Series system can be easily and immediately used for other applications from now on. " Eddy Evens, General manager, Raedschelders Offered its fifty biggest customers the ability to order online and to consult all information about deliveries and past orders via the Internet. ¢ ¢ IBM i. Series terminal based ERP application was not user-friendly and lacked agility to respond to customer needs Deploy Internet application to provide up -to-date product information and enable customers to place and follow up orders online ¢ Worked with Microsoft Certified Partner Ordina to deploy new Web interface using Microsoft® Windows Server System. TM and Host Integration Server 2004 to bridge the IBM i. Series ERP application ¢ ¢ Web Services simplified usability, improved access time to ERP data and enabled immediate response and feedback to customers i. Series data, routines and business logic are not duplicated but rather reused with the. NET environment

Deploy hosts in modern scenarios Integrated applications, web portals, smart clients Biz. Talk and. NET Biz. Talk, Windows and/or. NET connectivity ADO, OLEDB, ODBC COM, XML, Message Queuing Network Integration Data Integration Application Integration TCP/IP and SNA DDM (DRDA & RLIO), XA, TDS, CLI, DBLIB APPC, CPI-C, DPL, LUA, BMS, 3270, MQ TCP/IP and SNA Host Integration Adapters IBM z. Series mainframe & i. Series midrange resources

“Our new solution based on Microsoft. NET is helping us improve efficiency through process automation, support for workflows and work queues, and improved planning and reporting. ” Paramjit Chumber, Senior Vice President and Chief Information Officer, Countrywide Tax Services Corporation Countrywide increases productivity for tax bill procurement by 25 percent ¢ ¢ Wanted to integrate and streamline the process of obtaining tax bills AS/400 application had textbased UI and lacked basic workflow features ¢ ¢ All work was being done manually ¢ Built a new solution using the Microsoft®. NET Framework and Biz. Talk™ Server 2004 Can resolve some work automatically ¢ ¢ Supports work queue management ¢ Improves planning and reporting ¢ 4 of 56 technicians freed to do other jobs 25 percent productivity increase for remaining users 25 percent decrease in cycle times 365 hour reduction in planning time (year-to-date)

Mix people and automated processes Apps or embedded flows Share. Point BAM & SQL RS Web Services Biz. Talk Servers SQL Server Info. Path Outlook Info. Path

“With Windows Server System and the. NET Framework, we built a comprehensive solution to a pressing business problem. Now, we can influence our results instead of just reviewing them. ” Robert Fort, Director of IT, Virgin Entertainment Group, North America Entertainment retailer expects store data analysis to increase sales by $1. 8 million ¢ ¢ Wanted to analyze its daily operations data more quickly and in greater depth ¢ Needed to provide simpler way for key staff to access crucial business metrics ¢ Evaluated business intelligence software from Hyperion, Cognos, and Applix, but chose Microsoft® Windows Server System. TM as most cost-effective and easiest to use Worked with Xavor and Analysis Team to build a data-gathering and data-analysis solution ¢ ¢ ¢ Expected savings of U. S. $575, 000 over comparable solutions Expected $1. 8 million increase in overall revenue Increased store traffic from improved campaign analysis

Integration performance delivered EAI Scenarios l Marks & Spencer – 2500 msgs/sec l Lotte Magnet – 100 msgs/sec l London Drug – 52 msgs/sec B 2 B Scenarios l Akzo Nobel – 5000 msgs/sec l Osram Sylvania – 800 msgs/sec l New York Times – 140 msgs/sec >5000 customers rely on Biz. Talk for highperformance and high business value solutions

SQL Integration Services l Key Features Ø Ø Ø l ETL (Extract, Transform, Load) Error Handling & Fuzzy Logic for data cleansing DB 2 & Oracle data providers included When to use Ø Ø Ø Combining information from a group of operational databases into a data warehouse Transferring data from one DBMS to one or more other DBMSs Loading data into SQL Server databases from flat files, spreadsheets, and other diverse data sources

i. Series Customers and. NET Alticor, Sandvik, St Louis Zoo BI and data warehousing solutions in SQL 2005 using data from DB 2/400 e. Skye Self-service web-based application using Biz. Talk for i. Series integration Thomas Miller & Co. XML for claims processing, using data replication for i. Series integration Cbk Visual RPG. NET for Sales Force Automation Plus: Sinclair Broadcast Group, Piedmont Behavioural Healthcare, Lance, Hope Network, Dearborn Wholesale Grocers, Labatt Food Service, Borgata Hotel/Casino, Dell, Affiliated Computer Services, Rock-Tenn … http: //www. microsoft. com/casestudies

I Hate Making Choices l Often your scenario will require multiple patterns: Ø Aggregate bulk data from multiple stores to SQL. Enough stock? Reorder a part § Ø Receive a message through a Web Service and send to a mainframe § l SSIS and BTS WCF and HIS Shared technologies provide strong interop points

The Good News NET FW 2. 0 VS 2005 Designers Platform Interop MSMQ WCF SKU Windows Web Services SQL Server 2005 Service Broker Biz. Talk Server 2006 Support XML Windows SQL 2005 Express+ Numerous BTS 2006 Host Integration Server 2006 Numerous SQL Server 2005 Replication ODBC OLEDB SQL 2005 SKU+ SQL Server 2005 Integration Services OLEDB, ODBC Web Services SQL 2005 Standard+ HIS 2006 Comprehensive capabilities for integration on the Microsoft platform

Microsoft’s Vision l Improve the application platform Ø Ø Ø l l Make application development easier Make application deployment simpler Make application management more cost efficient Provide operational excellence Make everything universally interoperable