Data extraction from Oracle database

Hello all,

I have to extract data from legacy database tables. I need to apply a lot of conditions on data extraction using SQL statements for getting only valid master data, transaction data, SAP date format etc. Unfortunately I don;t have a luxary of accessing legacy system data base table to create table views and applying select statements.

Is there anyother way round by which I can filter data on source system side w/o getting into legacy system. I mean being in BW data source side.

I am suppose to use both UD connect and DB connect to test which will workout better way of data extraction. But my question above should be same in either interface.

This is very urgent as we are in design phase.

Points will be rewarded immediately.

Thanks

Message was edited by:

Shail

Message was edited by:

Shail