Skip to Content
author's profile photo Former Member
Former Member

Read data from MSaccess

Hi Experts

I have installed my PI system on Solaris. Can you please let me know whether we need to install any driver to read data from MS access .If yes please provide driver.

Or else what needs to be configured on sender jdbc channel for driver to read data from msaccess

Regards

Sandeep

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2012 at 08:06 AM

    Hi Sandeep,

    for database, SAP does not provide the drivers as it's a non-SAP product. You have to get them from your supplier: MSAccess.

    Then by reading SAP help, you will know exactly where and how to deploy these drivers to your SAP PI server: [http://help.sap.com/saphelp_nwpi711/helpdata/en/22/b4d13b633f7748b4d34f3191529946/content.htm], see chapter "prerequisite".

    On SDN, by using search button ⚠️ you will find plenty of docs, blogs, etc.. on the same subject: JDBC adapter.

    Regards.

    Mickael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2012 at 08:55 AM

    Hi,

    > I have installed my PI system on Solaris. Can you please let me know whether we need to install any driver to read data from MS access .If yes please provide driver.

    > Or else what needs to be configured on sender jdbc channel for driver to read data from msaccess

    If MS Access is in the same system (where PI is installed) then no need to install the MS Access drivers. There is a standard path that is

    JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

    Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<<DB_Path>>/<<DB_Name.mdb>>

    Here <<DB_Path>> Means where the DB is stored in the server.

    FYR

    http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2590

    Regards,

    Venkata Ramesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      > yes i am getting error in communication channel. The Ms access file is on another server its not on PI server.I think that doesn't make any difference

      In the connection path we have to give the MS Access database path (After we create the MS Access database we can save in some where like C:\Documents and Settings\name\Desktop so the PI server searches for this path in the same system/server.

      Below link may be useful to you

      http://forums.sdn.sap.com/thread.jspa?threadID=71136

      Regards,

      Venkata Ramesh

  • Posted on Feb 16, 2012 at 11:05 PM

    Deploy the ojdbc14.jar,msbase.jar, mssqlserver.jar, msutil.jar in the aii_af_jmsproviderlib.sda file

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfcf3a?QuickLink=index&overridelayout=true

    It will work.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gabriel

      The drivers suggested by you ojdbc14.jar,msbase.jar, mssqlserver.jar, msutil.jar are of Oracle & MS which works only on Windows OS

      Will these drivers work on Solaris OS?

      Please help as i have the same requirement as that of Sandeep where my PI is installed on Solaris OS and i need to connect to MS access DB.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.