How to get delta using DataSourse with extraction from view?

[Former Member]

Hi!

Dataflow:

SAP ERP -> DataSource with extraction from view -> DS -> BW

What kind of Transforms I need to use to get the Delta load?

Thanks.

[Former Member]

Hi Andrey,

Are you going to use 'Extractors' or going to extract data from SAP tables by importing them?

If you are gion to use Extractors, you have 'delta' loading capability available. Check the below link:

http://wiki.sdn.sap.com/wiki/display/EIM/Using+Extractors+as+Source+%28Data+Services+4.0%29

If you are goin to import tables and extract data, you need have a filter clause added in the query transform to extract delta data (say a filter on some key value or may be date).

Hope this helps.

Thanks, Arun J.

[Former Member]

Hi, Anur!

When i imported DataSource with extraction from view in DS, I can see it in my "Datastore" in tab "Extractors".

I have read the information on this ulr...

On ERP side, in the table ROOSOURCE, extractor delta type is AIE.
 
Hence it ulr follows:
http://wiki.sdn.sap.com/wiki/display/EIM/Extractor+RecordMode
Recodrmode is " ", therefore it is necessary to use comparison table?
http://wiki.sdn.sap.com/wiki/display/EIM/Dataflow+for+Extractor+Delta+Process+Type+AIE
 
Now i don't understand how to use delta with comparison table transform.

Maybe I should use another transform?

So I ask: How to get delta using DataSourse with extraction from view?

May be someone has an example dataflow with "extraction from view on erp side" -> DS -> BW?

[Former Member]

Hi Andrey,

I understand that you are trying to extract data from ERP through Extractors. I'll try to get back to you on delta extraction in some time.

I think you have also asked how to load data to BW. Below link would help you on that.

http://wiki.sdn.sap.com/wiki/display/EIM/Loading+BW

Quick bit:

You need to establish a RFC connectivity between DS box and BW box.

1. In BW, you need to create a 'External Source System' with a 'program ID'.

2. In DS box, create a SAP Connectionin DS Management console (DS 3.2 onwards) by providing BW server credentials along with the 'Program ID' (it's case sensitive - so exact name).

3. Once the connection is established, you will be able to load BW.

Let the forum know if you need more information.

Thanks, Arun J.

Thanks, Arun J.

[Former Member]

Arun,

RFC connection I configured and delivered the data in the BW. I do not understand, how it works Delta.

I thought that the DS can work with Delta, which is determined on the side of the ERP.

On ERP side i have myself datasouerce with extraction on a view. Table PRPS.

I have chosen several fields from PRPS, click "delta generic" -> delta-specific field -> calend.day -> AEDAT. So, on ERP side AEDAT - timestamp.

But on DS side, when i imported extractor, i can see all fields and don't understand how DS use timestamps AEDAT...

But now, it seems, I understand that the DS can work with extractors as with tables and only. Right?

[Former Member]

Hi Andrey,

Basically you will need to create a 'global variable' which will take in 'delta' or 'initial' as parameter value. Based on this value, you need to set the filter condition on the key field that will pull only necessary records.

Thanks, Arun J.

[Former Member]

It means that the DS can't use delta-specific field, which was determined on the side of ERP?

[Former Member]

Hi Andrey,

When you import the extractor in DS or in the properties of already imported extractor if u choose "Change Data Capture" as the extraction mode , you can specify a filter below for AEDAT in the field name. By using this you can specify from Which AEDAT value to Which AEDAT value you want to capture the delta records for.

Hope this helps.

Thanks

Ganesh