Pull data without db connect or ud connect..

[Former Member]

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 Member · Accepted solution]

Hi, create a generic extractor (generic DataSource) based on a Function Module. n the function module you can select the data. This generic extractor (DataSource) can be a souerce for a ODS or InfoCube.

Best,

Michael

ps. Transaction RSO2

a Example for a easy FM is "RSAX_BIW_GET_DATA_SIMPLE"