7 Replies Latest reply on Aug 30, 2013 6:22 AM by 978889

    Reverse engg data store using ODI SDK


      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



          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

            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

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

              you will get model id by using below code


              1 person found this helpful
              • 4. Re: Reverse engg data store using ODI SDK

                @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

                  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);




                  This code is working for me


                  Deepali Patil

                  • 6. Re: Reverse engg data store using ODI SDK

                    @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

                      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:







                      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