R3 to Oracle interface

[Former Member]

Hi,

To create a B2B scenario, R3 --> XI --> Oracle Database......What are the adaptors used at the sender end and at the receiver end.

Is it right to use BAPI/IDOC at the sender end (for R3) and JDBC at the Receiver end.

But B2B scenarios are done through the firewalls. So, are IDOC/RFC and JDBC adaptors have security configurations?

If not, what adaptors can be used?

Thanks in Advance, I will assign points.

[Former Member · Accepted solution]

Hi San,

below sap Help will give you an Good idea for Reaciver Jdbc Adapter when you r desiging interface between SAPr/3 --> Oralce.

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

Here are few web logs will give you an idea

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

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

/people/thorsten.nordholmsbirk/blog/2006/07/25/structuring-integration-repository-content--part-1-software-component-versions

Hope these Info will help you.

Regd's

Hari

[Former Member · Accepted solution]

Hi Hari,

This doesn't really tell much about the B2B scenario (through firewall).

Are IDOC/RFC and JDBC adaptors secured?

If not, what adaptors are used that are secure.

Thanks,

[moorthy · Accepted solution]

Hi,

If you want to do B2B communication, you need to setup services etc. If you are planning to communicate with Oracle database thru Oracle Application, then you can use thirdparty adapters for oracle applications.

to know more-about B2B adapters-

http://service.sap.com/netweaver -> SAP NetWeaver in Detail -> Process Integration -> SAP Exchange Infrastructure ->SAP XI in Detail -> Connectivity.

Helpful thread-

FYI - RFC adapter supports Secure Network Communication

Regards,

Moorthy

[Former Member · Accepted solution]

Lets assume for Secutiry purpose, if I am using RNIF adaptor. But if I am using a R3 --> XI --> Oracle scenarios and sending the IDOC data to the Oracle then I don't really have to create a communication channel for the sender right? Then where do I specify the RNIF adaptors in my scenario. So, in that case, is the message transmission not secure?

Thanks,

[agasthuri_doss · Accepted solution]

Hi,

From your Other Thread ....

>>>I do have the same question. For IDOC --> XI --> Oracle, (B2B) scenario what are the adaptors used in the sender and receiver side that are secure.

1) IDOC - from Sender side

2) JDBC from reciever side

>>>I don't really have to create a communication channel for the sender right?

yes, Since IDOC is ABAP Stack.

>>>But B2B scenarios are done through the firewalls

So the Firewall systems pass the your systems with the defined port. The Port is defined by you .Mean time JDBC is secured one to my knowledge.

Regards

Agasthuri Doss

[Former Member]

Hi San,

A useful blog..

/people/udo.martens/blog/2005/09/30/one-logical-system-name-for-serveral-bpm-acknowledgements

cheers,

Prashanth

P.S Please mark helpful answers

[Former Member]

Prashanth,

This blog gives idea about a A2A scenario. But I would like to know more about B2B.