Retrieving SAP BW ADSO - 7.3

SAP
Version
7.3
Language
English
Product
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > SAP components
Data Quality and Preparation > Third-party systems > Business applications > SAP components
Design and Development > Third-party systems > Business applications > SAP components
Retrieve the metadata of the SAP BW Advanced Data Store Object (ADSO) using the SAP metadata wizard.

Procedure

  1. In the Repository tree view, right-click the newly created SAP connection and select Retrieve SAP BW metadata.
  2. Select AdvancedDataStoreObject from the Search in drop-down list.
  3. Fill in the relevant information on the following fields:
    • Name: enter the filter criterion for the object name
    • Description: enter the filter criterion for the object description
    Note: The filter criteria, Name and Description, act together as an OR operator.
  4. Click Search to list all the objects that match the filter criteria.
  5. Select the tables that you wish to retrieve by marking the checkbox in the Name column.
  6. Wait for the Creation Status to display Success.
    The tables and their schemas of the selected objects are saved in the Repository tree.
  7. Click Next to proceed to the next step.
    All tables of the selected objects are listed in the Table Name area.
    1. Click Refresh Table to display the latest table schema in the Current Table area. You can modify the schema of the selected table in the Current Table area, if needed.
    2. Click Refresh Preview to preview data in the selected table, if needed.
  8. Click Finish to save the tables and their schemas in the Repository tree view.