XMDBTool Export Process

  1. Initially, the SFTP is set up. In this, all the sftp related parameters (the above mentioned six parameters) are read from the application parameters or the bkg parameters. If any of the parameters are specified in both, application parameters and bkg parameters, the bkg parameter overrides the application parameter.
  2. After the export process is complete, the system archives all the exported files existing in the <exportFileLocation>/<tenantID>/export/DownloadedData folder. These files are archived to an auto-created folder, archivedFiles that can be found in <exportFileLocation/<tenantID>/export/ folder. The number of days for which these files must be archived is specified by the application parameter, xmdbtool.backup .The system now attempts to connect to the SFTP server. If the sfptHost parameter is not specified, then the system is not connected to the SFTP server. If the SFTP parameter is specified, the system checks for the remaining important parameters and if all the parameters are set, then proceeds further and try to connect to the SFTP server.
  3. Once the connection is established, the system transfers all the exported files existing in the DownloadedData folder to the SFTP server. The location on the SFTP server, where the exported files are transferred, is specified in the sftpExport parameter. After each file is successfully transferred to the SFTP server, this is deleted from the DownloadedData folder in the Expense Management Application machine.
  4. After all the exported files are transferred, the log files are transferred to the folder on the SFTP server specified in the sftpHostLog parameter. If the sftpHostLog parameter is not specified, the logs are not sent to the SFTP server.
  5. Once the logs are sent successfully, the bkg process exits.