Oracle Data Integrator 12c Developer Jump Start Guide

The intention of this book is to provide a jumpstart for a developer to gain knowledge on how to do ELT using Oracle Data Integrator 12c. This book explains the most common business requirements using a simple source and target objects. This manuscript contains real time examples with step-by-step guidance and screenshots. All examples used are simple in nature. The idea is for the reader to gain confidence with using the Oracle Data Integrator. Examples are intended to be a good encouraging factor for developers to gain confidence. This book is designed to be a stepping-stone for the developer to venture into advance features of Oracle Data Integrator. After reading this book, developers are meant to gain a basic idea on how to use Oracle Data Integrator during their development cycle. Just by reading the ODI developer guide, a developer may not be able to perform mapping, however the step-by-step screen shots provided in this book will enable the developer to understand the tool better. There are other ways to perform the ELT other than the ones explained in this book. The intent of this guidebook is to show a sample method only. Developers can feel free to try their own methods to accomplish their results.

Below are examples that were used to explain the Oracle Data Integrator:

Source to Target – Append data

Source to Target - Incremental update

Using Join in Mapping

Using Lookups in Mapping

Using Union in Mapping

Using Reusable Mapping in Mapping (New 12c feature)

Using Split in Mapping (New 12c feature)

Using Markers in ODI Flat file to Table upload

ODI Packages

ODI Procedures

Load Planner