Forum Stats

  • 3,874,594 Users
  • 2,266,750 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

It includes an append Integration Knowledge module, then I started using the big data lite VM from 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