Do we need to give Username & Password in Bursting Query for ftp delivery Channel?

Question

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 SFTPPARAMETER1: 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

Anil Pillaresetty · Answer

Thanks Robert.

Robert Fighiroae-Oracle · Answer

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

Soumya Prakash Parhi · Answer

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