cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC connectivity with SAP PI 7.3

Former Member
0 Kudos

Hi All,

Can anybody suggest  how we can connect or prerequisites required for ODBC to SAP PI 7.3 .

Please provide your inputs. Its urgent. Dont just view It. Your quick response is appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Answers (2)

Answers (2)

former_member201264
Active Contributor
0 Kudos

Hi Krishna,

If you are using ODBC side MS Acces Data then you can use this link:

http://sapxitutorials.blogspot.com/2009/03/jdbc-2-jdbc.html

If you are using any Oracle or MS SQL Server then you use below:

Be careful while giving Driver Connection the adapter as per the Database vendor.

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

http://wiki.sdn.sap.com/wiki/display/XI/File+to+JDBC+Step+by+Step  --> JDBC Receiver Side

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...   --> Driver Deployment.

Regards,

Sreeni

Former Member
0 Kudos

Hi Sreeni,

Vendor is ODBC at their end which is going to be used for SCADA integration and for that ODBC to PI connectivity is there. Your blogs are helpful.  So i need to check now Driver installation with BASIS as I dont have much idea about ODBC

Private_Member_14913
Contributor
0 Kudos

Hi Kanisha,

How did you configure the communication channel in PI?

For me GE is our Vendor which supports only ODBC connections, If you can let me know which driver was installed and what exact configurations were done would be really helpful.

Thanks,

Sameer

gagandeep_batra
Active Contributor
0 Kudos

Hi Kanisha,

Check the following link to connect PI with ODBC ie. MS-Access that may help you

http://scn.sap.com/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-...

Regards

Gagan

Former Member
0 Kudos

Hi Gagan,

Thanks. As Vendor is having ODBC at their end. So, as per the blog you sent,  database person will create the blank database and should make relevant connectivity. I want to understand wat is to be done from PI  expert. As per my understanding in case of JDBC, we install drivers with the help of BASIS and

then make required entries in PI.

Please suggest