Oracle Data Integrator 11g cookbook : over 60 field-tested recipes for successful data integration projects with Oracle Data Integrator /: over 60 field-tested recipes for successful data integration projects with Oracle Data Integrator. (2013)

• Record Type: Book
• Further Information: Note: Christophe Dupupet [and others] ; [foreword by Brad Adelberg].
• Other Names: Dupupet, Christophe
• Contents: Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installation, Deployment, and Configuration; Introduction; Deploying and configuring a standalone agent manually; Deploying a JEE ODI Agent; Configuring a standalone agent with OPMN; Deploying JDBC drivers with a JEE ODI Agent; Chapter 2: Defining the Oracle Data Integrator Security; Introduction; Setting up LDAP security for Oracle Data Integrator; Setting external authentication with Oracle Data Integrator; Creating users using generic profiles. Creating users using non-generic profilesCreating new custom profiles in the Security navigator; Chapter 3: Advanced Topology; Introduction; Creating a new technology; Modifying actions to get more from your diagrams; Modifying and expanding datatypes; Changing the case sensitivity for code generation; Best practice -- using the Staging Area User to access your target schema; Chapter 4: Using Variables; Introduction; Passing start-up parameters to a scenario using variables; Using table names that run in all contexts using getObjectName; Using variables to filter data based on a timestamp. Using variables in KM options (and reusing the variables in an interface, package, and so on); Using variables in topology; Using variables to control loops inside packages; Chapter 5: Knowledge Module Internals; Introduction; Using the substitution passes; Using Java variables in KMs; Using Java for condition code generation; Invoking Java from the KMs; Using substitution methods in Java; Combining substitution methods in a KM; Chapter 6: Inside Knowledge Modules -- SCD and CDC; Introduction; Implementing Slowly Changing Dimensions (SCD) using ODI. Modifying a Slowly Changing Dimension KM to allow undefined behaviorsUsing Changed Data Capture (CDC) -- simple; Using Changed Data Capture (CDC) -- consistent set; Using one single interface to load changes that occur in any dimensions; Chapter 7: Advanced Coding Techniques; Introduction; Using diagrams to develop and maintain models; Generating DDL from data models; Generating interfaces from data models or diagrams; Creating a temporary interface (subquery); Loading data from an SQL query; Performing a pivot; Loading data using partition exchange; Chapter 8: Package Loops and File Processing. IntroductionDefining packages and loops for near real-time execution using a hybrid loop; Using a file from a parameter variable; Detecting files with a variable name; Processing all files in a directory; Processing a large number of files in parallel; Chapter 9: XML and Web Services; Introduction; Defining a connection to XML within ODI; Processing complex files with ODI; Processing XML data within an RDBMS not in memory; Invoking web services from ODI; Invoking asynchronous ODI web services with callbacks; Configuring container-based authentication with ODI web services.
• Publisher Details: Birmingham : Packt Pub
• Publication Date: 2013
• Extent: 1 online resource (iii, 330 pages :), illustrations (chiefly color)
• Subjects: 005.74; COMPUTERS -- Enterprise Applications -- Business Intelligence Tools; COMPUTERS / Databases / General; Data integration (Computer science); Data integration (Computer science); Computer science; Database management; Oracle; Data integration (Computer science); Data integration (Computer science); Electronic books
• Languages: English
• ISBNs: 9781849681759; 1849681759
• Related ISBNs: 9781849681742; 1849681740
• Notes: Note: Online resource; title from PDF title page (EBSCO, viewed July 7, 2017).
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.