What kinds of data structure reading is supported

CloverDX Platform
1

Hi, all,

according to the previous discussions, it seems that Clover ETL does not support the schema structure (column name and types) reading of dbf file, right?

Then, what kinds of data structure reading are supported?
Thanks a lot in advance for any reply.

Hannah

2

Hello,
you can obtain fmt file from dbf file as follows:
java -classpath “$CLOVER_PATH/cloveretl.engine.jar:$CLOVER_PATH/commons-logging.jar” org.jetel.database.dbf.DBFAnalyzer dbfile.dbf dbfMetadata.fmt

In CloverETL there are different readers for reading various structured data:
flat file: DataReader, FixLenDataReader and DelimitedDataReder
database: DBInputTable
dbf: DBFDataReader
xml: XMLExtract and XmlXPathReader
excel: XLSReader

and others (see http://wiki.clovergui.net/doku.php?id=c … ts:readers)

3

Thank you, Avackova.
I saw a previous message by jausperger

PostPosted: Thu Aug 02, 2007 9:22 am
Post subject: Reply with quote
Hello,

The documentation is on http://www.cloveretl.org/download/clove … -2-2-0.zip, you can see a java doc for DBFAnalyser.

An example how to use dbf file reader is in examples on wiki pages. DBFAnalyser (private analyze method) gets a dbf type, count of fields, dbf field informations, etc from dbf file. DBFDataParser class compares metadata fields and dbf fields from a dbf file and reads data. You must know how many fields and field types are in dbf file before you create metadata file. There exist some tools on internet which can read data structure of dbf file.

From this, it seems that the number of fields and field types myst be read using some other tools.
A little bit confused…

Hello,
you can obtain fmt file from dbf file as follows:
java -classpath “$CLOVER_PATH/cloveretl.engine.jar:$CLOVER_PATH/commons-logging.jar” org.jetel.database.dbf.DBFAnalyzer dbfile.dbf dbfMetadata.fmt

In CloverETL there are different readers for reading various structured data:

flat file: DataReader, FixLenDataReader and DelimitedDataReder
database: DBInputTable
dbf: DBFDataReader
xml: XMLExtract and XmlXPathReader
excel: XLSReader

and others (see http://wiki.clovergui.net/doku.php?id=c … ts:readers)

“avackova”