Retrieving SAP tables

Talend ESB Studio User Guide

EnrichVersion
6.5
EnrichProdName
Talend ESB
task
Design and Development
EnrichPlatform
Talend Studio

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 an SVN or 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.

  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.

  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.

    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.

    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.