Transcript Integration and Search

Integration and Search
Vincent Lam
Product Marketing Manager
June, 2008
Copyright 2007, Information Builders. Slide 1
Who is iWay Software?
More than 300 packaged adapters,
providing connectivity to all
enterprise information assets.
Adapters
SOA Middleware
The ability to integrate, transform
and migrate those assets
for all business requirements.
Information Management
Providing support for
7 styles of Data Integration
Documents
Transactions
Services
Messages
Databases
Applications
Who is iWay Software?
Adapters
SOA Middleware
Information Management
Documents
Transactions
Services
Messages
Databases
Applications
 Industry leading provider
 All enterprise assets
 85 databases
 150 real-time sources
 Applications
 Messages
 Transactions
 Documents
 Services
 Replaces manual programming
 Completely reusable
Who is iWay Software?
Adapters
SOA Middleware
Information Management

Documents
Transactions
Services
Messages
Databases
Applications
 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
Who is iWay Software?
7 Styles of Data Integration:
Adapters
SOA Middleware
Information Management
Documents
Transactions
Services
Messages
Databases
Applications
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
Process
Manager
Trading
Manager
Enterprise
Index
Data
Migrator
3rd Party
Tools
Integration Tools
Explorer
Service
Management
Suite
Transformer
Designer
Service Manager
Service
Validation
Suite
Universal Adapter Suite
iWay
iWay
iWay
iWay
Data
Application
Transaction
Program
iWay
Emulation
iWay
eBusiness
Why Search?
Copyright 2007, Information Builders. Slide 7
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
Copyright 2007, Information Builders. Slide 8
Demo
Copyright 2007, Information Builders. Slide 9
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
Copyright 2007, Information Builders. Slide 10
SAP customer search
Searching SAP with iWay and
Google Search Appliance
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.
The Alternative?
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 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
Desired result
How to find the correct record
 If using standard SAP software, write an ABAP program!
Create ABAP program
Assign program to package
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
Display Correct Customer
Why Integration + Search?
Copyright 2007, Information Builders. Slide 39
Scope: What can be indexed?
Copyright 2007, Information Builders. Slide 40
Typical Enterprise Search Product
Anyone
Single Point of Information Access
Business
Analysts
Multiple Application Interfaces
IT
Mainframe
Data
Spare
Spare
Mainframe
Mainframe
Spare
Data
Copyright 2007, Information Builders. Slide 41
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
Copyright 2007, Information Builders. Slide 42
Data Adapters
ADABAS
ADABAS/C
ALLBASE/SQL
ALL-IN-1
Btreive
C-ISAM
D-ISAM
CA-Datacom
CA-IDMS
CA-IDMS/R
CA-Ingres
CA-OpenIngres
Coudscape
DB2
DB2/2
DB2/UDB
DB2/400
DB2/6000
DBMS
DBASE
Delimited Files
ENSCRIBE
Essbase
Excel
Flatfiles
FOCUS
Foxpro
IDS-II
Image SQL
IMS
IMS/DB
Application Adapters
ShareBase
IMS/DC
SQL MP Nonstop
IMS/TM
SQL/DS
INFOAccess
SUPRA
Infoman
Sybase
Informix
Sybase/IQ
ISAM
KSAM
System 2000
Lotus Notes
Teradata
Model 204
Total
MS Access
TurboIMAGE
MS SQL Server
UFAS
MS OLAP Services Ultrix/SQL
MUMPS
UNIFY
NetISAM
UNISYS DMS
Nomad
Universe
Nucleus
UX
Nonstop SQL
VSAM
NR Oracle
WIIS
OMNIDEX
XML
Open M/SQL
VSE
Oracle 7
Oracle 8i
Directory Adapters
Oracle 9i
LDAP
Pace
Pick Systems
Proprietary Files
Progress
QSAM
RDB
Red Brick
RMS
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
XML
eCommerce
Ariba Buyer
Broadvision
Commerce One
Rosettanet
Misc
Millenium
SCT
Integral Systems
CRM
Clarify
Siebel
Vantive/Peoplesoft 7
Vantive/Peoplesoft 8
Supply Chain Management
I2 Technologies
Manugistics
Financial Packages
Hogan Financials
Logan Financials
Oracle Financials
Walker Interactive
EDI
BIZTALK
WMQI/MQSI
cXML
XCML
XBRK
OAG BOD
CsV/CDF (flat files)
xCBL
ebXML
Financial
ANSI X12 (American)
ANSI X12 (European)
ACORD
HIPAA
All HIPAA Trans.
HL7 FORMAT
Pre-canned Templates
Web Services
SWIFTML
FIX/FIXML
SOAP
ebXML
UDDI
WSDL
System Adapters
email
MAPI
cc:mail (VIM)
Lotus Notes (VIM)
SMTP/MIME
POP
Messaging
Message/Q
Candle Roma
IBM/MQSeries
JMS
Microsoft MSMQ
Oracle AQ
Sonic MQ
TIBCO Rendezvous
Security Adapters
HTTPS
S/MIME
SSL
MDN (Non-repudiation)
Digital Certificates
S/Key
Key Encryption
Technologies, Standards, and Environments
Config. Tools Supported
IBM Tivoli
BMC Patrol
Eclipse
Connector
Technologies
ActiveX
CORBA
IWay
JCA
JDBC (V1 &V2)
MQSeries
Microsoft DTS
ODBC
OLE DB
XML
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
Connector Plug-Ins for Integration Broker(s)
IBM Websphere MQ Integrator
Microsoft Biztalk Server
Foundation Technologies
COM
J2EE
.NET
RMI
Communications
Adapters
APPC
DECNet
FTP
LU0
LU2(3270)
LU 6.2
HTTP
Named Pipes
NetBIOS
WAP
XCF
TCP/IP
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
Copyright 2007, Information Builders. Slide 47
iWay Enterprise Index Object
Copyright 2007, Information Builders. Slide 48
Flexibility: How adaptable is search?
Copyright 2007, Information Builders. Slide 49
Typical Search Engine
Data Store
Copyright 2007, Information Builders. Slide 50
Typical Search Engine
 “Snapshot” Indexing
 Information is crawled
 1 to 1 mapping of data to search results
 Great for machines, bad for people
 Limited Joins on Data for Views
 Database Driven
 No ability to integrate logic
 All or nothing approach
 Can’t customize much per source
Copyright 2007, Information Builders. Slide 51
Magnify: Transactional Indexing Overview
i-Way Service Manager
Capture incoming
transactions
Enrich transaction with
meta data
Transform and feed
records into Google
Process Search
Search Request
Magnify Results
Report Request
WF Report
• Dynamic Categorization
allows uses to narrow down
thousands of search results to
what they need in a guided
manner
• Dynamic Tabular View allows
users to sort, chart, pivot, etc.
the search results
• Run directly from the search
Hits standard, parametrized,
ad hoc and other reports
Copyright 2007, Information Builders. Slide 52
Utilizing Service Manager with Search
 Real-time Transactional Indexing
 Information is pushed
 Custom mapping of data to search results
 Great for machines, even better for people
 Custom Joins Against Any Source
 Database + ERP + CRM + 3270 + CICS… comprehensive
view of data
 Customizable Security
Copyright 2007, Information Builders. Slide 53
Utilizing Service Manager with Search
 Full SOA Stack
 Conditional Logic
 Call applications based on data
 Reformat, modify data as needed before indexing
 GUI Driven
 Customization
 Customize as much as desired per source
 Or.. Use a simple reusable flow if no customization is
necessary
Copyright 2007, Information Builders. Slide 54
Relevancy Enhancements: Dynamic Categorization
Copyright 2007, Information Builders. Slide 55
Reusability: How long does it take to
implement?
Copyright 2007, Information Builders. Slide 56
SAP
Mainframe
Siebel
DB2
Service
Enablement
Adapters
SAP
Mainframe
Siebel
DB2
BPM
SOAP
Service
Enablement
Adapters
SAP
Mainframe
Siebel
DB2
BPM
Portal
B2B
EAI Tools
SOAP
Plug-in
XML/AS2
Flat/MQ
Service
Enablement
Adapters
SAP
Mainframe
Siebel
Service
Consumption
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
Service
Enablement
Adapters
SAP
Mainframe
Siebel
Service
Consumption
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
Service
Consumption
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
Service
Consumption
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
Service
Consumption
In Out
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Step 2:
Enrich
Step 3:
Update
Flat/MQ
Service
Consumption
In Out
Step 1:
Validate
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
DB2
BPM
Portal
B2B
EAI Tools
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
In Out
In Out
In Out
In Out
Service
Consumption
Service
Composition
Step 1:
Validate
Step 2:
Enrich
Step 3:
Update
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
DB2
BPM
Portal
B2B
EAI Tools
Service Governance
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
In Out
In Out
In Out
In Out
Service
Consumption
Service
Composition
Step 1:
Validate
Step 2:
Enrich
Step 3:
Update
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
DB2
BPM
Portal
B2B
EAI Tools
Service Governance
Business Level
SOAP
Plug-in
XML/AS2
Flat/MQ
In Out
In Out
In Out
In Out
Step 1:
Validate
Step 2:
Enrich
Step 3:
Update
Step 4:
Index
Service
Enablement
Application Level
Adapters
SAP
Mainframe
Siebel
Service
Consumption
DB2
Integration with Search
 Leverages existing infrastructure
 Maintain just one copy of business logic
 Same tools – no need to learn another toolset
 Adaptable
Copyright 2007, Information Builders. Slide 69
Summary
Copyright 2007, Information Builders. Slide 70
Integration and Search
 Enterprise Search
 Real world benefits
 Search and Integration are closely related
 Similar issues
 Issues Search Engines and Integration Share
 Scope
 Flexibility
 Reusability
Copyright 2007, Information Builders. Slide 71
Integration and Search
 Solutions Integration and Search Share to Address These
Issues
 Universal Adapter Framework
 iWay Service Manager SOA Suite
 iWay Enterprise Index
 WebFOCUS Magnify
 The Future…
 Expect to see more coupling between Integration and
Search!
Copyright 2007, Information Builders. Slide 72
Thank You
Copyright 2007, Information Builders. Slide 73