File to JDBC

[Former Member]

Hi,

Pl Clarify the Following

1)Can I use a single Business System For Both Sender and the Receiver?

2)Pl Send Me the Step by Step Procedure with screens File-JDBC Sceneri0

Thanks

Srini

[Former Member]

Go through this for step by step sol

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a04cd6f9-9eb0-2a10-07b8-a0fc6e88...

[Former Member]

Hi Srinivasaphani,

<i>1)Can I use a single Business System For Both Sender and the Receiver?</i>

Yes you can but as told by Jai it depends on your Scenario.....

<i>2)Pl Send Me the Step by Step Procedure with screens File-JDBC Scenerio</i>

A JDBC sender adapter has 2 essential fields,

1. SQL Statement

2. Update Statement

Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just check these links to understand how JDBC adapters work,

If you wanna do update/insert you will have to follow the

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

For Configuring the Receiver JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter</a>

For Configuring the Sender JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter</a>

Please go through this blog and see if it helps you.

/people/prasadbabu.nemalikanti3/blog/2006/02/27/collecting-and-bundling-vendor-records-from-different-multiple-interfaces-file-systempeoplesoft-and-sending-to-sap-r3-system-part-2

For more info, just take a look at these links also,

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

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

All that i could get from the SAP Help regarding JDBC Adapters once when i searched for the same were these links, so go through these links and see if you find anything useful.

http://help.sap.com/bp_bpmv130/Documentation/Planning/XIUnicodeGuide030411.pdf

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm">Configuring the Receiver JDBC Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/content.htm">Mapping Lookups</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm">JDBC Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter - part 2</a>

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

For anything related to scenatios involving sender or receiver file adapters, please go thru the following links and clear all your doubts.

Communication channel:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/65/b11c409ce22402e10000000a1550b0/frameset.htm">Assigning Communication Channels</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2b/d5653fd1d3b81ae10000000a114084/content.htm">Communication Channel</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm">Configuring the Sender File/FTP Adapter</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm">Configuring the Receiver File/FTP Adapter</a>

Receiver agreement:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/56/02e63f48e58f15e10000000a155106/frameset.htm">Receiver Agreement</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/c1/5194426b44c56ae10000000a155106/frameset.htm">Creating a Receiver Agreement</a>

Sender agreement:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/db/73e03fc2269615e10000000a155106/frameset.htm">Sender Agreement</a>

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/22/522041cfb7f423e10000000a155106/frameset.htm">Creating a Sender Agreement</a>

For detailed info, I would suggest that you go through these weblogs:

<a href="/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1">Introduction to simple(File-XI-File)scenario for Starters</a>

[url=/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2]Introduction to simple (File-XI-File)scenario for starters part2[/url]

I hope it helps.

Regards,

Abhy

[sridharreddy_kondam]

Hi chandra,

It depends upon the Scenario..

Use two business systems for sender and Receiver ...

Check this weblog File to Jdbc which has Step by step..

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

Also this one further to enhance..

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Sridhar

[Former Member]

Hi,

Can I use a single Business System For Both Sender and the Receiver? --> Depends on your scenario

Pl Send Me the Step by Step Procedure with screens File-JDBC Sceneri0 --> Pl Send Me the Step by Step Procedure with screens File-JDBC Sceneri0

Hope this helps.

If you can post us the scenario we can give more details on your 1st question.

Regards,

Jai Shankar.