| Description |
1 online resource (557 pages) |
| Contents |
Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial; Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; Oracle Data Integrator--background and history; Data integration usage scenarios; Data warehouses and BI; Service-oriented architecture (SOA); Applications; Master Data Management; Big Data; What this book covers. |
|
What you need for this bookWho this book is for; Who this book is not for; Conventions; Reader feedback; Customer support; Errata; Piracy; Questions; 1. Product Overview; ODI product architecture; ODI repository; Repository overview; Repository location; Master repository; Work repository; Execution repository; Lifecycle management and repositories; Studio; Agent; Console; Oracle Enterprise Manager; ODI key concepts; Execution Contexts; Knowledge Modules; Models; Interfaces; Interface descriptions; Interface mappings; Interface flow tab; Interface controls; Packages and Scenarios; Summary. |
|
2. Product InstallationPrerequisites; Prerequisites for the repository; Prerequisites for the Oracle Universal Installer; Prerequisites for the Studio; Prerequisites for the Standalone Agent; Installing ODI 11g; Two installation modes; Creating the repository with RCU; Installing the ODI Studio and the ODI Agent; Starting the ODI Studio for the first time; Post installation--parameter files review; Summary; 3. Using Variables; Defining variables; Variable location and scope; Variable definitions; Refreshing variables; Variable history; Using variables for dynamic information. |
|
Assigning a value to a variableSetting a hardcoded value; Refresh Variable; Passed as a parameter (Declare Variable); Referencing variables; Variables in interfaces; Variables in models; Variables in topology; Using variables to alter workflows; Packages; Load Plans; Summary; 4. ODI Sources, Targets, and Knowledge Modules; Defining Physical Schemas, Logical Schemas, and Contexts; Defining physical data servers; Defining Physical Schemas; Data schemas and work schemas; Defining Logical Schemas and Contexts; Non-database technologies; ; Flat Files; XML files. |
|
Reverse-engineering metadata into ODI modelsStandard reverse-engineering; Custom reverse-engineering; File reverse-engineering; XML reverse-engineering; Examining the anatomy of the interface flow; Example 1: Database and file to database; Example 2: File and database to second file; Example 3: File to Enterprise Application; Importing and choosing Knowledge Modules; Choosing Knowledge Modules; Importing a Knowledge Module; KMs--A quick look under the hood; Configuring behavior with KM options; Examining ODI Interfaces; Overview tab; Mapping tab; Flow tab; Quick-Edit tab; Summary. |
| Note |
5. Working with Databases. |
| Summary |
Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide. |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
Data integration (Computer science)
|
|
Intégration de données (Informatique) |
|
Data integration (Computer science) |
| Added Author |
Wheeler, Bernard.
|
|
Boyd-Bowman, Peter C.
|
| Other Form: |
Print version: Hecksel, David. Getting Started with Oracle Data Integrator 11g : A Hands-On Tutorial. Birmingham : Packt Publishing, ©2012 9781849680684 |
| ISBN |
9781849680691 |
|
1849680698 |
|
184968068X |
|
9781849680684 |
|
More Resources