This discussion is archived
7 Replies Latest reply: Aug 29, 2013 11:22 PM by 978889 RSS

Reverse engg data store using ODI SDK

ParthD Newbie
Currently Being Moderated

how to I reverse engineer a data store and not a model using ODI SDK

 

Is there any class for reverse engg? Or should I use KM's?

  • 1. Re: Reverse engg data store using ODI SDK
    DecaXD Pro
    Currently Being Moderated

    Hi,

     

    have you already read this?

     

    The specified item was not found.

     

    however i'm not able to find the javadoc of class..

  • 2. Re: Reverse engg data store using ODI SDK
    ParthD Newbie
    Currently Being Moderated

    Yes i have tried that...it doesnt reverse engineer the data store...instead it shows an error saying "SnpModel" does not exist...i have even commented on that post so that the OP can share the complete code

     

    Have you tried reverse engg a data store (and not model) using ODI SDK

  • 3. Re: Reverse engg data store using ODI SDK
    978889 Newbie
    Currently Being Moderated

    SnpModel does not exist error occurs when you provide wrong model id

    you will get model id by using below code

    odiModel.getModelId()

  • 4. Re: Reverse engg data store using ODI SDK
    ParthD Newbie
    Currently Being Moderated

    @978889: yes that's right..ur point was helpful but still my main task of reverse engg data store is not working!

  • 5. Re: Reverse engg data store using ODI SDK
    978889 Newbie
    Currently Being Moderated

    as you mention in thread The specified item was not found.

    you want reverse engineer data store for file technology and format is FIXED

     

    What reverse engineer do... it automatically creates column with data Type and length for u; same u can do by creating columns thru code;

    I did same, as I don't found API for reverse engg data store when file format is fixed

    my code snippet is

    OdiColumn odiColumn = new OdiColumn(DataStore, colName);

    odiColumn.setDataType(odiModel.getTechnology().getDataType("STRING"));

    odiColumn.setLength(length);

    odiColumn.setFileDescriptor(fileDescriptor);

    This code is working for me

     

    Deepali Patil

  • 6. Re: Reverse engg data store using ODI SDK
    ParthD Newbie
    Currently Being Moderated

    @Deepali : when u reverse engg ur delimited file, were you able to see the data ..for eg when u create interface or something.....setting all the parameters for reverse engg including column name, format etc is ok but you should mainly see the data when u use the datastore in an interface...

     

    so did u try that? did u use the data store  in the interface using studio?

     

    Thanks for your quick reply

     

    Also can u specify what does your filedescriptor contain?

     

    My text file is like this

     

    Id  Name

    1  abc

    2  def

     

    but on reverse engg i cant see any data in the data store

     

    Also, how to specify physical length and not logical length while reverse engg?

  • 7. Re: Reverse engg data store using ODI SDK
    978889 Newbie
    Currently Being Moderated

    When I reverse engg my delimited or fixed file, I am able to see the data of datastore; I used same datastore in interface

     

    Yes , I used the data store in interface using code(sdk)

     

    I am not doing anything manually in studio; everything is done through java code (using sdk)...but I have checked data of datastore by right clicking on it, its giving proper data

     

    filedescriptor contains start position and num of bytes

     

    your text file is looks like FIXED format,

    my Delimited format text file:

    empNo,empName

    1,Deepa

    2,Deepali

    3,Patil

    4,Deeps

     

    and FIXED format text file:

    10    Georges                                      Hamilton                                     15/01/2001 00:00:00
    11    Andrew                                       Andersen                                     22/02/1999 00:00:00
    12    John                                         Galagers                                     20/04/2000 00:00:00
    13    Jeffrey                                      Jeferson                                     10/06/1988 00:00:00
    20    Jennie                                       Daumesnil                                    28/02/1988 00:00:00
    21    Steve                                        Barrot                                       24/09/1992 00:00:00
    22    Mary                                         Carlin                                       14/03/1995 00:00:00
    30    Paul                                         Moore                                        11/03/1999 00:00:00
    31    Paul                                         Edwood                                       18/03/2003 00:00:00
    32    Megan                                        Keegan                                       29/05/2001 00:00:00
    40    Rodolph                                      Bauman                                       29/05/2000 00:00:00
    41    Stanley                                      Fischer                                      12/08/2001 00:00:00
    42    Brian                                        Schmidt                                      25/08/1992 00:00:00
    50    Anish                                        Ishimoto                                     30/01/1992 00:00:00
    51    Cynthia                                      Nagata                                       28/02/1994 00:00:00
    52    William                                      Kudo                                         28/03/1993 00:00:00

     

     

     

    if file format is Delimited we need not to worry about physical length or logical length, bcoz we are able to do reverse engg for that; which automatically set all fields

     

    odiColumn.setLength(length); method sets both physical and logical length

Legend

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