DARC Software

1
Creating a Consolidated Global Instance using
Isix -- Integration Software
DARC Software
2
Introductions

• Brian ConnollyExecutive Vice President, DARC
  CorporationExecutive in Charge of DARC
  Softwaremailtobconnoll_at_darc.com312.338.6205
• Don KidwellVice President, DARC
  Corporationmailtodkidwell_at_darc.com703.925.6602

3
Todays Agenda

• Database Consolidation - Operational
  Advantages - Strategic Advantages
• Challenges of EAI
• Overcoming the Challenges
• A Case Study
• What the Future Will Bring
• Questions

4
Before ConsolidationA Distributed Architecture

• INSERT GLOBAL SLIDE HERE

OA
5
After ConsolidatedA Single Global Instance
Architecture

• INSERT GLOBAL SLIDE HERE

6
Why is Consolidation an Operational Key?

• Tactical Speed
• Readily available data accelerates operational
  decisions (speed the close cycle)
• Streamlined Processes
• Operating efficiencies in information processing
  boosts productivity (allows more time for
  meaningful analysis)
• Substantial Cost Reductions
• Reduce cost of managing and maintaining systems
  infrastructure (HW, SW, NW and labor resources)

7
Why is Consolidationa Strategic Advantage?

• Strategic Insight
• Consolidated reporting allows for comprehensive
  analysis which strengthens competitive decisions
• Global View
• Data Analysis and Extraction much simpler
• ROI Escalation
• Substantial investments in Oracle Applications
  and enterprise technology rapidly recouped

8
Integration ChallengeOracle Applications
A closed system
MAINFRAME
Oracle Applications
Other ERP

• Multiple functional modules
• Complex, specialized code
• Time-intensive development
• Resource-expensive implementation

CRM
e-Gateways
9
Obstacles toGlobal Consolidation
Foundation forGlobal Consolidation
Oracle 8iParallel Server
Web-EnabledOracleApplicationsr11
LACK OFSCALABLESERVERS
TIMELYROI
LACK OFCAPABLE INTEGRATIONBROKERS
APPLICATIONSLOCALIZED
CONSOLIDATIONATCLOSE
LACK OFCAPABLESERVERS
CLIENT/SERVER ARCHITECTURE NOT CONDUCIVE
10
Why is ConsolidationPossible Now?

• Oracle 8is parallel server supports scalability
• Permits users and applications running anywhere
  on a network to access all rather than a portion
  of the data in the database(e.g., one server for
  query, one for transactions)
• Web-enabled Oracle Applications for r11
• Supports all localizations, currencies, languages
  and character sets in a single product

11
Traditional means of Consolidation

• Custom-coded interfaces
• resource constraints
• knowledge requirements formany disparate systems
• extensive development time
• complex, diverse code
• long-term maintenance of customizations
• no upgrades

• Manual data entry
• risk of Inaccuracy
• extensive data entry time
• large data entry cost
• limited data carryoverfrom legacy systems
• data entry projects formultiple instances

12
A New Solutionfor Consolidation
What is Isix?Isix is an integration software
package that alleviates the traditionally
time-intensive and resource-expensive custom
development process for interfaces between
disparate information systems and Oracle
Applications.
13
What does Isix Enable?

• Interfaces Conversions
• Instance Consolidation
• Mergers Acquisitions
• Shared Services
• e-Commerce

14
Why Isix?
15
Isix is the Key
Opens the door to any data source
MAINFRAME
Oracle Applications
Other ERP

• No custom code required
• Pre-built mappings, validations
• GUI uses Forms model
• Interface server executes translations

CRM
e-Gateways
16
How is Isix implemented?

• Component-based Architecture
• Interface Server
• Cartridges (adapters)
• Complete Data Mapping Worksheets
• Configure Interfacewith Wizard

• Execute Interface
• Train Users
• Test Interface
• Put into production

17
The Isix Architecture
18
How is Isix Supported?

• Post Implementation
• Software updates, releases, new software features
  and Software compatibility updates for the latest
  release of Oracle software
• Support hotline
• Priority call handling, problem escalation
• Concurrent support of two releases of the Software

19
Case StudyGlobal Telecommunications

• Provides telecom services to
• Multinational Companies
• Traditional Emerging Carriers
• Wholesalers
• ISPs
• Reaches 280 countries, 1000 cities

20
Challenges

• Disparate data sources
• Company formed by merging pieces of 3 existing
  companies
• Time
• Tight timeline for Oracle Applications
  configuration
• Even less time for integration / data conversion
• Fluid environment
• Target system (apps) changes daily!

21
Requirements

• SUPPORT TRANSACTION PROCESSING IN 7 WEEKS!
• Accuracy
• Support phased approach

22
Data Conversion Timeline
7-week span (including holidays)!
On site 11/15/99
Live! 1/4/00
Receipts
Bank Accounts
Mapping
Purchase Orders
GL Accounts
Vendors
Continuous Synchronization Timeline
PeopleSoft to Oracle Application Synchronization!
On site 11/15/99
Live! 1/10/00
Employees
PeopleSoft ready
23
Before/After

• What did it look like before Isix?
• Manual synchronization between PeopleSoft HR
  and Oracle
• Multiple Instances
• Redundant data input
• Manual reconciliations
• What will it look like after Isix?
• Automated synchronization
• Single point audit source
• Evolutionary changes NOT revolutionary changes

24
More to Come

• Conversions
• Fixed Assets sub-ledgers
• GL Balances
• Continuous Synchronization
• AR Invoices
• GL Journal Entries

25
Isix EvolutionWhats Coming...

• Isix 2.3 -- Isix for e-Business
• New reporting tools
• Data extraction capability
• XML enabled
• New Cartridges
• Incorporating JAVA

26
Questions?

• Q A Session
• External inquiries
• isixinfo_at_darc.com