cancel
Showing results for 
Search instead for 
Did you mean: 

How to process.dbf file from ftp to PI then to sap

Former Member
0 Kudos

Hi Experts,

    How to read the .dbf file from ftp through SAP PI and then to SAP system.Is this possible through File adapter

Regards,

Selva

Accepted Solutions (0)

Answers (1)

Answers (1)

anupam_ghosh2
Active Contributor
0 Kudos

Hi Selvakumar,

                        DBF is a file format typically used by database software. DBF stands for DataBase File. DBFfiles were originally used in dBase II and continued through to dBase Version IV. These  files are also produced from Visual Foxpro. The file format of these files are complicated and can be read using low level programming using java.  the file format details you can see here

http://www.dbase.com/KnowledgeBase/int/db7_file_fmt.htm

File adapter can read these files. If you want to produce an xml output you need a adapter module or java mapping.  here is an useful link which uses java classes to read these files

http://stackoverflow.com/questions/6935600/how-can-i-query-a-dbf-file-in-java

Regards

Anupam