Benetl

Benetl can come in handy to those who are working with PostgreSQL or MySQL to manage their data. Categorized as an ETL tool, it can extract data from CSV, TXT, and XLS files, transform it, and then load it into a PostgreSQL or MySQL database.

Providing a simple way to manage your data source files, Benetl requires Java JRE and runs via the command console, displaying all the steps required to process the input data inside a rather intuitive wizard.

But before you start it, make sure your database solution of choice is properly configured. Otherwise, the connection to the database will not be established. For instance, you must enter the correct database URL, username, and password in the configuration file. Depending on whether you want to use PostgreSQL or MySQL, there are additional requirements you must take into account (for instance, MySQL users need to make sure there is an old password for the current database user).

Once you got everything set, just start Benetl to initiate the wizard. You are prompted to select the line number from which you want the application to read the input file, and Benetl immediately retrieves the fields it finds in the source file. Optionally, you can add additional fields to the list.

Next, you must define the use of each field, taking into account that one entity field and one date field are mandatory for each line. To process your data further, Benetl asks you whether all the lines in the database should be unique or not, and allows you to define a name for the created ETL tool, which will also be the name of the resulting database table.

The script file Benetl creates can be added to the Windows task scheduler and executed periodically, which enables you to update your database automatically.

Benetl provides an efficient way to process data source files and update a particular PostgreSQL or MySQL database. Unfortunately, it only works with these two database servers. Once you manage to connect it to the database, the integrated wizard does the job for you, creating a script that allows you to automate this task.