ODBC connectivity with SAP PI 7.3

[Former Member]

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.

[Former Member · Accepted solution]

Hi ,

Please go through the below link.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/07/06/connecting-sap-pi-to-ms-access-an...

Regards

Venkat

[former_member201264]

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]

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]

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]

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]

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