File--JDBC(Synch)--File

[Former Member]

Hi All:

How we can acheive FileJDBC(Synch call)File without using BPM? Your valuable answers will helpful and rewarded with points:)

Thanks

Abid

[Former Member · Accepted solution]

file -> sync-jdbc -> file is a very simple BPM.

Do you have any constraints on using it?

if you ask me, i would go all way along with bpm, it will only consume you a couple mins to make it run.

The BPM will look pretty much like this...

[https://weblogs.sdn.sap.com/weblogs/images/251764026/bpmAsync2Sync2Async.JPG]

And for using the JDBC Receiver in Sync Mode take a look to this weblog.

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

Regards.

[Former Member · Accepted solution]

I think using BPM is only ready solution for this scenario.

Luis: We can avoid two transformation steps.....as using Transformation in BMP has performance issues.

So finally BPM will look like this:

ReceiveFile-SychSendJDBC-SendFile

and all Interface mapping need to assigned at configuration time(in ID).

Thanks

Farooq

Edited by: Farooq Farooqui on May 25, 2008 10:25 AM

[vijay_b4]

Hi Abid,

You have to go for BPM.As per my knowledge its not possible with out using BPM.

You cannot do the intergration between Synchronous process and Asynchronous process without Synch/Asynch bridge.

You can do the intergration between Asynchronous process and Synchronous process without Synch/Asynch bridge.

Reward points if this helps

Regards

Pragathi.

[Former Member]

Hi All,

The Async to Sync Bridge without BPM is possible. With the usage of Adapter Modules this is possible, but it needs XI 3.0 SP-19 onwards.

I kindly request you all to refer below similar discussion as well as all steps to be followed to do this.

Thanks

Swarup

[Former Member]

Hi All,

I dont know how good are you folks in java.

But if you are, you must be knowing that we can write java code for look ups,either using JDBC(For Database Tables) or Jco (For RFC Enabled Function Modules).

If you want to avoid writing JAVA coding, that is perfectly fine and you can go ahead with BPM.

But I would also like to request you to read what others are saying, read if you are not aware rather than directly saying no.

Regards

Pushkar Anand

[Former Member]

Hi Pushkar Anand,

I know we could do this with using the look-ups...but really I don't know why to watse the time in writing any code for it or to use BPM if the standard Adapter Modules are available.

Refer my previous post about it.

It will be nice to read under this post if there will be anymore good alternatives could be available for this.

Thanks

Swarup

[Former Member]

Hi,

I have got an unconventional solution.

you can create File to File Asynchronous Scenario and can make look up in message mapping.

you can refer to the following blog for JDBC look up.

/people/william.li/blog/2007/03/30/using-jdbc-connection-pool-in-xi-message-mapping

Regards

Pushkar

[Former Member]

HI,

This kind of Async to Sync brodge without BPM is possible. If you will be using the XI 30. with SP19 or onwards then you can use the below adapter module

add the AF_Modules/RequestResponseBean module

This module is designed for the JMS adapter to work Async to Sync bridge, but now it can be used in similar way for all other adapters also.

Make all necessary configuration for File adapter similar to JMS adapter for Module tab page.

Refer

http://help.sap.com/saphelp_nw04s/helpdata/en/45/20d1dec20a0732e10000000a155369/frameset.htm

Thanks

Swarup

[Former Member]

Hi,

Basically the two adapters which you are using dont support the Sync communication.( i.e File & JDBC)

Remember one thing, that is if it is not suport the Sync call & we need response backmeans we shld use the BPM for this communication.

Thats it

Regards

Seshagiri

[Former Member]

Hi,

Just one question

why do you needs sync interface for JDBC ??

jdbc sender just sends messages and does not need

any reponse

Thanks

Vikranth

[Former Member]

But in this scenario, JDBC is used as a Receiver.

I need to send a file to XI...XI will take that information and send it to the database system and execute Select querry...and give response of that select sql querry to Xi and put it as a Xml file in the target directory

thanks

abid

[Former Member]

hEY,

Not possible. You need to bridge. May be you can bridge at adapter level if you are in SP20 there by avoiding BPM.

How can a JDBC to FILE scenario be synch.

File does not support synch messages so it can only be asynch.

so you need to use a BPM for such a process

Thanks

Vikranth

Edited by: Khimavath Vikranth on May 24, 2008 8:29 AM

[Former Member]

Hi,

May be you can bridge at adapter level if you are in SP20 there by avoiding BPM

Can you please let us know abt this, Is there any option to avoid BPM for this communication

If YES means can you share any documents regarding the same

Regards

Seshagiri

[Former Member]

Hi Abid Farooqui,

Go through this blog its very nice.

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

Please reward points if it helps

Thanks

Vikranth