Data Loading

[former_member378690]

Hi Experts,

I used BPC 10 NW version. I got two models and different server, should to have data communication. My understanding is we can't use script logic for this issue. Therefore, Could you please share with me about best way to data communication. So, one model can send data to another in different server.

Please your help guys.

Thanks

[former_member186338]

You can try to create badi - custom logic or retraction, in this badi you will read data to send in a table and then call remote function to import data on another server.

[lucas_costa3]

There is no way to do this by using sole BPC functions such as script logic.

If data is located in different servers you'd need to load the data from server 1 to sever 2 (by either using BW or flat file) and then load to the final BPC model.

[former_member378690]

Hi Lucas,

Thank you for your information. Could you please tell me more specific using BW tools ?

[lucas_costa3]

Hi Wang,

You'd need to perform basis setup such as connections and etc.

Then you'd need to create a data source in the source system, replicate in destination, create a staging BW object, transformation, loading process.

Only then you would work on BPC to create the Load process from BW Info Provider.

Cheers,

Lucas

[former_member186338]

Not a correct idea in general... It's a bad idea to use BPC model as a source for Load Infoprovider... Yellow requests!