With the rise of industry 4.0, data management and analysis inevitably play role in industries and research. Extracting raw data and subsequently transform them to the refined version are extremely essential before transferring and loading to either local or cloud systems. In the following links, we provide download as well as installation information for the required tools of extract, transfer and load (ETL) :
- Eclipse – Java platform for databases. Install a dbeaver package to ease the database management.
- Talend Open Studio – Talend Open Studio for extract, transfer and loading.
- Mysql and Mysql-workbench – Managing Mysql databases.
- Mycli – Autocompletion of Mysql.
- Apache-ubuntu – Managing databases within localhost and integrating them with php as well javascript.
- Postgresql and pgadmin – Managing postgresql databases.
Of course there are possible works to be explored following extract, transfer and load associated with data analysis. The latter requires another experience in statistics as well as machine learning. The following links might be also useful:
- Python-lib – provides misc of libraries for machine learning using python.
- R – is extremely practical for data analysis.
- Anaconda – Open studio of Python and R.
The aforementioned links are a piece of parts from data engineer tools. In addition, there are many of them in extract, transfer and load such as IBM datastage and SSIS from microsoft. The advantages of the written links that most of them are available as open source software.
Enjoy your works!
iLi 