Benetl 4.9.1
Benetl : Helps you manage datasource files (text, CSV and Excel) and process them with ease, preparing them for upload to a PostgreSQL or MySQL databaseBenetl 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.
Requires prior configuration of the database connection
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).Process your data and create an automation script
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.Extract, transform and load data source files
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.Conclusion
To conclude Benetl works on Windows operating system(s) and can be easily downloaded using the below download link according to Freeware license. Benetl download file is only 2 MB in size.Benetl was filed under the Word Processing category and was reviewed in softlookup.com and receive 5/5 Score.
Benetl has been tested by our team against viruses, spyware, adware, trojan, backdoors and was found to be 100% clean. We will recheck Benetl when updated to assure that it remains clean.
Benetl user Review
Please review Benetl application and submit your comments below. We will collect all comments in an effort to determine whether the Benetl software is reliable, perform as expected and deliver the promised features and functionalities.Popularity 10/10 - Downloads - 49 - Score - 5/5
Softlookup.com 2023 - Privacy Policy
| Category: | Word Processing |
| Publisher: | Benoit Carpentier |
| Last Updated: | 16/11/2023 |
| Requirements: | Windows 10 64 bit / Windows 10 / Windows 8 64 bit / Windows 8 / Windows 7 64 bit / Windows 7 / Windows Vista / Windows XP / Windows 2000 |
| License: | Freeware |
| Operating system: | Windows |
| Hits: | 600 |
| File size: | 2 MB |
| Price: | Not specified |
| Name: * |
E-Mail: * |
| Comment: * |
|