Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Do we need to give Username & Password in Bursting Query for ftp delivery Channel?
Summary
Do we need to give Username & Password in Bursting Query for ftp delivery Channel
Content
Hello Experts,
I have a requirement to deliver bursting file to ftp destination. According to Oracle we need to pass both username & password. I have a question is it possible to mask password in the bursting sql. Could you please verify & let me know if any changes needed.
| FTP and SFTP | PARAMETER1: Server name PARAMETER2: Username PARAMETER3: Password PARAMETER4: Remote Directory PARAMETER5: Remote File Name PARAMETER6: Secure (set this value to 'true' to enable Secure FTP) (PARAMETER 7-10 are not used) |
Thanks in Advance,
Anil P
Answers
-
Moved to correct forum.
0 -
Any help on this as the User ID and Password change from one POD to another . Whats the best practice to maintain it when the password changes ?
Thanks,
Soumya
0 -
Hi Anil,
Parameters 2 and 3 in FTP Bursting query are not mandatory.
You already have the credentials saved in the FTP connection, thus you just need to call the FTP connection in your bursting query, without filling in the credentials in the bursting query.
Kind regards,
Robert
0 -
Thanks Robert.
0
