JDBC Sender scenario

[Former Member]

Hi All,

I am creating a JDBC -> Idoc scenario.I have a clarification required,

Do I need to create the DataType(Sender JDBC Structure) with all the fields in the table ,or if it is OK to create a Datatype with only the fields of the table which I am going to extract.

Thanks,

Venu

[VijayKonam · Accepted solution]

It is not mandatory to have the strucuture to include all the fields as long as you are following the XML structure returned by the JDBC adapter to the integration engine.

VJ

[Former Member]

You do not have to include all the fields in your data type, it depends on your business requirement.

To create datatype quickly and effeciately, you can down load a tool I wrote:

/people/liang.ji/blog/2009/03/03/data-type-generator

Regards.

Liang

Edited by: Liang Ji on Mar 17, 2009 6:41 PM