Retrieving metadata from the SAP system

[Anonymous]

Hi all,
I want Retrieving metadata from the SAP system.
But i didn't find SAP wizard in Talend to connect SAP system.

Thanks
kumar.talend

[Anonymous]

Hi,
Which talend product version are you using?
The SAP wizard is available only for users who have subscribed to one of the Talend solutions. Otherwise, you need to drop the tSAPInput component from the Palette and set its basic settings manually.
See the scenario "Retrieving metadata from the SAP system" from document TalendHelpCenter:tSAPInput
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
We are using TOS 5.3.1.r104014.
I download SAP related Talend plug-in through below link
" http://www.talendforge.org/exchange/?eid=463&product=tos&action=view&nav=1,1,1"
How to keep this plug-in in Talend?
Thanks for attempt response.
Thanks
kumar.talend

[Anonymous]

Hi,
Due to it is custom plug-in written by community user. You'd better contact to the author tfoldi directly.
In addition that, I have noticed that there are Related links in this plug-in SAP Connection/Table Metadata Wizard page that I think will be useful for you.
Best regards
Sabrina

[Anonymous]

Hi all.
Finally SAP Wizard add to Metadata.
when i try to connect SAP system through SAP Wizard , i am getting error see below attachment.
I download sapjco3.jar file and installed.
I am using 64bit OS.
please help for this problem.
Thanks
kumar.talend

[Anonymous]

Hi folks,
SAP Wizard working fine.
I connected SAP systems and retrieve table schema.
For loading 32bit (sapjco3.dll) dll file in Talend Studio in 64bit,
I add a argument ("-d32") in job configuration and
Create the job like :
tSAPConnection--->tSAPInput------>tlogrow
when i execute job i am getting below error:
"Error: This Java instance does not support a 32-bit JVM.
Please install the desired version."
In PC i am using 64bit jdk.
Thanks
kumar.talend

[Anonymous]

Hi,
Is your JVM 64 bit or 32 bit?
Could you use the 32 bit talend studio to achieve it?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
i am using 64 bit JVM.
My Admin team resolve the problem.
I have a doubt in the tSAPInput component.
I am connect to the SAP System and retrieve "SFLIGHT" table schema.
"SFLIGHT" table have fields like below:
MANDT
CARRID
CONNID
PRICE
Now i am define the parameters to "Initialize input" in tSAPInput component.
for Initialize Input i am clear . I define correctly. for this no doubt.
Problem with "Outputs"
for "Outputs" I define the parameters like below:

Schema: row_sflight_1 (it have souce table fields MANDT,CARRID,CONNID,PRICE)
type(for iterate): table_input
TableName: "DATA"
Mapping: Mapping have source table field that are "MANDT","CARRID","CONNID","PRICE"
I am displaying result in tlogrow.
I am getting below error while executing the job:
"Exception in component tSAPInput_2
com.sap.conn.jco.JCoRuntimeException: (127) JCO_ERROR_FIELD_NOT_FOUND : Field MANDT is not a member of TAB512
at com.sap.conn.jco.rt.AbstractMetaData.indexOf(AbstractMetaData.java:404)
at com.sap.conn.jco.rt.AbstractRecord.getString(AbstractRecord.java:2866)
at sap_jobs.test123_0_1.test123.tSAPInput_2Process(test123.java:1024)
at sap_jobs.test123_0_1.test123.tSAPConnection_4Process(test123.java:368)
at sap_jobs.test123_0_1.test123.runJobInTOS(test123.java:1557)
at sap_jobs.test123_0_1.test123.main(test123.java:1423)"
But when i define the Output like below:
Schema: row_sflight_1 (it have souce table fields MANDT,CARRID,CONNID,PRICE)
type(for iterate): table_input
TableName: "DATA"
Mapping: I define Mapping fields like "WA","WA","WA","WA"
Job is executing.
It is mandatory to define "WA" in Mapping?
And also i observed one thing in tlogrow.
I define the output fields like "WA","WA","WA","WA" in tSAPInput component Mapping properties.
But tlogrow have source table schema like "MANDT,CARRID,CONNID,PRICE".
please give me your suggestion.
I want use source table fields instead of "WA" in Mapping, is it possible or not?

Thanks
kumar.talend

[Anonymous]

Hi,

for "Outputs" I define the parameters like below:

Schema: row_sflight_1 (it have souce table fields MANDT,CARRID,CONNID,PRICE)
type(for iterate): table_input
TableName: "DATA"
Mapping: Mapping have source table field that are "MANDT","CARRID","CONNID","PRICE"
I am displaying result in tlogrow.
I am getting below error while executing the job:
"Exception in component tSAPInput_2
com.sap.conn.jco.JCoRuntimeException: (127) JCO_ERROR_FIELD_NOT_FOUND : Field MANDT is not a member of TAB512
at com.sap.conn.jco.rt.AbstractMetaData.indexOf(AbstractMetaData.java:404)
at com.sap.conn.jco.rt.AbstractRecord.getString(AbstractRecord.java:2866)
at sap_jobs.test123_0_1.test123.tSAPInput_2Process(test123.java:1024)
at sap_jobs.test123_0_1.test123.tSAPConnection_4Process(test123.java:368)
at sap_jobs.test123_0_1.test123.runJobInTOS(test123.java:1557)
at sap_jobs.test123_0_1.test123.main(test123.java:1423)"

Could you have any screenshot for tsap component setting(mask the confidential part).
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
please see below screens.
For "Initialize Input" see 1st screen shot.
For "Outputs" see 2nd&3rd screen shot.
Thanks
kumar.talend