Skip to Content
avatar image
Former Member

ODBC connectivity with SAP PI 7.3

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 14, 2013 at 08:21 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2013 at 09:17 AM

    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-adapter-without-dsn

    Regards

    Gagan

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Feb 14, 2013 at 10:24 AM

    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-f2ac1399242f?overridelayout=true   --> Driver Deployment.

    Regards,

    Sreeni

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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