Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
BI Publisher management of multiple simultaneous exports
I have to send several times a day about 50 exports at the same time. I have a question and a problem.
Is it possible to program schedules by script? It's hard to do them manually and especially the changes.
Each time, the 50 exports open and close an SFTP connection to send the report. Sometimes, a few exports get wrong because the connection closed because the SFTP server did not respond within 60 seconds.
Is it possible to increase the wait time by 60 seconds or is it possible to open only once the SFTP connection for all exports?
I have also tried exporting to a WebCenter Content, but how do I SFTP export all files? BI Publisher does not allow exporting from WebCenter Content.
Thank you for your help.
Marc
Answers
-
Hi @Marc Beaud
Can you share me your BIP product version details are you using onprem or cloud version?
Regards,
Arjun
0 -
Hi @Mallikarjuna Kuppauru-Oracle
I use the cloud version. I think OTBI is the same version that HCM : 24D.Thank you for your help.
Best regards
Marc
0 -
Hi Marc,
Just trying to understand your requirement a bit more in details. You have different reports or only a single report that sends data 50 times per day to a single SFTP? or is this not the case? can you please elaborate a bit more?
Thanks.
0 -
Hy Arjun,
I have 50 reports that are sent to a SFTP server at the same time. That makes 50 simultaneous connections.I would like to put all 50 reports into one folder and send them all at once via SFTP (only one connection).
I think the problem is that the SFTP server does not respond within 60 seconds, but I would like to bypass this problem by only creating one SFTP connection or by changing the timeout for establishing the connection.
Best regards
Marc
0
