Book Image

Oracle Data Integrator 11g Cookbook

Book Image

Oracle Data Integrator 11g Cookbook

Overview of this book

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.
Table of Contents (19 chapters)
Oracle Data Integrator 11g Cookbook
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Creating users using generic profiles


Out of the box, ODI provides Profiles containing predefined security rules that can be used to easily grant privileges to new or existing users. We will be utilizing some of those Profiles to create a new user who will be developing ETL mappings.

Getting ready

In this recipe, we will reuse the repositories and objects created in the recipes of Chapter 10, Advanced Coding Techniques using the ODI SDK. Follow the instructions in those recipes to create them. You can also follow the instructions using your own repository. No other prerequisites are required.

How to do it...

  1. In ODI Studio, go to the ODI menu, then click on Connect and log into your repository using an ODI supervisor user.

  2. Open up Security navigator and expand both the Profiles and Users accordions. You should see a structure similar to the following screenshot:

  3. Click on the New User button in the Users accordion to open up the user creation wizard.

  4. Next, specify a name in the Name field; we use...