topic tSAPInput in TOS 3.1.3 in Talend Studio

tSAPInput in TOS 3.1.3

Anonymous — Sat, 16 Nov 2024 13:53:29 GMT

Hello,

i updated to TOS 3.1.3 and tried to use the tSAPInput-component.

There are several things i do not understand (in comparison to the tSAPInput from 3.1.1).
The "Extract datas" area of 3.1.1 was changed into an "Outputs" area in 3.1.3 with different functionality.
My Question is: How can i extract the data from one field, returned by a RFC?

The RFC_READ_TABLE for example returns (among others) a table called "DATA" which contains a field called "WA".
"WA" contains all the data of the SAP-table which is read with the RFC.

In 3.1.1 i could define "DATA" as the extraction-table and "WA" as a Parameter to extract (see screenshot 1).
In 3.1.3 the prompt "ParameterName" is replaced by "Mapping" in the "Outputs" area (see screenshot 2).
What do i have to do, to extract the data from the "WA" field of the "DATA"-table and what is the "Mapping" good for?

There is another issue:
If i connect the tSAPInput with another component (tLogRow for example) i always get the error "the output schema/link named "out" has no column defined, please check it" in 3.1.3. But i can't define a schema for the "out" row (see screenshot 3) and i have defined one for the output of the tSAPInput-component.

Can somebody help?

Re: tSAPInput in TOS 3.1.3

Anonymous — Wed, 01 Jul 2009 11:46:16 GMT

Hello
On TOS3.1.1, you can only iterate one of output tables. See 5987.
On TOS3.1.3 or greater, it can iterate multiple output tables, one schema for one output table. Please see my screenshots.
Best regards

shong

Re: tSAPInput in TOS 3.1.3

Anonymous — Wed, 01 Jul 2009 11:57:27 GMT

Thanks for the reply.

Right now i am trying to test this, but the problem remains, that the tSAPInput-component has this error:
"the output schema/link named "out" has no column defined, please check it".
But i can't link a schema to it.

Even if i delete the linked output-row, the error stays, as if it was only deleted in the gui and not in the code (see attached screenshot).

Re: tSAPInput in TOS 3.1.3

Anonymous — Wed, 01 Jul 2009 13:44:12 GMT

Hello
Have you added at least one schema? Please upload a screenshot of basic setting of tSAPInput
Best regards

shong

Re: tSAPInput in TOS 3.1.3

Anonymous — Wed, 01 Jul 2009 14:40:24 GMT

Here it is (including the used schema).

Kind regards,

Christian

Re: tSAPInput in TOS 3.1.3

Anonymous — Thu, 02 Jul 2009 03:31:37 GMT

Hello

"the output schema/link named "out" has no column defined, please check it".

I can reproduct this error, if I add a new schema but don't add some columns. So, we must add some columns in a schema.
From the last image, I see you have deleted the out schema, now you can link the Data schema to tLogRow, after do this, the warning message will disappear.
Best regards

shong

Re: tSAPInput in TOS 3.1.3

Anonymous — Thu, 02 Jul 2009 09:55:58 GMT

It works now, but when i delete components, i often get errors from rows which should have been deleted with the corresponing component.

I think for now i will stick with 3.1.1.

Thank you, nevertheless.

Kind Regards,

Christian

Re: tSAPInput in TOS 3.1.3

_AnonymousUser — Tue, 07 Jul 2009 00:46:23 GMT

Hi Shong,
It appears the latest docs (UG+RG) are not updated with TOS3.1.1 changes. Appreciate if you could you please provide a working example of using the tSAPInput and tSAPOutput components?
Regards,

Re: tSAPInput in TOS 3.1.3

Anonymous — Thu, 01 Oct 2009 00:02:04 GMT

Please, get the examples of two jobs using the RFC_READ_TABLE and BAPI_COMPANY_GETDETAIL with tSAPInput component at Use tSAPInput