Binary Files in OWB - Simple Example

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.

Comments:

Hello, I cannot find the viewlet (http://blogs.oracle.com/warehousebuilder/gems/binaryintoowbviewlet.html) linked to this page. Regards, Ahmed Esmat

Posted by Ahmed Esmat on September 11, 2010 at 08:58 PM PDT #

Hi Ahmed Can you find it now? I have just tried and its OK. Cheers David

Posted by David Allan on September 13, 2010 at 06:55 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today