Enterprise Information Integration

1
Enterprise Information Integration
Query the Network
2
Agenda

• Introduction to EII
• Case Study
• How EII Strengthens a DW Strategy
• Data EII SOA (Service Oriented
  Architecture)

3
Description of EII

• EII enables Business Users to
• Query the Network

Delivering on-demand information from multiple
disparate sources using an Enterprise Information
Integration (EII) server
By creating Composite Views that combine, join
and view information without moving it, wherever
that information exists
4
Global Pharmaceutical Company SolutionA single,
consolidated view of District Managers world
Monitor Market Share by Rep and Territory
Manage Budget and Expenses
Manage Sales Rep Performance
Target Physicians
5
District Sales Manager SolutionQueries the
Network
Monitor Market Share by Rep and Territory
Manage Budget and Expenses
Manage Sales Rep Performance
Target Physicians
6
District Sales Manager Solution
Manage Budget and Expenses
Manage Sales Rep Performance
Monitor Market Share by Rep and Territory
Target Physicians
7
How Querying the Network Works
Client application displayed results to user
Request information
Business User
Results delivered to client application
Composite View is invoked and security enforced
INFORMATION SERVER
Composite Views join, transform, and aggregate
results
Composite View generates optimal query plan
Composite View queries multiple disparate sources
Results returned from data sources
Disparate data sources
8
Shape Differences
RDBMS
ASI / WSDL
JDBC / SQL
9
Semantic Differences
Customer Address
Customer Address
10
How Does EII Fit in with DW?

• Overall Objective Provide the most relevant
  information available to make effective business
  decisions.
• EII Complements DW
• Combine Real-time and Historical Data

11
How Does EII Fit in with DW?

• Combine Current and Historical Data
• Solve problems previously untried
• Richer info for better decision making

Data Warehouse
12
How Does EII Fit in with DW?

• Better Leverage from your DW
• Convert relational data to XML
• Serve a broader set of applications

XML
RDMS
RDMS
Data Warehouse
13
Service Oriented Architecture
New Cancel Change
New Change
Orders
Customer Details
Phone Fax E-mail Walk-in
Inventory Mgmt
Materials Procurement
Manufacturing
Customer Support
Order Management
Accounting
Shipping
Order
Check
In Stock (Ship Request)
In Stock
Ship Notice
Fulfillment Notice
Manufacture Request
Out of Stock
Order Materials
Update Inventory
14
How Does EII Fit in with DW?

• Move towards SOA
• Industry trend towards non-relational data shapes
• Load data into DW

SOAP
XML
WSDL
CSV
E/R
XML
RDMS
Web Services
15
The Future of EII
Single Customer View
Sales Dashboard
Financial Compliance
INDIVIDUAL PROJECTS
16
The Future The Data Services Grid
Customer, Products, Orders
Products
Orders
Customers
Data Warehouse