Question Re: Pull data without db connect or ud connect.. in Technology Q&A

Pull data without db connect or ud connect..

Former Member — Thu, 28 Sep 2006 20:08:11 GMT

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

Re: Pull data without db connect or ud connect..

Former Member — Thu, 28 Sep 2006 21:36:31 GMT

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"

Re: Pull data without db connect or ud connect..

Former Member — Fri, 29 Sep 2006 04:41:30 GMT

Michael,

The source system is Non-SAP .. doubt if you could use the function module...

Victoria..

Since it is an AS/400 did you try using middleware like MQ or the suite of products provided by IBM for data extraction using XML ?

You can use MQ to connect the DB to BW using XML data sources or use the message server ( I do not recllect the name clearly right now..) for the same.

You might have to run th MQ server on the AS/400 and that would require Java.. and am not sure if without Java if you can directly connect the systems.

Or you could dump the data into flat files and use the same

My 0.02

Arun

Re: Pull data without db connect or ud connect..

former_member225022 — Fri, 29 Sep 2006 22:18:27 GMT

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.