SAP -> PI -> MSSQL Integration

[Former Member]

Hi all,

I'm an ABAP developer and i've been asked to integrate to a SQL database through PI

and was just wondering if anyone would be able to point me in the right direction.

I need to pass a a Customer Key to PI and then use PI to read a MSSQL Database using the Customer Key

to read a couple of Boolean values from the database and then pass these back to the backend SAP system doing the Call.

SAP   -- Pass Customer Key ----- >   PI  ----- PI Reads external MSSQL ------>  Pass values back to SAP

from What I've read I need to use the JDBC connector in PI to connect to the MSSQL Database ( where do I do this - is it in Integration Design ??)

Also the SAP ABAP side i'm guessing I just create a SProxy to the PI side which passes the Customer ID and receives the Record required back.

Thanks for any pointers, i'm especially after the PI side and how I create an interface for the SAP to link into etc.

Thanks,

Dave

[baskar_gopalakrishnan2 · Accepted solution]

>Thanks for any pointers, i'm especially after the PI side and how I create an interface for the SAP to link into etc.

With the given requirement, you can try either RFC or Proxy and receiver side JDBC.  In addition to all replies, if you are looking for step by step details (how to create design objects and configuration) for the proxy to jdbc scenario, you can refer below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15...

Also a quick wiki for the step by step details for creating ESR and ID objects for RFC to JDBC

http://wiki.sdn.sap.com/wiki/display/XI/step+by+step+RFC+to+JDBC+scenario

Search SCN for information related to sender proxy and receiver jdbc.

[gagandeep_batra]

Hi dave

following link might help you

http://www.saptechnical.com/Tutorials/XI/SOAP2JDBC/Page1.htm

Regards

Gagandeep

[Former Member]

Hi,

Thanks for all the quick responses and pointers.

I'll let you know how I get on and which route I take after some more investigations and award points accordingly

Thanks,

Dave

[Former Member]

Hello Mr.Dave,

As mentioned your description above you are going to use proxy to send the customer key to PI select the records based upon customer key from the MS SQL database and return back to SAP.

Here I just suggest, instead of proxy you will use RFC to send the customer key to PI.

Normally RFC supports response message.

Use this below link to connect the database based upon the query.

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm

I suggest you better to go with BPM.

For any more questions please ask

Thank you,

Sateesh

[former_member91687]

Hello Dave,

You would need to configue the receiver JDBC adapter in the integration directory (Integration Builder: Configuration)

Regards

Chandra

[Shabarish_Nair]

If this is your first time with PI, your scenario is SAP -> PI -> DB. Technically, since you have chosen proxy it would be proxy -> PI -> JDBC scenario.

You can refer

1. http://scn.sap.com/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

2. http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

Also search in SDN for JDBC adapter for more links that will help you.

[Former Member]

Hi Shabarish,

Yes it is - I've gone for Proxies as that is what I've read.

If there is an alternative ( better way ) then That's what I was asking really.  Whats the best way to provide a solution to the scenario.

Thanks for the links - I'll have a look

Thanks,

Dave

[Shabarish_Nair]

If you are looking at option, you have IDoc, RFC or a Proxy to connect to SAP. If you already have a IDoc or RFC available to you then use that else go for a proxy. Also if the load is supposed to be high, proxy is a better solution

[Shabarish_Nair]

Also

SAP   -- Pass Customer Key ----- >   PI  ----- PI Reads external MSSQL ------>  Pass values back to SAP

>>>>

Since this is a synchronous scenario, a RFC or a sync ABAP proxy is the ideal solution.

[rajasekhar_reddy14]

Hi ,

JDBC receiver adapter supports sync communictaion so no need of BPM, if you are dealing with standard BAPI at ECC side then chose BAPI(RFC)--->PI--->JDBC sync scenario.

Or

Use ABAP Proxy at sender side,proxy also supports sync communication and implementing proxy approach is recommended one.

Regards,

Raj