ODI RepositoriesUsing the graphical interfaces, you create and manage ODI repositories, which store configuration information about theIT infrastructure, the metadata for all applications, projects, models and other ODI... Läs mer

Learn To:Use Oracle Data Integrator to perform transformation of data among various platforms.Design ODI Mappings, Procedures, and Packages to perform ELT data transformations.Administer ODI resources and set up security with ODI.Perform data integration and transformation among various platforms.Use the ODI graphical interface to define procedures, packages, and ELT jobs.Set up and maintain a secure, multi-user ODI environment.Implement Changed Data Capture with ODI.Use ODI Web services and perform integration of ODI with SOA.

Benefits to YouImprove performance and reduce integration costs across your organization's heterogeneous systems. Centralize dataacross databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security.Implement High-Performance Movement and TransformationThis offering details on how to use Oracle Data Integrator (ODI) 12c to implement high-performance movement andtransformation of data among various platforms.

ODI RepositoriesUsing the graphical interfaces, you create and manage ODI repositories, which store configuration information about theIT infrastructure, the metadata for all applications, projects, models and other ODI artifacts.

ODI Topology, Models, Mappings, and otherYou also learn how to create the ODI Topology, organize ODI models and design ODI Mappings, procedures, packagesand other objects.This course is based on Oracle Data Integrator 12c

Setting Up a New ODI ProjectOverview of ODI ProjectsCreating a New ProjectCreating and Maintaining FoldersOrganizing Projects and FoldersUnderstanding Knowledge ModulesExchanging ODI Objects and Sharing Global ObjectsExporting and Importing ObjectsCreating and Labeling with Markers

ODI Mapping ConceptsWhat is a Mapping?Business Rules for MappingWhat is a Mapping, a Filter, a Join?Overview of Integration ProcessWhat is a Staging Area?Execution LocationMapping with Knowledge Modules (KM)Creating an Intermediate Mapping

Mapping: Monitoring and DebuggingMonitoring MappingsCreating Objects with OperatorViewing Sessions and TasksHow to Monitor Execution of a MappingHow to Troubleshoot a SessionKeys to Reviewing the Generated CodeWorking with ErrorsTips for Preventing Errors

Administering ODI Resources: Advanced TopicsUsing Open ToolsInstalling Open ToolsUsing Open Tools in a PackageUsing Open Tools in a Procedure or in a KMDeveloping Your Own Open ToolsSetting Up ODI SecurityDefining Security PoliciesDefining Password Policies