Welcome to All Things Warehouse Builder

  • ETL
    January 25, 2008

Binary Files in OWB - Simple Example

David Allan

So how do you load binary data into Oracle? Using a variety of ways, thats the good news, this is a little like teaching new dogs old tricks. OWB's file support is rich enough to fulfill the vast majority of cases. I guess it is not 100% obvious though how it is done, especially from the queries on mailing lists and forums. Once you see the pattern then it becomes apparent what the tasks at hand are. I created a viewlet (see here) which uses a nice small example to illustrate how it all hangs together; what you can do with files and external tables. In 2007, a white paper was published that illustrated how to load COBOL

EBCDIC files using OWB's file support, check it out also (here). It illustrates how more complex data structures are represented and how to use OWB to complete the job. Must post the actual MDLs and data files for these too, its always useful to get your hands on something real.

Join the discussion

Comments ( 2 )
  • Ahmed Esmat Sunday, September 12, 2010
    I cannot find the viewlet (http://blogs.oracle.com/warehousebuilder/gems/binaryintoowbviewlet.html) linked to this page.
    Ahmed Esmat
  • David Allan Monday, September 13, 2010
    Hi Ahmed
    Can you find it now? I have just tried and its OK.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.