Getting Started With Oracle Data Integrator 11g

Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide.

Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide Discover the comprehensive and sophisticated orchestration of data integration tasks made possible with ODI, including monitoring and error-management Get to grips with the product architecture and building data integration processes with technologies including Oracle, Microsoft SQL Server and XML files A comprehensive tutorial packed with tips, images and best practices 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, 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. "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" provides you with everything you to get up and running with Oracle Data Integrator, and more! Following an example scenario, the book covers essential information about the ODI architecture and using ODI across different databases (Oracle, Microsoft SQL Server and MySQL), and file types such as XML, before covering Orchestrating Data Integration Workflows, Error Management, Operational Management and Monitoring, and beyond. "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" begins by describing the Oracle Data Integrator architecture and teaching you to install the product following best practices. You'll then be introduced to some of the key concepts of ODI such as the Knowledge Modules. Later topics include moving and transforming data from sources to targets including the Oracle Database, Microsoft SQL Server, MySQL, Flat files, and XML files, each with illustrated hands-on examples for the different technologies. Your learning experience will be made all the more rich with chapters introducing, explaining and leveraging additional ODI functionality such as variables, reusable procedures, temporary indexes and more. Finally ODI's workflow and task orchestration capabilities are explained before introducing you to Error Management with ODI's built-in 'error hospital' and 'error recycling' capabilities for non-compliant data, not to mention tackling ODI Studio, ODI Console and Enterprise Manager Fusion Middleware Control. What you will learn from this book Get to grips with the various components of the Oracle Data Integrator architecture Learn how to install ODI quickly and effectively using recommended best practices Orchestrate your data integration processing by designing ODI packages and scenarios Discover how to develop ODI interfaces in order to effortlessly move data between servers and files Get the full lowdown on both Error Processing and Management and Monitoring Give your knowledge a boost with in-depth coverage of various data sources and targets including Oracle, Microsoft SQL Server and XML files Master key ODI concepts like Physical and Logical Architectures or the Knowledge Modules Take advantage of expert advice from the authors' combined 15 years of ODI experience Approach "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. Who this book is for If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then "Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial" is for you. You should have some experience with databases, SQL and ETL technologies.

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is a practical tutorial bursting with tips, illustrations and real-world best practices to get you on your way with ODI. If you are a software/ETL developer or database administrator who is new to Oracle Data Integrator but want to get hands-on with the product quickly, then Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial is for you. You should have some experience with databases, SQL and ETL technologies.

Written as a practical Cookbook, the recipes in this essential guide will help you make the most out of Oracle Data Integrator 11g.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.

This book is a practical guide with examples and clear steps to explain terrain modeling with Grome. If you're a developer or artist looking for a guide to walk you through GROME 3.1, then this book is for you. This book will help you from the first step to exporting a terrain as a workable art asset in a game engine.

With this textbook, Vaisman and Zimányi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most basic principles to recent findings and applications. To this end, their work is structured into three parts. Part I describes “Fundamental Concepts” including multi-dimensional models; conceptual and logical data warehouse design and MDX and SQL/OLAP. Subsequently, Part II details “Implementation and Deployment,” which includes physical data warehouse design; data extraction, transformation, and loading (ETL) and data analytics. Lastly, Part III covers “Advanced Topics” such as spatial data warehouses; trajectory data warehouses; semantic technologies in data warehouses and novel technologies like Map Reduce, column-store databases and in-memory databases. As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Pentaho Business Analytics. All chapters are summarized using review questions and exercises to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available at http://cs.ulb.ac.be/DWSDIbook/, including electronic versions of the figures, solutions to all exercises, and a set of slides accompanying each chapter. Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style.

Extract, Transform, and Load data to build a dynamic, operational data warehouse with Oracle Warehouse Builder 11g R2 with this book and eBook.

Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.