1 Reply Latest reply on Mar 11, 2010 8:17 AM by 634081

    Load data into CDH via ODI


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

      Any info would be much appreciated.

        • 1. Re: Load data into CDH via ODI
          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.