HOw to connect and extract the data from MS ACCESS SOURCE(Database) system

[Former Member]

Hi experts ,

I have to extract the data from MS access database system using JDBC adapter will it work if Yes HOW?

[Former Member · Accepted solution]

Hi,

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

We have to mention the following details in case of Ms-Access-XI-JDBC Integration

URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/XI/Workspace/xi_input.mdb

Jdbc Driver: jdbc.odbc.JdbcOdbcDriver

or

URL: jdbc:odbc:<DSN Name>

Jdbc Driver :sun.jdbc.obc.JdbcOdbcDriver

Regards

Seshagiri

[Former Member · Accepted solution]

Hi any specific blog for sendor side JDBC adapter for MS access databse.

[Former Member · Accepted solution]

HI giri,

please can you give brief idea how to configure sendor JDBC adapter for my requirement.

[former_member556603 · Accepted solution]

Hi Sushma,

how to configure sendor JDBC adapter ..

Select adapter type is JDBC..

Give the Transport Protocol:.JDBC 2.0 (Example)............

Message Protocol:...JDBC...........

IAdapter Engine : Integration Server

Processing Parameters..

Quality of service.....(Example)..Exactly once

Poll Interval .... Example ..10

Query Sql statement..Example ..select * from XXXXX

Document Name.....

Update Sql stetement.....

Thanks,

Satya

Reward points if it id useful...

[Former Member]

Hi,

please have a look here:

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Regards

Patrick

Edited by: Patrick Koehnen on Apr 11, 2008 10:00 AM