on 05-08-2014 7:26 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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.
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
1681420 - PI : Where to locate the JDBC Driver for Microsoft Access
Regards
Upendra
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.