Configuring your FTP server and other SAP-related tasks - 7.1

ELT SAP

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > ELT components > ELT SAP components
Data Quality and Preparation > Third-party systems > ELT components > ELT SAP components
Design and Development > Third-party systems > ELT components > ELT SAP components
EnrichPlatform
Talend Studio
SAP System Administrators can configure their File Transfer Protocol (FTP) server in two locations.

Before you begin

  • Ensure that you have set up custom ABAP function modules installed in the SAP system. The archive with transport files feature is available in the installation folder of Talend Studio.
  • Ensure that you have an SAP Non-Dialog User with proper authorizations to execute the ABAP function modules and to read from the required application tables that you are using.
  • Ensure that you have installed the current version of the SAPJco library. You can download the package through the SAP marketplace.
  • Set your firewalls accordingly:
    • Open the Port for the RFC communication. Example: 33xx, xx-SAP Instance Number[00..99])
    • Open the Port for the FTP communication

Procedure

  1. Option 1: Create your FTP server on the same server as the SAP system
    1. Create a folder where you can store batch files temporarily created during the table extraction process.

      The SAP system must have full access to this newly created folder. Ensure that you have the <sid>adm user on Linux or SAPService<sid> user on Windows to have access to all SAP-related local resources.

    2. Install the FTP service.
    3. Create a user account that you can use with the FTP client. You need this account to connect to the Talend Studio component.
    4. Define proper authorizations for the FTP user. Ensure that this user only has access to the newly created folder used for the batch file transfer with execute, read, and delete* operations.
  2. Option 2: Create your FTP server on a separate server
    1. Create a folder where you can store batch files temporarily created during the table extraction process.

      The SAP system must have full access to this newly created folder. Ensure that you have the <sid>adm user on Linux or SAPService<sid> user on Windows to have access to all SAP-related local resources.

    2. Install a Network File Service (NFS) on the SAP server.
      The folder you have previously created in step 2.a is released through the NFS for the FTP server.
    3. Install the FTP service on a separate server.
    4. Install a Network File Service (NFS) client on the FTP server. The folder you have previously created in step 2.a is mounted and accessible through FTP.
    5. Create a user account that you can use with the FTP client. You need this account to connect to the Talend Studio component.
    6. Define proper authorizations for the FTP user. Ensure that this user only has access to the newly created folder used for the batch file transfer with execute, read, and delete* operations.
    Remember: * All batch files are deleted after a successful transfer to Talend Studio.