cancel
Showing results for 
Search instead for 
Did you mean: 

Is there any process to Automate the data load from PSA to ODS?

Former Member
0 Kudos

Hello All,

In our scenario we need to load data from PSA to ODS and every day there are some changes in requests and need to again load complete data from PSA to ODS and there are a lot of records which take around 4 to 5 days to load full and we do it manually, selecting each request and loading it.My question is:

Is there any process to Automate the data load from PSA to ODS?

Regards,

Dolly

Accepted Solutions (0)

Answers (4)

Answers (4)

sven_mader2
Active Contributor
0 Kudos

Hi,

In 3.x there is only a manuel way.

You can't use a process chain. The process variants need the request id. There will be created with the infopackage. But in your process chain is no infopackage. You can't insert only the variant "read psa and update data target".

1. create a list of all loaded requests

2. delete the requests from infoprovider

3. go to the tab reconstruction

4. mark all requests from your list

5. click on the button "reconstruct/insert". When you have changed the transfer structure, you get a message box -> Ignore the changes.

Sven

Former Member
0 Kudos

Thank You all for the answers.

I am working on the solutions provided by you.

Regards,

Dolly

Former Member
0 Kudos

Hi frnd,

Actually the following option which am going to tell is only available in BW 3.5.

Goto your infopackage-> update tab -> there will 3 check boxes availabe-> you need to select PSA and target check box for automate the data load from PSA to ODS.

Please try the above path and let me know for futher queries.

Regards,

Uday.

Former Member
0 Kudos

HI Dolly ,

There would be an option"Read PSA and update data target" in rspc under the area "Load process and post processing".

This would update data from PSA to data target.

Regards

Venky

Former Member
0 Kudos

Hi All,

Thanks for the suggestions.

When I am creating process chain for loading.

1) I have created Start Variant

2) Have dragged and dropped Read PSA and Update data target Process type.

3) There I have given PSA table Name and Data Targe Name

but I am not able to insert object type here.

Please tell the steps after that to Load , if my requests are there in PSA and I just want to load it to ODS.

I would appreciate if you specify it step by step, since i am new to this.

Thanks & Best Regards,

Dolly

former_member186445
Active Contributor
0 Kudos

your version?

M.

Former Member
0 Kudos

I am using BW 3.5.