Information integration and migration in most organizations is a critical function and takes place every day. This is usually accomplished through home-grown extraction transformation and load (ETL) processes, File Transfer Protocol (FTP), and bulk file loads. This is even the case in Oracle shops. What has been created in the industry is an inefficient, cumbersome process that is not rationalized, full of errors, and is costly to maintain. To further complicate matters, this has to be accomplished with disported data sources and platforms.
Today, Oracle information integration still takes place this way, even though Oracle offers an extensive and rich set of information integration products and technologies. Oracle Information Integration architectures contain solutions and tools that leverage things like PL/SQL stored procedures, SQL Perl scripts, SQL Loader Korn Shells, and custom C and Java code. This book will allow you to drive more business value from IT by enabling more efficient solutions at a lower cost and with fewer errors. This will increase transparency for the business, improve data quality, and provide accurate market intelligence for executives. We will help you by showing you when, where, and how to use Oracle GoldenGate, Oracle Data Integrator, Oracle Stand-by Database, Oracle SOA Suite, Oracle Data Hub, Oracle Application Integration Architecture, Oracle SQL Developer, and more.
This book will provide you with valuable information and hands-on resources to be successful with information integration and migration with Oracle. If you are already an Oracle shop and want to learn the latest on Oracle's information integration platform, or you are migrating or consolidating to an Oracle Database platform, this book is for you.
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, Database Migration to Oracle 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 Overstock.com 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.
The Appendix explores emerging cloud trends such as integration in the cloud, and data application and process integration convergence. It also contains the merits and drawbacks to some of these emerging trends and technologies, such as web services for all integration. By the end of the appendix, you will have an understanding on whether web services for all your integration needs is the best approach for your company.
If you are a DBA, architect or data integration specialist who is running an Oracle Database and want to learn the latest on Oracle's information integration platform, then this book is for you. Middleware application integration specialists, architects or even developers that are dealing with application integration systems can find this book useful. It will also be incredibly beneficial for anyone who is migrating or consolidating to an Oracle Database platform.
Having a working knowledge of Oracle Database, data integration, consolidation and migration, as well as some familiarity with integration middleware products and information service buses will be helpful in understanding the concepts in this book
In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.
New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this:
"JDBC Drivers can also be added in the Migration Wizard during the migration process, which is discussed later in this chapter, by clicking on the Add Platform link on the Source Database selection window, as shown in the following screenshot:"
Feedback from our readers is always welcome. Let us know what you think about this book — what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.
To send us general feedback, simply send an e-mail to <[email protected]>, and mention the book title via the subject of your message.
If there is a book that you need and would like to see us publish, please send us a note in the SUGGEST A TITLE form on www.packtpub.com or e-mail <[email protected]>.
If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.
Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.
Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books — maybe a mistake in the text or the code — we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/support, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.
Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.
Please contact us at <[email protected]> with a link to the suspected pirated material.
We appreciate your help in protecting our authors, and our ability to bring you valuable content.
You can contact us at <[email protected]> if you are having a problem with any aspect of the book, and we will do our best to address it.