Configuring the Job for retrieving ADSO data from SAP BW - 7.0

SAP

EnrichVersion
7.0
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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
EnrichPlatform
Talend SAP RFC Server
Talend Studio
task
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

Procedure

  1. Double-click the tSAPADSOInput component to open its Basic settings view.
  2. In the SAP HANA database connection configuration related fields, specify the authentication information required to access your SAP HANA database.
  3. In the Name field, enter the name of the active Advanced Data Store Object whose data will be retrieved, ZAD_FIGL in this example.
  4. Click the [...] button to open the schema dialog box and define the schema by adding the columns whose data you want to retrieve. When done, click OK to save the changes and close the dialog box.

    In this example, nine columns are added, MANDT, GJAHR, BELNR, BLDAT, BSCHL, BSTAT, BUDAT, and HWAER of String type, and DMSHB of BigDecimal type.

    You can use the SAP metadata wizard to create a connection to your SAP HANA database, save the connection in the Repository, retrieve the Advanced Data Store Object and its schema to be used, drag and drop the retrieved ADSO node onto the Job design workspace as a tSAPADSOInput component, and the SAP HANA connection fields, the ADSO name field, and the schema will be automatically filled. For more information, see the related description of centralizing SAP metadata. You can then change the schema to the Built-In mode and click the [...] button next to Edit schema to update the schema definition.

  5. Double-click the tFileOutputDelimited component to open its Basic settings view.
  6. In the File Name field, specify the path to the file in which retrieved data will be written, D:/tsapadsoinput_out.csv in this example.
  7. Select the Include Header check box to include the column names in the output file.