Integrate

Create and Transfer XML Files

Review the steps to create and transfer XML files.

During the file creation process, Integrate generates an XML file in the correct format using the data as configured by the Auto Generated Database Objects feature and the data entered for the views in SQL.

NOTE: A process must be active to create files.

To create files and transfer them to the data source (a remote FTP server):

  1. Click Postings for the process.

  2. Click Edit; Vertical View displays.

    View the field descriptions for the Process Post page’s Vertical View.

  3. Click Advanced tab.
  4. Select StandardSAPPosting from BDC Post Method list box.

  5. Click the Transfer Files to Data Source check box to enable it if it is not enabled.

    NOTE: If this check box is enabled, Integrate creates the XML file and transfers the file to the data source set on the Vertical View of the Template Process page in the Data Source ID list box. If the check box is disabled, Integrate creates the file but leaves it on the application server.  Using this method, the user can download the file from the application server and check it before transferring it to the SAP server.

  6. Click Post on the Page toolbar, or close Vertical View and click Post for the process post on the Horizontal View.

    NOTE: Integrate displays a detailed message about the post status, including how many files were successfully created and transferred and how many records failed to be created or transferred.

  7. Click View Messages for the process post.

    NOTE: The Messages page displays one record for each file that Integrate created, and one record for each file that Integrate transferred.

  8. Click File for a record for a created file.

    NOTE: The Message File page displays the path and file name of the file created on the application server. Integrate stores the file in the default folder configured in the Posting Default Folder field in Common > Configuration > Modules > Integrate > Parameters – Integrate.

  9. Click Download to view the file Integrate created.

    NOTE: The downloaded file displays in the correct XML format and with the data as entered in the SQL tables. 

    NOTE: If the Transfer Files to Data Source check box was enabled for the process post, Integrate also attempted to transfer the file to the data source as configured on the Vertical View of the Process Templates page. Integrate created a folder on this server with the process name.

  10. Navigate to the Post Monitor page.

    NOTE: Either select Post Monitor from the Navigation pane, or click Monitor for the process post on the Process Post Horizontal View.

  11. Click Vertical View for the process post.

    NOTE: The Template Status displays the status of the creation and transfer of the file to the remote server.

  12. Click the hyperlink to access a page to download the file that was transferred to the FTP data source and that has been created on the remote server.
  13. Click the download icon to download the XML file.