1 Reply Latest reply on Apr 18, 2006 2:01 PM by 159563

    Application view to common view transformation

    491728
      Hi,

      I am new to the development in the OIC environment.
      I have been held up in developing one of my requirement. It would be more helpful for me if any one in this group can give me a solution.

      My Requirement is:

      My source application gives its output in the following format. (The application view ). It creates the XML file and puts the same in some FTP folder.

      File format
      field_01
      field_02
      field_03
      field_04
      field_05

      I already have a pre-defined common format in the OIC environment. The format of this common view is given below.

      Common view format
      field_name
      value

      Now I need to do a mapping (or transformation) in such a way that each field in the application view should comes in as the record to the common view structure.
      The output of the common view should be something like the one shown below:

      Field name value
      field_01 <value of field_01>
      field_02 <value of field_02>
      field_03 <value of field_03>
      .....
      ....

      Thanks for your help and time.
      Suresh T
        • 1. Re: Application view to common view transformation
          159563
          The only correct way to do this is to use Workflow or BPEL as intermediate application (publish to WF or BPEL (IC 10.1.2.0.2 can) and then subscribe recipient to answer from them).

          In WF or BPEL you can use XSLT transformation (in Workflow we write our own one in PL/SQL, based on standard XSLTRANSFORM DB function) to transform one multy record XML document to many XML documents.
          And publish results (many XML documents) in cycle.

          Also you can try write your own custom transformation (in java) - we try this way too, but this is much more harder and there are some limitations.