cancel
Showing results for 
Search instead for 
Did you mean: 

Extracting data Using UD Connect

Former Member
0 Kudos

Dear Experts,

We are going to extract the data from Microsoft SQL Server using UD Connect.

As we know Delta is not possible with the same...is the only way we need to perform Full Update always to the BW System or there

any concept for getting only the chaged records like Delta.

Please provide any valid suggestions and documents if any.

Regards,

Sunil Kumar.B

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sunil,

Check the below doc which might help you on UD connect.

Load the data from Data Source to DSO, while loading data from DSO to Info Cube you can do delta using DTP.

Regards,

Venkatesh

Answers (4)

Answers (4)

Former Member
0 Kudos

Dear All,

The documents are very useful....will try to implement the same.

Regards,

Sunil Kumar.B

Former Member
0 Kudos

Hi Sunil,

As Tibollo said if you have date in your source table then you can write routine at Info Package level to load the delta records into BW system.

check out the below doc

Regards,

Venkatesh

Former Member
0 Kudos

Hi,

You can solve it only via an delta ods. load first into ods and from there make a delta load into your target infoprovider.

Check this link..

http://scn.sap.com/message/11033818

Regards,

Aravind.

former_member186445
Active Contributor
0 Kudos

you can use a routine in the infopackage selection criteria.

done that before and works as a charm.