Home » Developer & Programmer » Data Integration » How to Import Mainframe files in OWB (Oracle,10.2)
How to Import Mainframe files in OWB [message #390729] Mon, 09 March 2009 08:21 Go to next message
vengat06
Messages: 7
Registered: March 2009
Location: Chennai
Junior Member
Hi All,

I am Venkat. I am new to this Technology.
Could you please let me know the steps how to import mainframe files in Oracle warehouse builder.
Kindly reply.

Environment: Oracle 10.2

Thanks in Advance.

Venkat
Re: How to Import Mainframe files in OWB [message #391896 is a reply to message #390729] Sat, 14 March 2009 05:35 Go to previous messageGo to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Im not sure if its possible to create a direct link from owb to mainframe.

But we can do the following.

1) Find a way to convert the mainframe data files into fixed length file. Its possible using cobol or any mainframe language

2) Move the data file to your server where owb is installed in ascii format

3) Use these text files as source to owb.

Last time, we used a tool called infomover to accomplish step2

[Updated on: Sat, 14 March 2009 07:57]

Report message to a moderator

Re: How to Import Mainframe files in OWB [message #392038 is a reply to message #391896] Mon, 16 March 2009 02:37 Go to previous message
vengat06
Messages: 7
Registered: March 2009
Location: Chennai
Junior Member
Thanks for your information.

Venkat
Previous Topic: Table with deploy error
Next Topic: Audit Browser Date Problems
Goto Forum:
  


Current Time: Thu Mar 28 07:55:20 CDT 2024