Skip to content

Oracle Information Integration, Migration, and Consolidation book review

I have recently received Oracle information integration,migration and consolidation book from packt pub for book review.

Such a interesting book for who has ready to migrate your data or integrate data to Other applications. this book helps and  give more tips for you how do you integrate your data or migrate data which utility do you want use and also how do you prepare your task with perfect plan. Here this book covers how do we use more tools for completing  such a big task.

The book covers data migration, data consolidation, and data integration, the three scenarios that are typically part of the information integration life cycle. Organizations typically find themselves migrating data to Oracle and either later, or at the same time, consolidating multiple database instances into a single global instance for a department, or even an entire company. The business savings and technical benefits of data consolidation cannot be overlooked, and this book will help you to use Oracle’s technology to achieve these goals.

This highly practical and business-applicable book will teach you to be successful with the latest Oracle data and application integration, migration, information life-cycle management, and consolidation products and technologies.

In this book, you will gain hands-on advice about data consolidation, integration, and migration using tools and best practices. Along the way you will leverage products like Oracle Data Integrator, Oracle GoldenGate, and SQL Developer, as well as Data Hubs and 11gR2 Database.

The book covers everything from the early background of information integration and the impact of SOA, to products like Oracle GoldenGate and Oracle Data Integrator. By the end you’ll have a clear idea of where information and application integration is headed and how to plan your own projects.

I mentioned this book “Oracle information integration,migration and consolidation” written by Jason Williamson with contributing authors Tom Laszewski and Prakash Nauduri.

What you will learn from this book :

  • Get to grips with all that Oracle has to offer for information integration, migration, consolidation, and information life cycle management
  • Gain insight into migration tools and practices that are not well documented or understood even by many Oracle architects
  • Take a deep dive into how information integration and data migration are achieved in a complete and robust Oracle environment
  • Evaluate which Oracle products to implement to meet your company’s unique technical requirements
  • Migrate data to Oracle in the most cost-effective, high performance and efficient manner
  • Learn from real-world case studies to help you define your own information and application integration solutions
  • Understand how Oracle’s latest combined hardware and software platforms can be used not only to consolidate data, but as an information service bus solution ‘in a box’
  • Tackle a myriad of tools like Oracle SOA Suite, Oracle Data Integrator, Oracle Golden Gate, and many more
  • Absorb the facts surrounding Oracle’s strategic offering, Application Integration Architecture (AIA)
  • Understand the past, present, and future of Oracle Application Integration
  • Utilize an Oracle and a partner’s product offerings to manage your large volumes of rarely accessed, but mission-critical information
  • Master an Oracle Commercial Off-The-Shelf (COTS) application.
This book has including contains 9 chapters,
Sample Chapter
Table of contents
  • Chapter 1, Getting Started With Information Integration, we present the overview of the information integration, data migration, and consolidation topic. You will learn the key concepts and build the foundations for the hands-on application of these concepts for your organization’s needs in the remainder of the book.
  • Chapter 2, Oracle Tools and Products, covers all the key Oracle products, tools, and technologies for you to consider when planning to implement integration, consolidation, and migration projects. The Oracle products, tools, and technologies are discussed separately and also compared and contrasted to provide you with the information needed to decide the product or products for your unique use cases.
  • Chapter 3, Application and Data Integration Case Study, provides the readers with the experience of a real world end-to-end application and process integration. In this chapter, we will look at the products and tools used, and even the work plan and design documents that were used. This is an excellent blueprint for your current or future projects.
  • Chapter 4, Oracle Database Migrations is a hands-on guide on how to migrate non-Oracle relational database sources to the Oracle Database. Oracle SQL Developer, a relational database modeling and migration tool, is covered in detail along with Oracle Data Integrator and GoldenGate.
  • Chapter 5, Database Migration Challenges and Solutions, covers database migration challenges and solutions. Schema and data migration are covered, along with specific issues like globalization. Some customer migration case studies are also covered.
  • Chapter 6, Data Consolidation and Management, investigates the key concepts and infrastructure needed for producing a consolidated view of data for the whole organization. We will look at Oracle Data Hub, Coherence, TimesTen products and Oracle Exadata, a database machine which is a consolidated software, hardware, and storage solution for your consolidation efforts.
  • Chapter 7, Database-centric Data Integration, focuses on the data-centric integration and data interchange between different databases either in near real-time, on-demand in the context of active transaction or bulk data merges between source and target databases. Oracle GoldenGate, Oracle Data Integrator, and Oracle Gateways are all covered in detail. We look at a case study for and their usage of Oracle Golden Gate and Oracle Data Integrator for highly available and integrated solutions.
  • Chapter 8, Application and Process Integration examines Oracle SOA Suite integration products like Oracle BPEL, Oracle Service Bus, Oracle SOA Adapters, and Oracle Application Integration Architecture. At the end of the chapter, you will have a clear understanding of what Oracle products to use for each specific application integration project you have.
  • Chapter 9, Information Lifecycle Management for Transactional Applications is the final installment of data integration. In this chapter we look at how to manage the entire lifecycle of data. We will look at Oracle ILM and how to manage and archive non-Oracle data sources.

Who this book for

If you are a DBA, application or data architect, or data integration specialist who is running an Oracle database or middleware and you want to learn about the latest on Oracle’s information integration platform, then this book is for you.

You can also benefit from this book if you are an application developer or technical and project lead with a focus on master data management, data warehousing, and data consolidation.

You should have working experience with Oracle Database, data integration, consolidation, and migration, as well as some familiarity with integration middleware products and information service buses.

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: