Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Managing an Oracle Systems Integration Project

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices



Key Features

* Define the needs and goals for the project.

* Plan for flexibility.

* Learn project tracking.

* Implement the integration project.

* Employ data integrity management.

* Use integrated software platforms.

* Integrate project issues and strategies.


Course Description

This two-day seminar is designed to give the student a firm conceptual understanding of how new technologies are integrated with existing legacy systems. The seminar explains the concepts and techniques in plain English and strips away all of the marketing hype to give the student a clear understanding of how to plan and manage a systems integration project. The seminar begins with a historical review of centralized and open systems and explains the basic integration approaches.

The student will leave this seminar with an in-depth understanding of the software engineering integration techniques and approaches including ODBC, system API’s, and gateway products. In addition, the student will learn about the business challenges involved in systems integration, including detailed costs/benefit analysis and dealing with other corporations. Lastly, the attendee will be exposed a integration planning life cycle where they will understand the process of planning, data extraction, bridge building and system cutover.

Book Required

  • N/A


This course is designed for the working Oracle professional and the amount of previous experience with Oracle is incidental.
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Burleson was chosen by Oracle Press to write the authorized edition of Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle new features training.

Managing a Systems Integration Project


© 2007-2016 by Donald K. Burleson

This course will be approximately 30% lecture and 70% open discussion. The focus will be on exploring issues that are germane to the new Medicare Computer System while concentrating on a conceptual overview of integration issues.

Day One: Morning
An overview of project management
- Highest level overview ("where do we begin?")
defining project management
defining the needs and goals for the project
defining the scope of the project
defining the project manager’s role
defining the functional managers role
defining the contractors role
characteristics of a successful integration project
- Project planning
- Project monitoring
- Managing changes in requirements
Planning for flexibility
Risk management
- Management of Project resources
Issues of size and scope
Establishing an integration strategy
Day One: Afternoon
A standard approach to integration project management
- An overview of systems theory
- modeling the project
- Planning for Problems
What can go wrong in a project
Quality metrics
Quality Measurement
- Providing management incentives
- Organizing the integration team - Infrastructure
traditional organization
line-staff positions
matrix organization
characteristics of a successful project manager
team building
The variables for success
Project tracking (measuring your progress and success)
- Modeling and simulation
network fundamentals
estimating activities and milestones
determining the critical path(s)
crashing a project
- Gantt charting
- Software project management tools
Performance measurement
Simulation and modeling
- Managing Risk


Day Two: Morning
Implementation of the integration project
- Architectural implementation and Infrastructure issues
- Migration Strategies
integration vs. replication
data conversion and cleansing
Planning for hardware, software, network and personnel
Measuring progress
Continuous processing during integration
A conceptual overview of systems integration
A historical perspective - organization and economic factors in system integration
The factors that create integrated architectures
Corporate acquisitions
New technologies
- Essentials of integrated systems
Data integrity management
Transparency features
Location transparency
Domains and location transparency
Performance and tuning methods
Interoperability features
- Types of integrated systems
Architectural distribution
Geographical distribution
System Integration Issues
- Database issues
Integrated database connectivity
Database API's
Programming for portability
Intersystem connectivity
Cross-database connectivity with IBM mainframes
Data communications and integrated databases
Integrated database access control
Integrated database concurrency management
The problem of cohesive updating
Alternative integrity mechanisms
Integrated database concurrency
- Operating System Software
Integration of mainframe with UNIX environments
Integrated software platforms
Monitoring multiple OS environments
- Hardware Issues
Insuring reliability - mirrored servers, RAID, load-sharing
Integrated system Security
Security for integrated databases
Problems with integrated database security
Benefits of integrated database security
Developing a integrated database security plan
Common problems with integrated security plans
How security is breached
Preventing security breaches
Integrated database backup and recovery
Programming for portability
Intersystem connectivity
Day Two: Afternoon
Afternoon session - Summary and open discussion of the integration project issues and strategies



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational