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 any
subscription-based Talend
solution.

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. The schema is either Built-In or stored remotely in the Repository. Built-In: You create and store the schema locally for this component only. Related topic: see Talend Studio User Guide. Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. Related topic: see Talend Studio User Guide. Click Edit schema to make changes to the schema. Note that 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

Here is an example of using Talend components to retrieve data of an active ADSO (Advanced Data Store Object) from an SAP BW
system on an SAP HANA database.

Creating a Job for retrieving ADSO data from SAP BW

Create a new Job and add a tSAPADSOInput component and a
tFileOutputDelimited component onto its design
workspace.
Connect the tSAPADSOInput component to the
tFileOutputDelimited component via a Row > Main connection.

Configuring the Job for retrieving ADSO data from SAP BW

Double-click the tSAPADSOInput component to open its
Basic settings view.
In the SAP HANA database connection configuration related fields, specify the
authentication information required to access your SAP HANA database.
In the Name field, enter the name of the active Advanced
Data Store Object whose data will be retrieved, ZAD_FIGL
in this example.
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.
Double-click the tFileOutputDelimited component to open
its Basic settings view.
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.
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

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

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 6.x

0 Comments

Inline Feedbacks

View all comments

tSAPADSOInput – Docs for ESB 6.x