Extract the data from MS ACCESS SOURCE(Database) system into XI ?

[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_member556603 · Accepted solution]

Hi Sushma,

Go through these Blogs...

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

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Thanks,

Satya

[Former Member]

thanks

[Former Member]

Hi,

Yes it will work, follow the bellow steps,

Steps

1) Create a blank database in Microsoft Access, lets call it 'TestDB.mdb'. I saved this mdb file in my XI server path itself,

xiserver\xitemp\db\TestDB.mdb

(you can save it anywhere provided it has a shared access)

2) Add a table in TestDB.mdb, call it TEST_EMPLOYEE with the following rows and save it.

EMPID type text

EMPNAME type text

EMPAGE type number

FLAG type text

3) Now follow the same steps as mentioned in the blog,

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

except for the receiver jdbc adapter configuration.

4) 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

5) In my case there is no userid and password required, but if you have userid and password, then the parameter for Connection becomes,

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

Reward Points ,if found Useful.

Thanks,

Satish.

[Former Member]

Hello,

Simply use these entries

>> <b>JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

>>Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\demo.mdb</b>

<b>****Reward Points ,if found Useful....</b>

Edited by: BVS on Apr 11, 2008 10:13 AM

Edited by: BVS on Apr 11, 2008 10:14 AM

[Former Member]

yes , it will workk

check the weblog

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

regards

krishna