Implimenting the scenario between SQL server 2003 & Oracle version 8.0.4

[jagesh_lakdawala]

Hi Experts,

I have one Scenario between SQL Server 2003 & Oracle version 8.0.4

Is this kind of scenario possible using SAP PI 7.1?

and if it is possible then please suggest me the pre-requisits(like Driver installation).

Thanks in advance.

Regards

Jagesh

[Former Member · Accepted solution]

Hi Jagesh,

Follow this blog for Driver Installation:

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

Also you have to download appropriate .jar files for your Sender and Receiver Systems. You can find them here:

www.microsoft.com/downloads/details.aspx?familyid=9f1874b6-f8e1-4bd6-947c-0fc5bf05bf71

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

or just search google for them. I hope it solves your query.

Regards

Arpil

[Former Member]

Hi,

Yes you can do the scenario with PI7.1

Please check below links to install drivers in PI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

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

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

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

Regards,

Phani

[Former Member]

Yes you can do this with PI. PI is meant for that only

For this you need to install the SQL and Oracle Drivers using SDA.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/cdded790-0201-0010-6db8-beb9bb2b...

Check the SDN too. for more details of drivers

HTH

Rajesh