Transfer data-lite (ETL)
Transfer data (lite)- it's simple ETL (Extract, Transform, Load) a mechanism for transferring data between different DBMS (Oracle, PostgreSQL, MySQL, MSSQL and others including ODBC connection).
The data transfer wizard allows you to create a task for transferring information between different DBMS (or from/to a file) in a matter of seconds and save it for later use.
![ETL manager](https://static.wixstatic.com/media/513478_87530200c084492793410dfde6ba74e5~mv2.jpg/v1/fill/w_899,h_437,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/General.jpg)
Control buttons
![menu](https://static.wixstatic.com/media/513478_b2d3d39a3a7646ec8084afec33785a99~mv2.jpg/v1/fill/w_65,h_683,al_c,q_80,usm_0.66_1.00_0.01,enc_auto/menu.jpg)
Create Sheet
Delete Sheet
Update feature tree
Register node name in directory
Add a child object to the current node in the tree
Delete tree node
Save the data transfer settings of the current sheet as a template
Start data transfer
Stop task
Go out
Tree formation
Tree formation consists of 2 operations
-
Registering the hostname system in the directory
-
Tree filling
Registering in the hostname directory
Press the button "Register node name in directory"
![Create new parent row](https://static.wixstatic.com/media/513478_76fb9d4997434457a7a407e1d00a0b53~mv2.jpg/v1/fill/w_144,h_86,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/Create%20new%20parent%20row.jpg)
-
In field "value" enter entry name
-
Press the button "Save"
-
Repeat steps 1-2 as many times as needed
-
Close a window
Tree formation
-
Select a node in the tree
-
Press the button "Add child object"
![Insert child row in tree](https://static.wixstatic.com/media/513478_24e578cc8e4b4c029ececeef8eb1fc79~mv2.jpg/v1/fill/w_144,h_70,al_c,q_80,usm_0.66_1.00_0.01,blur_2,enc_auto/Insert%20child%20row%20in%20tree.jpg)
-
From the drop-down list, select either the selected node or "root line" (root entry)
-
In field "parent list" select the entry to add
-
Press the button "insert children"
-
Repeat operations if necessary