Retrieving SAP tables - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
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
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29

About this task

This section shows you how to retrieve SAP tables and table schemas of interest, and preview data in tables from the connected SAP system using the SAP metadata wizard.

Warning: If you are working on a Git managed project while the Manual lock option is selected in Talend Administration Center, be sure to lock manually your connection in the Repository tree view before retrieving or updating table schemas for it. Otherwise the connection is read-only and the Finish button of the wizard is not operable. For more information about locking and unlocking a project item and on different lock types, see Working collaboratively on project items.

Procedure

  1. In the Repository tree view, right-click the newly created SAP connection and select Retrieve SAP Table from the contextual menu. The SAP Table wizard dialog box opens up.
    Add new table in connection "SAP" dialog box.
  2. In the Name and Description fields, enter the filter condition for the table name or table description if needed. Then click Search and all the SAP tables that meet the filter condition will be listed in the table.
  3. Select one or more tables of interest by selecting the corresponding check boxes in the Name column. The tables selected will finally be saved in the Repository and the tables unselected will be removed from the Repository if they already exist in the Repository.
  4. Click Next to proceed to the next step.
    Add new table in connection "SAP" dialog box.
    All selected tables are listed in the Table Name area. You can remove the table(s) you have already selected by clicking Remove Table.
    Click Refresh Table and the latest table schema will be displayed in the Current Table area.
    Click Refresh Preview to preview data in the selected table. If an Error Message dialog box pops up, and when you click Details, it displays DATA_BUFFER_EXCEEDED error information, you need to edit the SAP connection to add a property api.use_z_talend_read_table and set its value to true. For more information, see Setting up an SAP connection.
    Error Message window.
    Modify the schema of the selected table in the Current Table area if needed. The Ref Table column value will be lost if you modify the Technical Name or Talend Name column value.
  5. Click Finish. The tables and their schema of interest will be saved in the SAP Tables folder under the SAP connection node in the Repository tree view. You can now drag and drop any table node onto your Job design workspace as a tELTSAPInput component or a tSAPTableInput component, with all metadata information automatically filled.
    If you need to further edit a table, right-click the table and select Edit Table from the contextual menu to open this wizard again and make your modifications.