July 30, 2023

tSAPADSOInput – Docs for ESB 7.x

  2. Talend for ESB Docs
  3. Docs 7.x
  4. tSAPADSOInput – Docs for ESB 7.x

tSAPADSOInput

Retrieves data of an active ADSO (Advanced Data Store Object) from an SAP BW system
on an SAP HANA database.

tSAPADSOInput Standard properties

These properties are used to configure tSAPADSOInput running in
the Standard Job framework.

The Standard
tSAPADSOInput component belongs to the Business
family.

The component in this framework is available in all subscription-based Talend products.

Basic settings

Host

The IP address or hostname of the database.

Port

The listening port number of the database.

Table Schema

The table schema name.

Username and Password

The database user authentication data.

To enter the password, click the […] button next to the
password field, and then in the pop-up dialog box enter the password between double quotes
and click OK to save the settings.

Schema and Edit schema

A schema is a row description. It defines the number of fields
(columns) to be processed and passed on to the next component. When you create a Spark
Job, avoid the reserved word line when naming the
fields.

  • Built-In: You create and store the schema locally for this component
    only.

  • Repository: You have already created the schema and stored it in the
    Repository. You can reuse it in various projects and Job designs.

Click Edit
schema to make changes to the schema.

Note: If you
make changes, the schema automatically becomes built-in.

  • View schema: choose this
    option to view the schema only.

  • Change to built-in property:
    choose this option to change the schema to Built-in for local changes.

  • Update repository connection:
    choose this option to change the schema stored in the repository and decide whether
    to propagate the changes to all the Jobs upon completion. If you just want to
    propagate the changes to the current Job, you can select No upon completion and choose this schema metadata
    again in the Repository Content
    window.

Name

Enter the name of the active Advanced Data Store Object from which data will be
retrieved.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level
as well as at each component level.

Global Variables

ERROR_MESSAGE

The error message generated by the component when an error occurs. This is an After
variable and it returns a string.

Usage

Usage rule

This component is usually used as a start component of a Job or
subJob and it always needs an output link.

Retrieving ADSO data from SAP BW

This sample scenario shows you how you can use Talend components to retrieve data of an active
ADSO (Advanced Data Store Object) from an SAP BW system on an SAP HANA database.

Importing SAP BW Metadata

You can create a connection to an SAP BW system and an SAP HANA
database and store this connection in the Repository > Metadata folder.

  1. Follow the procedure in Setting up an SAP
    connection     of the Talend Studio User
    Guide.
  2. Follow the procedure in Retrieving SAP BW objects
    metadata.

    You can then use the newly created SAP metadata when you
    design the Job.

Retrieving SAP BW ADSO

Retrieve the metadata of the SAP BW Advanced Data Store Object (ADSO) using the SAP
metadata wizard.
  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.

Creating a Job for retrieving ADSO data from SAP BW

Design a Job with the SAP BW ADSO metadata that you previously
created and select the tSAPADSOInput component.

  1. Navigate to Job Designs > Standard to create a new Job.
  2. Drag-and-drop the SAP ADSO that you previously created into the
    design workspace from Metadata > SAP Connections.
  3. When prompted, select tSAPADSOInput.
  4. Add a tFileOutputDelimited component onto its design workspace.
  5. Connect the tSAPADSOInput component to the
    tFileOutputDelimited component via a Row > Main connection.

    tSAPADSOInput_1.png

Configuring the Job for retrieving ADSO data from SAP BW

  1. Double-click the tSAPADSOInput component to open its Basic settings view.

    tSAPADSOInput_2.png

  2. Check the authentication details of your SAP BW ADSO metadata.
    These fields are automatically populated after dragging-and-dropping the SAP BW
    ADSO metadata into the design workspace.
  3. Click the […] button
    to open the Schema dialog box, which
    displays the columns of data that you wish to retrieve.

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

    tSAPADSOInput_3.png

    You can also change the schema to the Built-In mode and click
    the […] button next to Edit schema to update the schema
    definition.

  4. Double-click the tFileOutputDelimited component to open its Basic settings view.
  5. 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.
  6. Select the Include
    Header     check box to include the column names in the output
    file.

Executing the Job to retrieve ADSO data from SAP BW

  1. Press Ctrl + S to save your Job.
  2. Press F6 to execute your Job.
  3. Open the file generated to check the retrieved data.

    tSAPADSOInput_4.png

    You will find only the data of the columns specified in the schema has
    been retrieved and written into the file.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 7.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x