This discussion is archived
2 Replies Latest reply: Mar 4, 2013 11:55 AM by 922130 RSS

Importing few tables in ODI Source

RR Newbie
Currently Being Moderated
Hi all,

I am new to odi. I am trying to use EBS as my source and local database as my target.

I have created new source model for this EBS instance.

My requirement is how to import particular tables from EBS in odi.

When I am clicking Reverse Engineering in source model it takes more time and application were stopped.

Pls help me regarding this.

Thanks in advance.
  • 1. Re: Importing few tables in ODI Source
    A. Drieux Pro
    Currently Being Moderated
    you can do a selective reverse engineering by applying a MASK on the name of the resource you want to retrieve.

    Try to begin with a little lot of tables.
  • 2. Re: Importing few tables in ODI Source
    922130 Newbie
    Currently Being Moderated
    If you need get consistent business model from EBS, you can purchase ODI adapter for EBS...(not expensive), and you have loaded data very simple and fast.
    EBS has complicated data model, some columns has variable significance. If you need GL, there are about 12 tables.
    In EBS adapter for ODI you get model with business description (not perfect, but you get some important information).

    Have a nice day


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