Retrieving SAP tables - 6.2

Talend Data Management Platform Studio User Guide

EnrichVersion
6.2
EnrichProdName
Talend Data Management Platform
task
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

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 information on locking and unlocking a project item and on different lock types, see Working collaboratively on project items.

In this step, we will retrieve SAP tables and table schemas of interest, and preview data in tables from the connected SAP system.

  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. Note that 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 in this step.

    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. Note that the Ref Table column value will be lost if you modify the Technical Name or Talend Name column value.

  5. Click Finish and the tables of interest appear under the SAP Tables folder under the SAP connection node in the Repository tree view. You can now drop the connection node or any table node under it onto your design workspace as an SAP component, with all the 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.