Benetl core configuration:
The core of Benetl is located into C:\Benetl folder.
The software and its libraries are located into this folder.
This folder is used to create EtlTool for your datasource.
In C:\Benetl you can find a file called: "benetl_pg.xml".
In C:\Benetl you can find a file called: "benetl_my.xml".
This is brought by Benetl 3.0. In this file you will define how to use MySQL as the database used by Benetl. If you want to use MySQL, you have to remove "benetl_pg.xml" from C:\Benetl.
You have to change the line with the url, the user and password of postgreSQL/MySQL, in order to be able to connect to postgreSQL/MySQL, in order to create Benetl tables and all the tables for your EtlTools (datasources).
The example shown in the picture is the current one:
You need first to install postgreSQL or MySQL and define a database, in order to install Benetl.
You can learn more about Benetl’s tables at: 14. postgreSQL and MySQL tables of Benetl
For MySQL users: the provided driver needs an old password for your user, you have to use queries like theses:
UPDATE mysql.user SET Password = OLD_PASSWORD(’mypassword’) WHERE Host = ’localhost’ AND User = ’myuser’;
This is not necessary if you are using the MySQL official driver:
Benetl 3.8 is now supporting MysQL official driver.
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: