synchronous sender jdbc adapter

[Former Member]

Hi,

I have a database -PI - Proxy scenario

synchronous interface.

database will have a table from where records need to be selected if a particular flag is T. All the records which have a flag column value as T need to be selected and sent to SAP , SAP will generate unique identifier for each record : logic code in proxy and send this unique identifier associated with each record. But now this identifier needs ot be updated in a separate table on the same database along with a particular field from SAP which associates this record.

How can this be achieved?

Thnx

[former_member181985 · Accepted solution]

two options,

JDBC (Synchronous) > PI> Proxy (Synchronous) : Use request-response bean in the sender JDBC channel. Search forum for File>RFC>File scenario without BPM. Try to use this concept for your scenario. You need two JDBC channels, one in sender mode, the other one in receiver mode.

(ii) Change the proxy design as Asynchronous and create one more client proxy in that system and trigger this from the first proxy after it has finished its job according to your requirement. Populate the message expected by the second proxy and trigger it.

so it becomes two scenarios...

JDBC1 (Async, sender) ---> PI --> proxy1 (Async, trigger proxy2 from this)

Proxy2 (Async) ---> PI --> JDBC2 (Async, Receiver)

I prefer option II

Regards,

Praveen Gujjeti

[Former Member · Accepted solution]

I see Praveen's second option also makes good sense , but earlier i was seeing in this thread that synchronous option could also be made to work. Which option would be better ? async /sync bridge for making this sort of synchronous scneario or as was mentioned to 2 async scenarios ?

2) Async /sync bridge or proxies should work with base installation of PI 7.1 EHP1 or it needs some service pack ? i have a base installation of PI 7.1 EHP1 connectivity to ECC?

Thnx

Edited by: pi_question on Aug 1, 2010 2:28 PM

[former_member181985 · Accepted solution]

Async Sync bridge requires BPM and you might see some performance issues.....

[Former Member · Accepted solution]

With PI 7.1 does the feature of response bean come by default or do we need a certain patch level ? Thanks

[former_member200962 · Accepted solution]

It is available by default.

[Former Member]

Hi,

You can split this scenario in two interfaces:

Databse----> XI -

---

> SAP

SAP------> XI -

---

>Database

Design as follows:

1) outbound interface to select records from database

2) inbound proxy interface at SAP to generate unique indetifier.

3) Through the same proxy method trigger the second outbound interface from SAP

4) inbound interface to insert data in database

Regards,

Pragati

[Former Member]

Hi,

I have a database  -PI - Proxy scenario

You can design the interface like this -

DB (Select records, async) -> PI -> Proxy (sync) -> PI -> DB (Update records, async)

Use IP for async/sync bridge.

Regards,

Neetesh

[Former Member]

Can a stored procedure elimiate the need for a BPM ?

What you mentioned is like 2 separate interfaces or 1 interface? please elaborate.

Thank you.

[Former Member]

Can a stored procedure elimiate the need for a BPM ? 

No ... BPM is required for making the async/sync bridge.

What you mentioned is like 2 separate interfaces or 1 interface? please elaborate.

You need to create these :-

1. Message Interface outbound async from DB for select query / Sender JDBC channel.

2. Message Interface inbound sync from PI to R3 and vice versa / Receiver XI channel (ABAP proxy).

3. Message Interface inbound async from PI to DB for update query / Receiver JDBC channel.

4. BPM for async / sync bridge.

5. Other associated objects in ESR and ID.

Also, you can make a search on SDN / SAP Help with the key word - async / sync scenario.

Regards,

Neetesh

[Former Member]

Ok getting somewhat...

some questions :

1) Async sync bridge is needed since sender jdbc adapter is not synchronous ?

2) you mentioned use IP for async sync bridge in your first message ? what is IP?

3) I have aync to sync bridge and not sync async bridge in my case ? i see these as 2 different things in forums.

4) do u know any good blog you recommend for async / sync bridge?

5) I guess no stored procedure is needed if we can do a select * from column where flag = T

6) for update in second database ,we need to handle this in second PI mapping ?

Thank you .

[rajasekhar_reddy14]

>

>

> 1) Async sync bridge is needed since sender jdbc adapter is not synchronous ?

>

JDBC sender adapter will not work as a sync mode , one receiver adapter will work as sync mode.

> 2) you mentioned use IP for async sync bridge in your first message ? what is IP?

IP means integration process,that means BPM,when you create BPM interface we will define integration process.

>

> 3) I have aync to sync bridge and not sync async bridge in my case ? i see these as 2 different things in forums.

>

you have to use Asyncto sync bridge for your requirement.

> 4) do u know any good blog you recommend for async / sync bridge?

>

search in sdn....

> 5) I guess no stored procedure is needed if we can do a select * from column where flag = T

>

simple select statement enough,like below

select fiel1,filed2,field3 from table name where flag='T';

> 6) for update in second database ,we need to handle this in second PI mapping ?

>

>

yes correct you have to develop one more mapping.

Regards,

Raj