There were couple of questions in the forum, asking as to how do we connect to an MSAccess Database using the JDBC adapter. In this blog, i will explain as to how to connect to a MSAccess DB using receiver JDBC adapter. As a blog has already been written on 'FILE to JDBC Adapter using SAP XI 3.0' by Mr.Anirban Ghatak, this blog builds on it and just explains the part of configuring the receiver JDBC Adapter. 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,xiserverxitempdbTestDB.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,FILE to JDBC Adapter using SAP XI 3.0except 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.JdbcOdbcDriverConnection: 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;
Hope this blog was off some help.
Hope this blog was off some help.
14 Comments
