Pull data without db connect or ud connect..

[#1]

hi,

We are trying to establish a connection with a legacy (AS/400 IBM platform with DB2 400 (DB4) and OS400 like operating system) and BW (operating system AIX and DB2 UD6 - Sap Netweaver 2004) by DB Connect .

The extraction till now has not been possible.

With ud connect is not possible either because our Application server does not have J2ee Server.

Then, I need to know if someone has other option.

The extraction can be with abap code and excec sql. But We would have to create tables (Duplicate), and then generate data sources in BW to pull ODS, InfoObject, infocube, etc in bw. :S

Is possible to pull the infoobect or ODS directly, and with the abap code make the routines for mapping?

Or put the data into the PSA, and then with the process chain pull the ods and infoobject?

Some other idea????

Thanks

Victoria

[former_member225022]

Victoria,

You have two other option for extracting the Data.

1. Write a code in Mainframe to extract the data from Mainframe and ftp it to your SAP box as a flat file. Then use BW's file extractors , to load data to your BW Objects.

2. You can use a tool like Informatica. Informtica can hook up to your Mainframe DB2 tables, extract the data, and load to BW Objects.

Option 2 is costly, as you have to buy Informatica. But the development time will minimise.

Hope this helps.