Oracle Data Integrator 11g Cookbook
Christophe Dupupet
Language: English
Pages: 352
ISBN: 1849681740
Format: PDF / Kindle (mobi) / ePub
This book is all you need to take your understanding of Oracle Data Integrator to the next level. From initial deployment right through to esoteric techniques, the task-based approach will enhance your expertise effortlessly.
Overview
- Clear, step-by-step recipes to walk you through some of the most advanced features of Oracle Data Integrator
- Covers everything from administration, to development, to deployment, including advanced coding techniques using the Oracle Data Integrator SDK
- Numerous code samples, screenshots, diagrams, and best practice recommendations
In Detail
Oracle Data Integrator (ODI) is Oracle's strategic data integration platform for high-speed data transformation and movement between different systems. From high-volume batches, to SOA-enabled data services, to trickle operations, ODI is a cutting-edge platform that offers heterogeneous connectivity, enterprise-level deployment, and strong administrative, diagnostic, and management capabilities.
"Oracle Data Integrator 11g Cookbook" will take you on a journey past your first steps with ODI to a new level of proficiency, lifting the cover on many of the internals of the product to help you better leverage the most advanced features.
The first part of this book will focus on the administrative tasks required for a successful deployment, moving on to showing you how to best leverage Knowledge Modules with explanations of their internals and focus on specific examples. Next we will look into some advanced coding techniques for interfaces, packages, models, and a focus on XML. Finally the book will lift the cover on web services as well as the ODI SDK, along with additional advanced techniques that may be unknown to many users.
Throughout "Oracle Data Integrator 11g Cookbook", the authors convey real-world advice and best practices learned from their extensive hands-on experience.
What you will learn from this book
- Understand how to install, secure, and deploy Oracle Data Integrator
- Explore the advanced features of ODI Topology, including creating new technologies and data types
- Learn many new ways to use variables in the product, including in Topology and Knowledge Modules
- Discover the inner workings of the code substitution in ODI to become more proficient with Knowledge Modules
- Get to grips with reusable coding best practices for interfaces and packagesFind out more more about using XML and web services in ODI
- Find out more more about using XML and web services in ODI
- Leverage the SDK to expand your solutions
- Review many of the key concepts and best practices of ODI
Approach
Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g.
Who this book is written for
This book is meant for people who already possess a basic understanding of Oracle Data Integrator and want to take it to the next level by learning how to better leverage advanced ODI features and functionality as they continue to develop and manage their data integration projects.
warehousing and business intelligence. Capitalizing on his extensive background in Oracle database technologies dating back to 1985, he has spent recent years specializing in data migration. After many successful project implementations using Oracle Warehouse Builder, and shortly after Oracle's acquisition of the Sunopsis Corporation, he switched his area of focus over to Oracle's flagship ETL product: Oracle Data Integrator. Peter holds a BS degree in Industrial Management and Computer Science
you have to specify the execution context; this is part of the execution parameters to start the scenario. The agent can now complete the code substitution and write the finalized code into the operator tables, where that code can then be used for execution. One last detail however are the substitutions encapsulated with <@=... @>. These elements will never be substituted when the code is written into the operator tables; they will only be substituted when the agent sends the code to the
FLOW_CONTROL option is set to True), a simple test in Java will guarantee that the proper table name is always used. If you look at the step Insert New Rows in the standard IKM SQL Control Append KM, you will see the following: <%if( odiRef.getUserExit("FLOW_CONTROL").equals("1") ){ %> Insert […] from<%=odiRef.getTable("L","INT_NAME","A")%> <% } else { %> Insert […] FROM …. <%}%> Note As you can see here, there is not even a Java variable in use; the If statement directly evaluates the
because executing an interface requires that it be first found and initialized. Add OdiScenarioGeneratorImpl and IOdiScenarioGenerator, which are used to generate a scenario out of various objects. Finally, we import RuntimeAgent and several classes related to sessions in order to invoke the scenario and monitor its related session. Add the following lines of code in your Groovy editor:import oracle.odi.runtime.agent.RuntimeAgent; import oracle.odi.domain.project.finder.IOdiInterfaceFinder;
Preface of this book. To follow the steps described here, do the following: If you have not done so earlier, create a model where you reverse engineer the SRC_EMP table from our source sample. If you have not done so earlier, create a model where you reverse engineer the TRG_EMP table from our target sample. Make sure that you have a project where the IKM SQL Control Append KM has been imported. If both source and target schemas are defined under the same data server in Topology, you will not