Menu Close

Benetl 5.3.0 for Windows

Benetl icon

App Preview

App Name

Benetl

Description:Helps you manage datasource files (text, CSV and Excel) and process them with ease, preparing them for upload to a PostgreSQL or MySQL database
Version:Benetl 5.3.0
File name:Benetl5.3.zip
File size:
6.2 MB
Operating System:Microsoft Windows
Requirements:Windows 10 32/64 bit
Windows 8 32/64 bit
Windows 7 32/64 bit
Windows Vista
Windows XP
Windows 2K
Updated on:July 31, 2021
Downloaded:3,651 times
License:Freeware
Developer:Benoit Carpentier

Overview:

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.

More Apps

Leave a Reply

Your email address will not be published. Required fields are marked *