tSAPODPInput
HANA, SAP R/3, and S4/HANA) through ODP (Operational Data Provisioning).
For more information about SAP ODP, see Operational Data Provisioning (ODP) and Delta Queue (ODQ).
tSAPODPInput Standard properties
These properties are used to configure tSAPODPInput running in the Standard Job framework.
The Standard
tSAPODPInput component belongs to the Business family.
The component in this framework is available in all subscription-based Talend products.
Basic settings
Property Type |
Select the way the connection details
|
Use an existing connection |
Select this check box and from the Connection configuration drop-down list displayed, select the component When a Job contains a parent Job and a child Job, the list |
Server Type |
Select the type of the SAP server to be connected, either |
Client |
The SAP system client ID. |
UserId and Password |
The user connection ID and password. To enter the password, click the […] button next to the |
Language |
The language of the SAP system. |
Host name |
The name or IP address of the host on which the SAP server is |
System number |
The SAP system number. This property is available only when Application |
System ID |
The SAP system ID. This property is available only when Message |
Group Name |
The SAP group name. This property is available only when Message |
Schema and Edit schema |
A schema is a row description. It defines the number of fields
Click Edit
schema to make changes to the schema. Note: If you
make changes, the schema automatically becomes built-in.
|
Service name |
The name of the operational delta queue. For more information, see Introduction to Operational Delta |
Subscriber name |
The name of the subscriber that consumes data from SAP. |
Subscriber process name |
The name of the subscriber process. |
Execute a full extraction |
Select this check box to perform a full extraction to retrieve all data from |
Reset subscriber |
Select this check box to reset the subscriber to make an initial load. |
Selection Group |
Specify the search condition(s) used to filter
The following wildcard characters can
|
Specify a shared destination |
Select this check box and specify the shared destination in the Besides specifying the shared destination name in the component, Note that if you use the component’s own connection configuration, |
Use FTP-Batch Options |
Select this check box when the size of data to be retrieved is larger than The following properties need to be specified when this checkbox is
|
Advanced settings
Fetch size |
Enter the fetch size (in KB) that specifies the amount of |
SAP Properties |
If you need to use custom configuration for the SAP system being
used, complete this table with the property or properties to be customized. For example,
This property is not visible when the Use an existing |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at the Job level |
Global Variables
ERROR_MESSAGE |
The error message generated by the component when an error occurs. This is an After |
Usage
Usage rule |
This component is usually used as a start component of a Job or |
Limitation |
Specific jar and dll files provided by SAP must be added to your
Studio and the workstation hosting your Studio. The exact procedure varies among platforms such as 32-bit or 64-bit Windows or Linux.
|
Support |
You can use tSAPODPInput to interact with SAP S4/HANA. |
Retrieving data from SAP through ODP
Provisioning).
Creating a Job for retrieving data from SAP through ODP
The operational delta queue 0FI_GL_14, the subscriber
GCLAUSS, and the subscriber process
GCLAUSSN_FIGL14 to be used have been configured in SAP.
You can start transaction ODQMON in SAP GUI to monitor them.
For more information, see Introduction to Operational Delta Queues.
-
Create a new Job and add a tSAPODPInput component and a
tFileOutputDelimited component onto its design
workspace. -
Connect the tSAPODPInput component to the
tFileOutputDelimited component via a Row > Main connection.
Configuring the Job for retrieving data from SAP through ODP
-
Double-click the tSAPODPInput component to open its
Basic settings view. -
In the connection configuration related fields, specify the authentication
information required to access your SAP system. -
Click the […] button to open the schema dialog box and
define the schema by adding four columns, GJAHR,
DMSHB, and HWAER of String
type, and BUDAT of Date type with the date pattern
yyyy-MM-dd, whose data will be retrieved.You can use the SAP metadata wizard to create a connection to your SAP
system, save the connection in the Repository, retrieve the Business Content
Extractor and its schema to be used, drag and drop the retrieved Business
Content Extract node onto the Job design workspace as a
tSAPODPInput component, and the connection
configuration and the schema will be automatically filled. For more
information, see the related description of centralizing SAP metadata. -
In the Service name field, enter the name of the
operational delta queue to be used, 0FI_GL_14 in this
example. -
In the Subscriber name and Subscriber process
name fields, enter the names of the subscriber and subscriber
process to be used, GCLAUSSN and
GCLAUSSN_FIGL14 in this example. -
Select the Execute a full extraction check box to
retrieve full data from the SAP system. -
Click the [+] button below the Selection
Group table to add as many filters as needed to filter data to
be retrieved and specify each filter.In this example, only the records whose BUDAT value is
set between 1995-05-01 and
1995-05-31 and is not equal to
1995-05-22 will be retrieved, so the following
two filters will be added.-
One filter is set on the column BUDAT, with
the sign Include, the operator
Between, the low value
19950501 and the high value
19950530, which will filter the records
whose BUDAT value is set between
1995-05-01 and
1995-05-31. -
Another filter is also set on the column
BUDAT, with the sign
Exclude, the operator
Equal, and the value
19950522, which will filter out the
records whose BUDAT value is equal to
1995-05-22.
To check which column can be used to define a filter, start transaction
RSA2 in SAP GUI and display all fields definition
for 0FI_GL_14, only the field whose
Selection Poss. check box is selected can be used
to define a filter. -
-
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:/tsapodpinput_out.csv in this example.
Executing the Job to retrieve data from SAP through ODP
- 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 in the file that all records whose BUDAT
value is set between 1995-05-01 and
1995-05-31 and is not equal to
1995-05-22 have been retrieved.