My Oracle Support Banner

How To Update an Existing XML File With The ODI 11g XML Driver (Doc ID 1567552.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

How can an existing XML file be updated using the Oracle Data Integrator (ODI) 11g XML Driver?

For example, you wish to update the email addresses of user1 and user2 to new values which are contained in a database table or flat file:

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

<?xml version="1.0" encoding="UTF-8"?>
<catalog>

            <username id="user1">
                      <datecreated>25/06/2013</datecreated>
                      <description>ODI User</description>
                      <emailid>user1@example.com</emailid>
                      <firstname>FirstOne</firstname>
                      <lastname>LastOne</lastname>
            </username>
            <username id="user2">
                       <datecreated>25/06/2013</datecreated>
                       <description>ODI User</description>
                       <emailid>user2@example.com</emailid>
                       <firstname>FirstTwo</firstname>
                       <lastname>LastTwo</lastname>
              </username>
              <username id="A001">
                       <firstname>AdditionalOne</firstname>
                       <lastname>LastAdditional</lastname>
                                   .....
              </username>
              <username id="B001">
                       .....
              </username>
</catalog>

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.