1 / 19

Windows and .NET for iSeries Interoperability

Windows and .NET for iSeries Interoperability. Charles Machalani, Solution Architect Charles.machalani@microsoft.com Karen McGregor, .NET Architect Evangelist Karen.mcgregor@microsoft.com Microsoft Canada. Systems. People. Information. Devices. Microsoft .NET.

casta
Download Presentation

Windows and .NET for iSeries Interoperability

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Windows and .NET for iSeries Interoperability Charles Machalani, Solution Architect Charles.machalani@microsoft.com Karen McGregor, .NET Architect Evangelist Karen.mcgregor@microsoft.com Microsoft Canada

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

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

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

  5. Data Access Logic Components Service Agents Data Sources Services Other Services XML Web Services Legacy Systems Messaging Data Other Data Sources Application Data Data Access and Services Agents .NET Framework VS.NETWeb Proxy BizTalk Adaptors (300+) Data Access Components Web Service Legacy CRM / ERP ADO.NET Providers Adapters SQL Server Exchange 2005 WSE SQL DB2 LDAP WebSphere CICS iSeries

  6. Beta Database Developer Beta Beta .NET Roadmap 2007 2006 Windows Workflow Enterprise Library 2.0 2005 2005

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

  8. Integration Examples • Get more value from your iSeries…. • For EAI/B2B using Visual Studio.NET, IIS and BizTalk Server (inc. Host Adapters) • For BI using Microsoft SQL Server 2005 Analysis and Reporting Services • For BPA and Human Workflow using BizTalk Server 2006 and SharePoint Services

  9. "This project improves our services and lays the foundation for further automation. The data on the iSeries system can be easily and immediately used for other applications from now on." Eddy Evens, General manager, Raedschelders 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 iSeries 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 SystemTM and Host Integration Server 2004 to bridge the IBM iSeries ERP application • Web Services simplified usability, improved access time to ERP data and enabled immediate response and feedback to customers • iSeries data, routines and business logic are not duplicated but rather reused with the .NET environment

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

  11. “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 • Built a new solution using the Microsoft® .NET Framework and BizTalk™ Server 2004 • Can resolve some work automatically • Supports work queue management • Improves planning and reporting • Wanted to integrate and streamline the process of obtaining tax bills • AS/400 application had text-based UI and lacked basic workflow features • All work was being done manually • 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)

  12. Apps or embedded flows SharePoint BAM & SQL RS BizTalkServers Web Services SQL Server InfoPath Outlook InfoPath Mix people and automated processes

  13. “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 SystemTM 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

  14. Integration performance delivered EAI Scenarios • Marks & Spencer – 2500 msgs/sec • Lotte Magnet – 100 msgs/sec • London Drug – 52 msgs/sec B2B Scenarios • Akzo Nobel – 5000 msgs/sec • Osram Sylvania – 800 msgs/sec • New York Times – 140 msgs/sec >5000 customers rely on BizTalk for high-performance and high business value solutions

  15. SQL Integration Services • Key Features • ETL (Extract, Transform, Load) • Error Handling & Fuzzy Logic for data cleansing • DB2 & 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

  16. BI and data warehousing solutions in SQL 2005 using data from DB2/400 Alticor, Sandvik, St Louis Zoo Thomas Miller & Co. XML for claims processing, using data replication for iSeries integration Cbk Visual RPG .NET for Sales Force Automation iSeries Customers and .NET Self-service web-based application using BizTalk for iSeries integration eSkye 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

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

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

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

More Related