X

Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Using ODI Exchange to Share ODI Objects

In the previous blog post in this series we had a look at
the new ODI Exchange functionality available in ODI 12.2.1 and how to use it.
In this blog post we will be focusing on how to share your global ODI objects
with the rest of the ODI community.

Step 1: Prepare Global ODI Objects

  1. Connect to the ODI Repository containing the
    desired Global Knowledge Modules or User Functions (Note: Only Global objects
    are supported)
  2. In the Designer Navigator expand the Global Objects accordion to select the desired object

  3. Export the Global KM or User Function via Context Menu “Export…”

  4. Specify the Export directory and Export name (Note: Export key is NOT supported)

  5. Press OK (and answer Yes to Export Key warning if shown)
  6. Press OK on Export finished dialog
  7. Obtain the GlobalId by examining the export file content.  The first <Object> should contain the exported object definition (class=”com.sunopsis.dwg.dbobj.SnpUfunc” or class=” com.sunopsis.dwg.dbobj.SnpTrt”).  A few more lines down should be one called <Field name=”GlobalId”…>…[CDATA[##-##-##-##]…  Make note of the value of the GlobalId you will need it again!  (Hint: you should probably copy it to the clipboard) 

    Here is an example:
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <SunopsisExport>
    <Admin …
    <Encryption …
    <Object class="com.sunopsis.dwg.dbobj.SnpUfunc">
      <Field name="ExtVersion" …
      <Field name="FirstDate" …
      <Field name="FirstUser" …
      <Field name="GlobalId" … [CDATA[99f49a0e-096d-407f-b423-a7f0fbb258da]]>
      <Field name="GroupName" …
      <Field name="IndChange" …

Step 2: Prepare Update Bundle

  1. Place the exported Global ODI Objects into an empty directory
  2. Create under that directory a “META-INF” sub-directory

  3. Create a file called “bundle.xml” in the “META-INF” directory as follows:
    <update-bundle
              version="1.0"
              xmlns="http://xmlns.oracle.com/jdeveloper/updatebundle">
      <update
              id="{globalId}"
              xmlns="http://xmlns.oracle.com/jdeveloper/update">
        <name>{name}</name>
        <version>{version}</version>
        <author>{author}</author>
        <author-url>{authorUrl}</author-url>
        <description>{description}</description>
      </update>
    </update-bundle>
    • [mandatory] globalId: MUST exactly match the one in the export xml
    • [mandatory] name: the ‘name’ of the object which will be displayed by Check For Updates
    • [mandatory] version: the version number (in the form #.#[.#.#])
    • author: the value to show as “Author”, this information will appear within ODI Studio so make sure to fill it in!
    • authorUrl: the value to show as the “Author Url” (http://... ) , this information will appear within ODI Studio so make sure to fill it in!
    • description: the description to show in the description field, this information will appear within ODI Studio so make sure to fill it in!
    You can also
    download a sample bundle.xml file from here: link

  4. Utilize a ‘zip’ tool (zip, winzip, 7zip, etc…) to create a single .zip file containing the update contents in the ‘root’ directory and META-INF/bundle.xml
    Ex: in Linux:    zip -9 –r {bundleZipFile}.zip *

Step 3: Upload the bundle zip file to the Oracle Data
Integration project on Java.net

  1. Go to https://home.java.net/ and create an account if you don't have one yet

  2. Click on Join This Project
  3. Click on Downloads in the Project Features menu on the left hand-side

  4. Click
    on ODI

  5. Click
    on Knowledge Modules

  6. Click
    on 12c

  7. Finally
    click on Add File / Link for Download,
    specify the file to upload and put a title/description. If you don’t see 'Add File
    / Link for Download' you need to log into Java.net.

  8. Click
    on Upload to complete the upload of
    the object on Java.net. When you’re done click on Done.

When a new object is added to Java.net we will be
automatically notified and will add it to the ODI Exchange. Thanks for
contributing!!

If you want to know more about all the new features included
in Oracle Data Integrator 12.2.1 have a look at the New
Features document on OTN.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.