postgreSQL and MySQL tables of Benetl:
Benetl is using four tables in postgreSQL/MySQL:
These new tables (entities_groups and entities_to_groups) are used in managing entities (see 16. Managing entities).
etltool_tables is a table that stores the name of each EtlTool you defined with Benetl.
If you drop an EtlTool table (created through out Benetl interface) and then create a new other etltool table then the name of the previous dropped etltool table will be automatically removed from etltool_tables.
entities is a table that stores the name of each entity you have automatically extract after running your Etltool.
Since Benetl 2.9 postgreSQL 8.4.x is supported, posgreSQL 8.3.x remains supported also.
Since Benetl 3.0 MySQL database is supported.
Benetl provides a new version of a LGPL driver for MySQL, can can download source in download section. The support of plpgsql is required for a complete use of Benetl.
The MySQL user you are using must have a password set with OLD_PASSWORD function, otherwise you will not connect to MySQL.
Since Benetl 3.8 postgreSQL 9.1.x is supported, posgreSQL 8.4.x remains supported also.
MysQL official driver is supported since Benetl 3.8
In order to use MysQL official driver, you have to provide it (mysql-connector-java-5.x.x.jar) into "C:\benetl\lib" ("/opt/benetl/lib") directory.
Then you have to adapt the classpath defined in "etltool_gui.bat" ("etltool_gui.sh") and put the path to the lib you provide.
Then you have to change the file "benetl_my.xml" in "C:\benetl"or "/opt/benetl/" like this: