on 05-19-2010 6:57 AM
Hello experts,
i have just created a data model and report from flat file(CSV) in BW 7.0.
I understand that if I want to include the extraction from the DataSource into the InfoPackage in the process chain, the CSV file needs to be on the Application Server.
The external database is being updated with new data daily. There is a URL - www.example.com/export.php - that when accessed, deliveres the updated flatfile from the database.
My question is: can i integrate this download in a process chain to be automatically triggered, so that every morning I have the updated data in the report?
Thanks.
Hi Andrei,
Am not sure how to execute the url using the process chain. But still we can check whether the file is available in the application server or not.
We have a process variant called OS Command, using this variant type we can check whether the file is available or not for some tim intervals. In case file is availabe then the next process will trigger else it will keep on searching for the file until it finds.
Regards
Chaithanya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found the solution
from the application server I am using the chron comand to schedule wget to download the file.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Utilize the OS command prompt for the same.
You can even try with ABAP coding.
thanks
Sri
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Please find my response to the below thread, see if this helps you.
-Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.