This discussion is archived
1 Reply Latest reply: Mar 11, 2010 12:17 AM by 634081 RSS

Load data into CDH via ODI

Sun-E Newbie
Currently Being Moderated
Hi,

How can you load data into the TCA - CDH - HZ_ table via Oracle Data Integrator?

Any info would be much appreciated.

Regards
  • 1. Re: Load data into CDH via ODI
    634081 Newbie
    Currently Being Moderated
    I'm sure you could either do it by exposing the API's to create and then update fields, or import in the HZ_IMP_* tables and then kicking off a concurrent request to bring the data into CDH.

    Another option but perhaps not very efficient is to export the data into a standard format text file and run the batch import function when logged in as Data Librarian and import the files via batch. However, it's a bit limited with regards to the fields that can be imported via batch and is only suitable if you want to import just the basic client information. Using the API's is your best bet.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points