cancel
Showing results for 
Search instead for 
Did you mean: 

How to read accdb and mdb files using JDBC or File Adapter

Former Member
0 Kudos

Hi,

How to read and extract the .accdb and .mdb files  from FTP server and parsing into xml  by using FTP or JDBC Adapter in SAP PI7.11 With linx Os.

Regards

Upendra

Accepted Solutions (0)

Answers (1)

Answers (1)

iaki_vila
Active Contributor
0 Kudos

Hi Upendra,

If you work with files you would need a java class in the adapter or in the mapping to do the conversion to XML. I think it is better to connect via jdbc to get the data because the XML transformation is direct, later you can use a message mapping to convert the PI JDBC XML to you target XML.

Where do you need this data?, for example if you need the data in a SAP  ECC, you can do a Proxy-JDBC scenario with a select in the receiver side (http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15...)

Pay attention that to use the JDBC adapter you will need to install the DB drivers first.

Regards.

Former Member
0 Kudos

Hi Thanks for your replay,

Please let me know which driver required to read .accdb and .mdb files. And what will be connection string ..because i have read the  .accdb and .mdb files from FTP Server.

Also please provide me where can i download the drivers.

Regards

Upendra

iaki_vila
Active Contributor
0 Kudos

Hi Upendra,

Personally i havent worked with access DB and PI, but the driver procedure installation can't differ about others DBs. However, you have several threads/blogs talking about this issue:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/07/06/connecting-sap-pi-to-ms-access-an...

https://scn.sap.com/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc...

JDBC driver for Microsoft Access | SCN

Also you should check the SAP notes relatives to the access driver installation, i've found this one:

1681420 - PI : Where to locate the JDBC Driver for Microsoft Access

Regards.

Former Member
0 Kudos

Hi,

As per SAP note:1681420 i have to  install the below  driver from Microsoft

Our SAP PI installed under Unxi OS ,how to install the driver (.exe file) .

Driver name :AccessDatabaseEngine_x64.exe


Url:Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Cent...

1681420 - PI : Where to locate the JDBC Driver for Microsoft Access



Regards

Upendra