DataType Structure for Sender JDBC

[Former Member]

Hi All,

Can anyone provide me some information on how a sender datatype database structure should look like .

For example i need to retrive empno,empid,place * other values from database via stored procedure

Will the strcuture be similar to normal Datatype we create as shown below:

Record

Empname

EmpID

Place

Regards

Vinay P.

[former_member238007 · Accepted solution]

Hi Vinay,

Sender structure of the database can be declared as your wish, but by default

we use resultset as the header and under that fields are declared, the reason why resultset is used becasue in the sender

JDBC adapter we have DocumentName as resultset by default, if you use any other name that particular header name should be declared there in the Document Name which is in the sender JDBC adpater..

regards,

Kishore..

[Former Member]

Thanks for the reply

[Former Member]

Hi Vinay,

the sender jdbc structure could be like

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset>

FYI, I have some blogs on sender JDBC adapter and I am sure you will find them interesting while creating a scenario:

[http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm]

[http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417400)ID1636393650DB10213226047035219960End?blog=/pub/wlg/4428]

Also you can use a new feature of P7.1and Import SQL Table's Metadata. Refer the blog:

[http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417400)ID1636393650DB10213226047035219960End?blog=/pub/wlg/7346]

Regards,

Puneet

[rajasekhar_reddy14]

Hi,

There is no stadard format for sender JDBC Scenarios,but there is satdard format for Receiver Scenarios.

if your are using PI7.1 then you can direclty import table structure as External definition,it avoids creating data type manually.

Regards,

Raj