9. EtlTool running

EtlTool running:

When EtlTool is defined, then it runs through out a DOS-like window.

All lines read and all inserts into postgreSQL or MySQL will quickly appear on this window.

The first time EtlTool runs, the window freezes.

In Benetl the EtlTool tells when it has finished its job with a datasource file.

You can stop the window and relanch the EtlTool.bat file created into the datasource folder.

you can set in Benetl the level of debug message you would like to have.

You just have to add 0 or 1 or 2 as a second argument in EtlTool.bat file.

Example :

java -Xms256m -Xmx512m -classpath "C:\benetl\bin;C:\benetl\bin\etlpack;C:\benetl\lib\postgresql-42.2.14.jar;C:\benetl\lib\mysql-connector-java-8.0.21.jar;C:\benetl\lib\jxl-2.6.12.jar;C:\benetl\lib\jaxb-api-2.3.1.jar;C:\benetl\lib\jaxb-impl-2.3.4.jar;C:\benetl\lib\javax.activation-api-1.2.0.jar;C:\benetl\lib\log4j-api-2.17.1.jar;C:\benetl\lib\log4j-core-2.17.1.jar;C:\benetl\lib\jackson-core-2.10.3.jar;C:\benetl\lib\jackson-databind-2.10.3.jar;C:\benetl\lib\jackson-annotations-2.10.3.jar" etlpack.EtlRun "./control_file.xml" 2

0: means only very important debug information

1: means very important and important debug information

2: means all debug information