On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,585 Users
  • 2,269,760 Discussions


Import / create Integration knowledge modules

et4891 Member Posts: 17 Green Ribbon
edited May 28, 2021 5:16AM in Data Integrator

I am new to ODI and was going to catch some exceptions such as making sure what is passed is a number instead of varchar, or validate the length then record these exceptions into a different table.

Came to tutorials and notes that it seems like I should be using Check Knowledge Module which seems to be linked with Integration Knowledge Module being used while mapping. From what I read this will catch exceptions and put them inside an E$_table, so I want to try it out.

I was using VM ODI downloaded from https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html

It includes an append Integration Knowledge module, then I started using the big data lite VM from https://www.oracle.com/database/technologies/bigdatalite-v411.html which is more updated version of ODI and the Oracle Database too.

But in the big data lite ODI, I do not see the append option in Integration Knowledge module, I wonder if there's a way I can either export from the previous VM then import into the new VM. I was checking googling but most of them were talking about exporting / importing environment, repositories and so on.

Can someone shade me some light on how to progress?

Thanks in advance for any suggestions and advices.

P.S. If I am actually on the wrong road of wanting to catch exceptions to another table such as if `TO_NUMBER(value)` gives an exception error or if even possible `LENGTH(value) != 5` something like these. Please let me know and if can lead me to where I can find tutorials with images, I really appreciate the help.

Thanks a lot

Best Answer

  • Marco Fris
    Marco Fris Member Posts: 152 Bronze Badge
    Answer ✓

    You are on the right track: CKM is the way to go.

    You will need to import the CKMs you need into your project. Right click on Knowledge Modules, choose 'Import Knowledge Modules', navigate to <Oracle_Home>\odi\sdk\xml-reference and click OK.

    This will give you the list of all standard Kms.

    Have fun, Marco