14 Using the File Transfer Utility

The File Transfer Utility provides an alternate way of performing the following tasks: migrating artifacts, performing backup and restore, data load and data extract, uploading and downloading files.

For a list of commands you can use for the command driven File Transfer Utility, see Using the File Transfer Utility Commands and Parameters or enter eprcsctl in a command prompt window.

Note:

In Windows, the File Transfer Utility runs using Java and JRE is packaged along with the utility. In Linux and UNIX, set a JAVA_HOME environment to point to the latest 1.8 version of the JRE.

Note:

The File Transfer Utility does not work with corporate SSO (identity provider) credentials. Because users cannot sign in using corporate credentials, the user accounts for accessing the utility must be maintained in the service. If you configured your subscription for SSO, you must also enable users to sign-in with their identity domain credentials. See Enabling Sign In With Identity Domain Credentials in Administering Oracle Cloud Identity Management.

Installing the File Transfer Utility

To install the File Transfer Utility:

  1. Access Narrative Reporting.

  2. From the Home page, select Settings and Actions from the user menu, then Download the File Transfer Utility.

  3. Click Save File to save the eprcsctl.zip and then extract eprcsctl.zip locally.

Using XML Files

There are two ways of executing commands in the File Transfer Utility:

The editable XML files provided are the following:

  • data_extract_template

  • data_load_template

  • download_dbsnapshot_template

  • download_export_template

  • download_file_template

  • download_joboutput_template

  • export_template

  • get_detailed_stat_template

  • get_stat_template

  • import_template

  • import_library_template

  • upload_dbsnapshot_template

  • upload_file_template

  • burst

To use the File Transfer Utility with an XML file:

  1. First download the .XML file by entering this command: eprcsctl <XML_template_filename>=<path><filename>, where:

    Note:

    If you would just like to see the contents of a template file, you can enter eprcsctl <XML_template_filename>. If you would like to use the templates, Oracle recommends that you download them.

    • XML_template_filename = the name of the XML template for the command you want to execute

    • path = the location you want to save the file to

    • filename = the name of the local XML file

    For example, eprcsctl download_dbsnapshot_template=C:\download_snapshot_command_parameters.xml

  2. Edit the XML file to insert your specific parameter information. The template has instructions built in and shows you what to enter.

  3. Save the XML file.