At this moment I am investigating an interface between a Sales Force Automation system in Lotus Notes and a NON-SAP datawarehouse. This datawarehouse will be replaced by SAP-BW, so a new interface has to be created.
The functionality of the current interface is:
1. Lotus Notes creates a triggerfile of customernumbers who have to be visited the next day.
2. Based on this triggerfile a set of reports per customer is run in the datawarehouse in batch,
3. the results are put in XLS-files on a fileshare with a filename of customernumber_date_time.xls
4. These XLS-files are moved to Lotus Notes, and put by an Lotus Notes-agent into documents based on the naming of the XLS-file, so they can be read in a Lotus Notes view.
Items 2 and 3 have to be replaced with SAP-BW-functionality.
My question is:
Can broadcasting play a role in this? If yes, in which way? Or are there other BW possibilities?