One Star

Retrieving metadata from the SAP system

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
12 REPLIES
Moderator

Re: Retrieving metadata from the SAP system

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving metadata from the SAP system

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
Moderator

Re: Retrieving metadata from the SAP system

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving metadata from the SAP system

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
One Star

Re: Retrieving metadata from the SAP system

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
Moderator

Re: Retrieving metadata from the SAP system

Hi,
Is your JVM 64 bit or 32 bit?
Could you use the 32 bit talend studio to achieve it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving metadata from the SAP system

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
Moderator

Re: Retrieving metadata from the SAP system

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving metadata from the SAP system

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

Re: Retrieving metadata from the SAP system

Hi,
If your table name is "row_sflight_1 ", why did you set your TableName in "output" as DATA?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving metadata from the SAP system

Hi Sabrina
In my job i am just display the data in console(tlogrow).
i.e i given TableName as "DATA".
Thanks for quick replay.
Regards,
kumar.talend
One Star

Re: Retrieving metadata from the SAP system

Hi Folks,
Any one help how to define output properties in tSAPInput.
I want load data from SAP Systems to postgresql.
Ex: SAP have customer table and fields are customer_id,first_name,last_name
i want load SAP customer table into postgresql customer table(it have customer_id,first_name,last_name fileds)
i given in Mappings like below but it is not working.
customer(SAP) customer(postgresql)
customer_id--------------customer_id
first_name----------------first_name
last_name----------------last_name
it's showing below error.
"Field customer_id is not a member of TAB512"
how to load data from SAP Systems to other Database?
how to define Mapping?
For TableName(Structure Name) can i give SAP Table name or postgresql Table name?
i want load customer_id data into (postgresql customer table) customer_id
first_name into (postgresql customer table) first_name
last_name into (postgresql customer table) last_name
please provide some sample screen shots.....
Thanks in advance.

Regards,
kumar.talend