CSV conversion to Database

David

can you pls help me out in giving a solution for my query. with CloverETL can you just show me an example that will convert a CSV file to Database or a .txt File format.

if so can you tell me in detail about the graph used in our Framework.

PraDheep

First you have to extract/parse your CSV file. For this purpose is in the clover engine component called “Delimited data reader NIO”, in which you can define location of your input CSV file. Next for loading this way parsed data into database you can use “DB output table” component. These components you must connect with edge. To this edge assign metadata, which describe your input data. In CloverGUI we have wizard for this purpose.

Description of all standard component you can find in documentation tab on this web site (http://cloveretl.berlios.de/docs/Clover … nents.html)

Example:

<?xml version="1.0" encoding="UTF-8"?>

Please try open this graph in CloverGUI (http://www.clovergui.net/) for better visualisation.

GL, OtaSanek