1 / 26

ASI301-IS Connecting SharePoint Server to Existing Investments in IBM Legacy Applications and Data

ASI301-IS Connecting SharePoint Server to Existing Investments in IBM Legacy Applications and Data. Guy Van Roy , TSP, Microsoft Belgiu m Paul Larsen , PUM, Microsoft Corporation Jon Fancey , Partner, Affinus , UK. Connectivity to Valued Host Assets. Consumers. Services. Customer

ashton
Télécharger la présentation

ASI301-IS Connecting SharePoint Server to Existing Investments in IBM Legacy Applications and Data

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. ASI301-IS Connecting SharePoint Server to Existing Investments in IBM Legacy Applications and Data Guy Van Roy, TSP, Microsoft Belgium Paul Larsen, PUM, Microsoft Corporation Jon Fancey, Partner, Affinus, UK

  2. Connectivity to Valued Host Assets Consumers Services Customer Care SQL Server Analysis Reporting SharePoint Programs Security TellerRegister Messages WebServices BizTalk Network Data Marketing Sales Dynamics Internet Information Services Mobile

  3. Enterprise Integration Scenarios MicrosoftSQL Server MicrosoftOffice SharePoint Server Microsoft BizTalk Server Trusted, Productive, Intelligent Data Platform Connecting Systems and Orchestrating Process Connecting People Process and Information Program Integration Message Integration Data Integration Send and Receive Messages Call and Automate Programs Read and Write Data Messaging Systems Batch and Transaction Processing Systems Database Management and File Systems

  4. Microsoft SharePoint Server 2010 • Custom code • Develop components (VS, BTS, SSIS) for connectivity, optionally with data aggregation, transformation, security • Use custom code to integrate data into any Office app • Include business logic in forms • Create reusable custom Web Parts and Workflow Activities • Customize • Automate task flows using Workflow Activities connected to WCF Services • Connect Web Parts to BizTalk Server,Databases, SOAP (XML and WCF) Services, REST Services, XML Files, Linked Data, using Business Connectivity Services (BCS) • Out-of-box • Publish connected info from Office apps (InfoPath, PowerPivot ) • Connect Web Parts to SQL Server, and then join data using Distributed Queries Intermediate Advanced Beginner NO CODE* CODE SharePoint Designer SharePointSDK Visual Studio Power User Developer Advanced Developer

  5. Connecting to Host Databases WCF Data Service DB2 Database DB2 Database DB2 Database PowerPivot for SharePoint Data Provider for DB2 (DRDA AR) Distributed Data Facility (DRDA AS) Optimized Server for DDM (DRDA AS) UDB Server (DRDA AS) TCP/IP SNA Services CommunicationsServer for z/OS CommunicationsServer for i5/OS HPR/IP Windows Server 2008 Windows Server 2008 IBM z/OS , i5/OS, Server OSs

  6. WCF Data Service for DB2 demo

  7. Connecting to Host Databases Microsoft Windows Server 2008 R2 IBM z/OS Relational Database Management System Catalog and Schemas Packagesand Sections Data Tables and Views Procedures EntityProvider BizTalk Adapter .NET App Office SQLServer SQL Engine ADO.NET OLE DB Distributed Data Facility (DDF) Service Components (Pooling, Security, Transactions) .NET Data Provider for DB2 OLE DB Provider for DB2 Metadata Microsoft Client for DB2 (DRDA AR) Enterprise SSO IBM RACF Security for z/OS CA eTrust CA-ACF2 CA eTrust CA-Top Secret Convert SNANLS SNA Services Comm Server WinAPPC WinSocket Socket APPC HPR/IP TCP/IP TCP/IP HPR/IP

  8. Connecting to Host File Systems PowerPivotfor Excel SAM, VSAM, BPAM Datasets Physical and Logical Files PowerPivot for SharePoint Data Provider for Host Files (DDM Client) Distributed File Manager(DDM Server) Optimized Server for DDM(DDM Server) TCP/IP CommunicationsServer for i5/OS CommunicationsServer for z/OS SNA Services HPR/IP Windows Server 2008 Windows Server 2008 IBM i5/OS and z/OS

  9. Connecting to Host File Systems • Windows Server 2008 R2 • IBM z/OS Systems Management Storage BSAM QSAM ESDS KSDS RRDS Altldx PDS PDSE ADO.NET Application BizTalk Adapter SQL Server Office SequentialAccess Method (SAM) Virtual Storage Access Method(VSAM) Basic PartitionedAccess Method(BPAM) ADO.NET OLE DB Distributed File Manager (DFM) Record-Level Input/Output (RLIO) Engine Service Components (Pooling, Security) Data Facility Storage Management Subsystem (DFSMS) ADO.NET Data Provider for Host Files OLE DB Provider for AS/400 and VSAM Metadata Microsoft Client for Host Files (DDM RLIO Client) ESSO Convert IBM RACF Security for z/OS CA eTrust CA-ACF2 CA eTrust CA-Top Secret SNANLS SNA Services Comm Server WinAPPC APPC HPR/IP HPR/IP

  10. Data Integration • Scalability and Performance • Multiple row input with DB2 for i5/OS • Connection pooling with distributed units of work • Connection and command timeout • Platforms and Locales • Hebrew bi-directional layout conversion • Read BLOB and CLOB data using OLE DB • Connectivity to IMS/DB v11 and Informix v11 • Security and Administration • Encryption using SSL and TLS (DB2 and Host Files) • Advanced Encryption Standard (AES) • Client accounting and load balancing

  11. Program Integration i5/OS Program (CALL PGM) SharePointBusiness Connectivity Services WCF Service CICS Program(EXEC CICS LINK) IMS Program SOAP Optimized Server for Remote Program Call TransactionIntegrator CICS IntersystemCommunications IMS Connect TCP/IP SNA Services CommunicationsServer for z/OS HPR/IP Windows Server 2008 Windows Server 2008 IBM z/OS and i5/OS

  12. WCF Service for CICS demo

  13. Connecting to Host Programs Windows Server 2008 R2 IBM z/OS Transaction Processing Systems WCF Service XML WebService • BizTalk Adapter .NETApplication CICS Inter-System Communications EXEC CICS Link CICS Transaction Program Transaction Integrator Runtime IMS Connect IMS TransactionProgram Metadata Transaction IntegratorProtocol Clients EnterpriseSSO Convert SNANLS IBM RACF Security for z/OS CA eTrust CA-ACF2 CA eTrust CA-Top Secret SNA Services Comm Server WinAPPC WinSocket Socket APPC HPR/IP TCP/IP TCP/IP HPR/IP

  14. Connecting to Host Programs • New features • Edited Numeric types • HTTP connectivity to CICS/VSE • Encryption using SSL and TLS for IMS and i5/OS • Improved technologies and tools • Runtime (managed SNA connectivity) • Design time (import wizard) • Testing (host simulator)

  15. Host Programs Connecting to Windows CICS PanelProgram ADO.NET Consumer CICS Sender Program SQL Server 2008 TDS CICS IntersystemCommunications TI HIPListener Service TCP/IP CommunicationsServer for i5/OS SNA Services 3270 HPR/IP Windows Server 2008 Windows Server 2008 IBM z/OS

  16. Message Integration SharePointBusiness Connectivity Services WCF Service CICS Program(MQ Bridge) IMS Program(MQ Bridge) i5/OS Program SOAP MessageIntegrator WebSphere MQfor z/OS WebSphere MQfor i5/OS TCP/IP SNA Services Communications Server for z/OS and i5/OS HPR/IP Windows Server 2008 HubQueueManager Windows Server 2008 IBM z/OS and i5/OS

  17. Message Integration BizTalk Adapter or WCF Channel CICS Program(MQ Bridge) IMS Program(MQ Bridge) i5/OS Program WebSphere MQ Client for Windows WebSphere MQfor z/OS WebSphere MQfor i5/OS TCP/IP SNA Services Communications Server for z/OS and i5/OS Windows Server 2008 HPR/IP SpokeQueueManager HubQueueManager BizTalk Adapteror WCF Channel Channel WebSphere MQ Server for Windows SNA Services Windows Server 2008 IBM z/OS and i5/OS

  18. Messaging Integration • Windows Process Activation Service (WAS) using WCF Channel for MQ • Receive Context using WCF Channel for MQ • Multiple table update using BizTalk Adapter for DB2 • BizTalk Pipeline Component for host data conversion • New RE configuration for BizTalk Adapter for Host Applications

  19. Converting Host Data Structures • BizTalk Pipeline Component • Conversion of binary and XML messages • Nested and multi-record formats • VS Designer plug-in • Import COBOL and RPG to define metadata • Export XSD for BizTalk • Based on HIS technologies • Transaction Integrator Designer and Runtime • Provides solution for MQ, FTP, and others

  20. Connecting Servers, Devices and Clients BranchOffices IBM Data Center TCP/IP HPR/IP SNA Services SNA Services IBM System z TCP/IP WAN WAN Windows Server 2008 Windows Server 2008

  21. Connecting Servers, Devices and Clients • Network Integration (SNA Services) • Progressive Mode ARB for HPR/IP under Hyper-V • IPv6 networking for SNA clients and servers • Encryption using SSL and TLS for Session Integrator • Enterprise Single Sign-On (ESSO) • IPv6 networking • Advanced Encryption Standard (AES)

  22. IBM Host Systems

  23. Microsoft Host Integration Server 2010 • Platform compatibility • Microsoft product releases in 2010 • IBM z10 and POWER7 • Security • Secure Sockets Layer V3.0 • Transport Layer Security V1.0 • Advanced Encryption Standard • Efficiency • Developer using Visual Studio and HIS tools • IT Professionals using Office, SQL, HIS tools

  24. Summary • Deliver new applications faster • Utilize latest .NET Framework technologies • Improve developer productivity • Empower knowledge workers • Analyze vital information using Office apps • Change data capture using SQL Server tools • Securely connect systems more efficiently • Consolidate network infrastructure • Map identities to support federated IdM

  25. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related