730 likes | 940 Views
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
E N D
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 7 styles of Data Integration Who is iWay Software? Adapters SOA Middleware Information Management Documents Transactions Services Messages Databases Applications
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
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
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
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
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
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
In this example you’re searching for Doctors in Region 6 within SAP
In this example you’re searching for Doctors in any region within SAP
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.
Logon to sap Select the proper system and enter the correct credentials
SAP Main Menu Click on SAP Menu, if not present select menu option menu->SAP menu
Sap standard menu appears Select Logistics
Logistics menu Select Sales and Distribution->MasterData
Master Data Menu Select Business Partner->Customer
Customer menu Select Customer->Display->Complete
Customer Display entry screen Click the box in a circle at the end of the customer field to open the search menu
Customer Search Options Click the rightmost button at the end of the tabs to display all possible search options
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 !
Sample search “judy” is entered and the green check clicked
Wrong result The term “judy” is auto converted by SAP to uppercase, and the wrong record returned
How to find the correct record • If using standard SAP software, write an ABAP program!
Enter code and run Nothing is returned, so change query and run again!
Run ABAP report Not using a WHERE clause, returns all customers, could be costly!
Found correct record! Where program runs, the sap report view displays the results, select FIND from the Menu and enter search term.
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.
Return to Display Customer and enter customer number Enter the number found on the report to get the customer display screen
Typical Enterprise Search Product Anyone Single Point of Information Access Business Analysts Multiple Application Interfaces IT Mainframe Data Spare Spare Mainframe Mainframe Spare Data
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
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
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
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
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
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
Typical Search Engine Data Store