cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Structure modification.....

Former Member
0 Kudos

Hi All,

We have imported JDBC structure from legacy staging table thru external definations and the problem is

that we could not use that it in our message mapping because we have JDBC receiver adapter.

Can any one suggest us how to add the row,access,table fields in the target structure so as suit JDBC

schema ?

Thanks,

Accepted Solutions (0)

Answers (4)

Answers (4)

nabendu_sen
Active Contributor
0 Kudos

Hi Kumar,

We upload JDBC Structure as External Definition of type 'dbtb' to perform mainly standard function JDBC Lookup. For Receiver JDBC Communication, you need to use the JDBC Structure provided by SAP (above mentioned by Baskar).

Please find a sample scenario for Receiver JDBC: http://saptechnical.com/Tutorials/XI/RFC2JDBC/Index.htm

rajasekhar_reddy14
Active Contributor
0 Kudos

1)You cant use imported XSD for receiver JDBC stracuture.

2)Editing XSD manully is not a right idea.

3)You need to created JDBC receiver data type structure as per standard format.

check above links provided by other experts and follow the same.

baskar_gopalakrishnan2
Active Contributor
0 Kudos

For jdbc structure, you need to follow the recommended message structure as given by sap help link.  You can follow select or update structure accordingly to your requirement as specified by link. Please make sure it matches table name etc as recommended. You can create structure by following the naming syntax given in the xsd using the below link structture.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

Former Member
0 Kudos

create required structure in a seprate data type for (row , access ,table fields - all control fields) and under it refer your external data type by selecting Data Type option in TYPE section.

Former Member
0 Kudos

Hi Kumar,

Create your own structure and assign your xsd.  Assign the xsd in the below highlighted place.

Thanks,

Satish.

Former Member
0 Kudos

Hi Kumar,

As satish  said you can do the same or else edit the wsdl manually in local system and upload the same into PI server as an external definition.