LEADER 05104nam 2200649 a 450 001 9910790383003321 005 20200520144314.0 010 $a1-280-67665-5 010 $a9786613653581 010 $a1-84968-069-8 035 $a(CKB)2670000000204373 035 $a(EBL)948490 035 $a(OCoLC)797917389 035 $a(SSID)ssj0000677680 035 $a(PQKBManifestationID)12246852 035 $a(PQKBTitleCode)TC0000677680 035 $a(PQKBWorkID)10696386 035 $a(PQKB)10367147 035 $a(Au-PeEL)EBL948490 035 $a(CaPaEBR)ebr10567590 035 $a(CaONFJC)MIL365358 035 $a(CaSebORM)9781849680684 035 $a(MiAaPQ)EBC948490 035 $a(PPN)228018560 035 $a(EXLCZ)992670000000204373 100 $a20120612d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aGetting started with Oracle Data Integrator 11g$b[electronic resource] $ea hands-on tutorial : combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide /$fPeter C. Boyd-Bowman ... [et al.] ; [foreword by Alok Pareek] 205 $a1st edition 210 $aOlton, Birmingham [England] $cPackt Pub.$d2012 215 $a1 online resource (384 p.) 225 0 $aProfessional expertise distilled 300 $aIncludes index. 311 $a1-84968-068-X 327 $aCover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 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 327 $aChapter 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; Chapter 3: Using Variables; Defining variables; Variable location and scope; Variable definitions; Refreshing variables; Variable history; Using variables for dynamic information 327 $aAssigning 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; Chapter 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; Reverse-engineering metadata into ODI models 327 $aStandard reverse-engineeringCustom 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; Chapter 5: Working with Databases 327 $aSample scenario descriptionIntegration target; Integration source; Integration mappings; Data flow logistics; Exercise 1: Building the Load_Customer interface; Building the topology; Reverse-engineering the model metadata; Moving the data using an ODI interface; Checking the execution with the Operator Navigator; Summary; Chapter 6: Working with MySQL; What you can and can't do with MySQL; Working with MySQL; Obtaining and installing the software; Overview of the task; Integrating the product data; Product data target, sources, and mappings; Product interface flow logistics 327 $aIntegrating inventory data 330 $aCombine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide 606 $aData integration (Computer science)$vHandbooks, manuals, etc 615 0$aData integration (Computer science) 676 $a005.7 676 $a005.7575 700 $aBoyd-Bowman$b Peter C$01544139 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910790383003321 996 $aGetting started with Oracle Data Integrator 11g$93798091 997 $aUNINA