copyFromSFTP
Copies a file directly from an SFTP server to an OCI (Gen 2) environment. This command is useful to copy a data file directly from a secure SFTP server to an Oracle Enterprise Performance Management Cloud environment. Using this command, you can copy a file directly from an SFTP server without first downloading it to another server using an SFTP client and then using EPM Automate or the REST API to upload it to EPM Cloud.
Applies to
Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Account Reconciliation, Profitability and Cost Management, Enterprise Profitability and Cost Management, Oracle Enterprise Data Management Cloud, Narrative Reporting, Strategic Workforce Planning, and Sales Planning.
Required Roles
Service AdministratorUsage
epmautomate copyFromSftp SFTP_SERVER_URL FILE_NAME
username=USERNAME password=PASSWORD
where:
SFTP_SERVER_URL
is the URL of the SFTP server including the location and name of the file you want to copy from the server.FILE_NAME
is the file name for the file in the EPM Cloud environment. Specify the path, for example, if you are not copying to the default upload location.USERNAME
is the ID of a user who has the required access rights on SFTP server.PASSWORD
is the SFTP user password.
Example
epmautomate copyFromSftp
sftp://mySFTP_Server/someDirectory/someFile.csv myFile.csv username=jdoe
password=Sftpwelcome