Skip to Content
avatar image
Former Member

Integrating MS Access and XI

Hi ,

Which is the best way of integrating MS Access and XI ?

Thanks and Regards,

Jyothsna.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 12, 2008 at 09:46 AM

    hi jyothsna,

    check the below blog

    Connecting to MS Access using receiver JDBC Adapter (Without DSN)

    Connecting to MS Access using receiver JDBC Adapter (Without DSN)

    regards

    kummari

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2008 at 09:58 AM

    Hi Jothsna,

    Follow the below link.

    FILE to JDBC Adapter using SAP XI 3.0

    In the receiver JDBC adapter configuration pass the following parameters,

    Transport Protocol: JDBC 2.0

    Message Protocol: XML SQL Format

    Adapter Engine: Integration Server

    JDBC Driver: jdbc.odbc.JdbcOdbcDriver

    Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb;Uid=yourid;Pwd=yourpwd;

    Above info is helpful.

    Regards,

    Jayasimha Jangam

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2008 at 10:02 AM

    Hi

    How are you planning to upload the database. Are you planning to go with direct DB access from XI or any shared folder,where you store this data and then some batch program etc uploads the database..

    First of all sender side, you can use SOAP adapter as you mentioned it is a Webservice.. But in the receiver I am not sure JDBC adapter does support this.. first of all you can find out about database properties, drivers etc.. like MS SQL etc..

    Then you can think of JDBC adapter. Else, you can dump the file into database repository and then some other job will upload the data

    Regards,

    Surya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2008 at 10:06 AM

    hi jyothsna,

    you can meet your requirement by using JDBC adapter provided by XI. for this you will need to configure a sender/receiver JDBC adapter (depending on req) and install the

    MS access driver on J2EE engine of WAS.

    for details please refer:

    Installing drivers for jdbc and jms adapters

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfcf3a

    and

    http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

    FILE to JDBC Adapter using SAP XI 3.0

    hope it helps.

    thanks.

    latika.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 12, 2008 at 10:16 AM

    Hi,

    Use JDBC adapter and configure below parameters

    ransport Protocol: JDBC 2.0

    Message Protocol: XML SQL Format

    Adapter Engine: Integration Server

    JDBC Driver: jdbc.odbc.JdbcOdbcDriver

    Connection: jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb*

    Check with basis people for JDBC driver and connection string weather they are activated or not

    Add comment
    10|10000 characters needed characters exceeded