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
- Title:
- 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)
- Main Title:
- Oracle Data Integrator 11g cookbook : over 60 field-tested recipes for successful data integration projects with Oracle Data Integrator
- 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 codeCover; 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. … (more)
- 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.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.91256
- Ingest File:
- 01_058.xml