Solution using File Text (.txt extension) as entry and JDBC as out

[Former Member]

We need develop a solution using File Text (.txt extension) with separator, as entry(outbound) and JDBC SqlServer as out (inbound).

We have checked the documentation in the url: http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm and had no success.

We defined the data type structure of file text likely the data content and structured in XI like this:

Message Mapping 1 Message Mapping 2

outbound (txt) -> inbound (txt) -> outbound (txt) -> inbound JDBC,

in Message Monitoring, showed just one message with status successfull and the target wasn´t reached ( the data was not writed in SqlServer).

We didn´t understand why the Message Monitoring didn´t show us the problem with the solution developed.

Regards,

Midervilson e Mônica Andrade.

[Former Member]

The interface does not look correct to me.

You dont need to create a text file out to send the data to a DB.

File -> Sender Agreement -> File Sender Adapter -> Content Conversion -> Integration Server -> Receiver Determination -> Interface Determination (Interface Map) -> Receiver Agreemnt -> JDBC Receiver Adapter.

You dont need to output the file for JDBC.

Install JDBC Driver for your SQLServer using following guide and use JDBC Adapter.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

The JDBC receiver message format

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

regards

Shravan

[Former Member]

We identified that really have 1 message mapping involved and when using the file adadpter having a file xml to jdbc is ok, but when using a file text as entry we had the behavior described, although using the documentation described.

[MichalKrawczyk]

Hi,

but if you got only file (txt) to jdbc

why do you have 2 message mappings?

you only need one:

file - jdbc

check XI FAQ

/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions

question concerning jdbc scenarios (documents section)

if shows one file - jdbc scenario as a weblog

that you can check

Regards,

michal

Message was edited by: Michal Krawczyk

[Former Member]

We identified that really have 1 message mapping involved and when using the file adadpter having a file xml to jdbc is ok, but when using a file text as entry we had the behavior described, although using the documentation described.

[Former Member]

Thanks for your help,we solved the problem making right the the parameter of the file adapter.

Thanks for all,

Mider