JDBC -> XI -> File

[Former Member]

Hi,

Can i send information in SQL Server batabase to file using JDBC connection in XI. If so can u please explain me the step by step procedure.

Thanks & Regards.,

Pushparaju.B

[Former Member · Accepted solution]

Hi Pushparaj,

yes you can.

First create qour SQL statement in a tool like e.g. TOAD.

If the statement works, create a communication channel, type JDBC/Sender with your SQL statement.

If it works, you will see messages using transaction SXMB_MONI.

On the message you see, you can create the objects (datatype, message-type) you need in the integration repository.

Then create your mapping.

Regards mario

[former_member184619]

hi ,

Just check out this 1 too.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Regards

Sachin

[Shabarish_Nair]

do ref this guide for a better understanding;

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

[bhavesh_kantilal]

Hi,

Also take a look at this blog to understand the useof JDBC adapters in XI,

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

Regards,

Bhavesh

[MichalKrawczyk]

hi,

sure you can:

sender jdbc adapter will pull the DB

and you can send this data to XI (and from there to a file)

Regards,

michal