1 / 73

Integration and Search

Integration and Search. Vincent Lam Product Marketing Manager June, 2008. More than 300 packaged adapters, providing connectivity to all enterprise information assets. The ability to integrate, transform and migrate those assets for all business requirements. Providing support for

fleta
Télécharger la présentation

Integration and Search

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. Integration and Search Vincent Lam Product Marketing Manager June, 2008

  2. More than 300 packaged adapters, providing connectivity to all enterprise information assets. The ability to integrate, transform and migrate those assets for all business requirements. Providing support for 7 styles of Data Integration Who is iWay Software? Adapters SOA Middleware Information Management Documents Transactions Services Messages Databases Applications

  3. Who is iWay Software? • Industry leading provider • All enterprise assets • 85 databases • 150 real-time sources • Applications • Messages • Transactions • Documents • Services • Replaces manual programming • Completely reusable Adapters SOA Middleware Information Management Documents Transactions Services Messages Databases Applications

  4. Who is iWay Software? • Streamlines business processes • Infrastructure augmentation • Infrastructure standardization • Multi-purpose integration • SOA, EAI, B2B, etc. • Specific industry solutions • Financial services, government, supply chain, healthcare, etc. • Minimizes technology shifts, new business initiatives and mergers • SOA Governance Adapters SOA Middleware Information Management Documents Transactions Services Messages Databases Applications

  5. Who is iWay Software? 7 Styles of Data Integration: 1. Data Warehouse 2. Real-time Data Warehouse 3. Operational Data Access 4. Federated Query / EII 5. Service Oriented Architecture 6. Process-Driven BI - Alerts - Business Activity Monitoring 7. Enterprise Search Adapters SOA Middleware Information Management Documents Transactions Services Messages Databases Applications

  6. Process Manager Trading Manager Enterprise Index Data Migrator 3rd Party Tools iWay iWay iWay iWay iWay iWay Integration Tools Explorer Transformer Designer Service Validation Suite Service Management Suite Service Manager Universal Adapter Suite Data Application Transaction Program Emulation eBusiness

  7. Why Search?

  8. The Case for Enterprise Search • Productivity: • Employee spend 1 to 3 hours per day searching for information* • BI for the Masses: • Current BI penetration 20% • The Google effect on BI • Information Access: Information doubles every two years • Most valuable data is structured in applications and data stores • Acceleration of ad hoc queries • Unified access to internal and external data Sources: Business Week; Accenture research on companies with annual revenue of more than $500 million; Forrester research

  9. Demo

  10. Information Access: Single Access Point To All Sources Anyone Single Point of Information Access Business Analysts Multiple Application Interfaces IT Mainframe Data Spare Spare Mainframe Mainframe Spare Data

  11. SAP customer search

  12. Searching SAP with iWay and Google Search Appliance

  13. In this example you’re searching for Doctors in Region 6 within SAP

  14. In this example you’re searching for Doctors in any region within SAP

  15. When you click on the Google search link of the document you would like to see, the results will be displayed in an HTML format which was rendered by the iWay adapter live from the SAP system.

  16. The Alternative?

  17. Logon to sap Select the proper system and enter the correct credentials

  18. SAP Main Menu Click on SAP Menu, if not present select menu option menu->SAP menu

  19. Sap standard menu appears Select Logistics

  20. Logistics menu Select Sales and Distribution->MasterData

  21. Master Data Menu Select Business Partner->Customer

  22. Customer menu Select Customer->Display->Complete

  23. Customer Display entry screen Click the box in a circle at the end of the customer field to open the search menu

  24. Customer search menu

  25. Customer Search Options Click the rightmost button at the end of the tabs to display all possible search options

  26. Search options Important to note that all the options except the first checked one, required the user to know something about the customer they are searching for. No title search is permitted, Such as “Dr.” or “Ms”, and it is only a “starts with” that doesn’t display all entries !

  27. Sample search “judy” is entered and the green check clicked

  28. Wrong result The term “judy” is auto converted by SAP to uppercase, and the wrong record returned

  29. Desired result

  30. How to find the correct record • If using standard SAP software, write an ABAP program!

  31. Create ABAP program

  32. Assign program to package

  33. Enter code and run Nothing is returned, so change query and run again!

  34. Run ABAP report Not using a WHERE clause, returns all customers, could be costly!

  35. Found correct record! Where program runs, the sap report view displays the results, select FIND from the Menu and enter search term.

  36. Reason why where clause failed Spelling was not correct (1) or field did not contain the correct data (2) to match the Where clause in the program.

  37. Return to Display Customer and enter customer number Enter the number found on the report to get the customer display screen

  38. Display Correct Customer

  39. Why Integration + Search?

  40. Scope: What can be indexed?

  41. Typical Enterprise Search Product Anyone Single Point of Information Access Business Analysts Multiple Application Interfaces IT Mainframe Data Spare Spare Mainframe Mainframe Spare Data

  42. Search Utilizing iWay Adapter Technology Anyone Single Point of Information Access Business Analysts Multiple Application Interfaces IT Mainframe Data Spare Spare Mainframe Mainframe Spare Data

  43. Data Adapters Application Adapters ShareBase SQL MP Nonstop SQL/DS SUPRA Sybase Sybase/IQ System 2000 Teradata Total TurboIMAGE UFAS Ultrix/SQL UNIFY UNISYS DMS Universe UX VSAM WIIS XML VSE Directory Adapters LDAP ADABASADABAS/C ALLBASE/SQLALL-IN-1Btreive C-ISAMD-ISAM CA-DatacomCA-IDMS CA-IDMS/R CA-Ingres CA-OpenIngres CoudscapeDB2 DB2/2 DB2/UDB DB2/400 DB2/6000DBMSDBASE Delimited Files ENSCRIBEEssbase Excel Flatfiles FOCUS Foxpro IDS-IIImage SQL IMS IMS/DB IMS/DC IMS/TM INFOAccess Infoman Informix ISAM KSAM Lotus Notes Model 204 MS Access MS SQL Server MS OLAP Services MUMPS NetISAM Nomad Nucleus Nonstop SQL NR Oracle OMNIDEX Open M/SQL Oracle 7 Oracle 8i Oracle 9i Pace Pick Systems Proprietary Files ProgressQSAM RDB Red BrickRMS Emulation IBM 3270 IBM 5250 Telnet VT100 VT200 Windows Applications Transaction Bull TDS CICS-TS CICS-Native Unisys ClearPath IBM OTMA IMS/DC IMS/TM Procedural Program CA ADS Online Cobol C C++ EJB Fortran Java Javabeans Oracle PL/SQL Pascal RPG SAG Natural

  44. Application System Adapters eBusiness Adapters ERP JDE JDE OneWorld Oracle Applications Peoplesoft7 Peoplesoft8 MySAP.COM SAP BW SAP Portals SAP R/2 SAP R//3 QAD EDI ANSI X12 (American) ANSI X12 (European) ACORD HIPAA All HIPAA Trans. HL7 FORMAT Pre-canned Templates XML BIZTALK WMQI/MQSI cXML XCML XBRK OAG BOD CsV/CDF (flat files) xCBL ebXML eCommerce Ariba Buyer Broadvision Commerce One Rosettanet Misc Millenium SCT Integral Systems Financial SWIFTML FIX/FIXML Web Services SOAP ebXML UDDI WSDL CRM Clarify Siebel Vantive/Peoplesoft 7 Vantive/Peoplesoft 8 System Adapters Supply Chain Management I2 Technologies Manugistics Security Adapters HTTPS S/MIME SSL MDN (Non-repudiation) Digital Certificates S/Key Key Encryption Messaging Message/Q Candle Roma IBM/MQSeries JMS Microsoft MSMQ Oracle AQ Sonic MQ TIBCO Rendezvous email MAPI cc:mail (VIM) Lotus Notes (VIM) SMTP/MIME POP Financial Packages Hogan Financials Logan Financials Oracle Financials Walker Interactive

  45. Technologies, Standards, and Environments Config. Tools Supported IBM Tivoli BMC Patrol Eclipse Dev. Tools Supported IBM Visual Age for Java WebGain Visual Café NeuVis Neurchitect Application Servers Supported IBM WebSphere Application Server BEA WebLogic Application Server iPlanet Application Server Any CGI compliant Web Server Any J2EE Compliant Web Server Connector Plug-ins for Application Servers IBM Websphere Application Server iPlanet Application Server BEA Weblogic Application Server Oracle9i Application Server Communications Adapters APPC DECNet FTP LU0 LU2(3270) LU 6.2 HTTP Named Pipes NetBIOS WAP XCF TCP/IP Connector Technologies ActiveX CORBA IWay JCA JDBC (V1 &V2) MQSeries Microsoft DTS ODBC OLE DB XML Connector Plug-Ins for Integration Broker(s) IBM Websphere MQ Integrator Microsoft Biztalk Server Foundation Technologies COM J2EE .NET RMI

  46. Operating Systems Supported AS/400 OS/400 BULL ESCALA BULL GCOS 7 BULL GCOS 8 CICS Data General HP MPE/XL HP UX ICL SX Series Linux Caldera Linux RedHat Mac OS MVS OS/390 NCR MP-RAS Open VMS VAX OS/2 EE OS/390 Open Edition Pyramid RS6000 AIX SCO UNIX Sequent Dynix Sequent Numa Siemans Sinix Siemans Reliant Sun Solaris Tandem NonStop Tru64 Unisys UNIXware VM ESA VSE ESA Windows 2000 Windows NT Alpha Windows NY Intel Windows XP

  47. iWay Adapter Framework for Search • WebFOCUS Magnify • Utilizes Lucene or Google Search Appliance engine • Supported out of the box • Google Search Appliance • Supported out of the box • Other Search Engines • Can be integrated with external calls in Service Manager • Not out of the box

  48. iWay Enterprise Index Object

  49. Flexibility: How adaptable is search?

  50. Typical Search Engine Data Store

More Related