Today, we are prepared to further refine the functionality and make it more automated, based on the gadget model_sql written @zhangkai05. Convenient for modeling personnel to develop ETL tasks.
After the source code changes, it is published to Git (URL address) and is gradually perfected.
Describe the status quo and problems
Team Data Warehouse modeling began using the Oracle SQL Developser Datamodeler Modeling tool 2013 years ago, but was not intended to be purchased because the latter was a commercial charge software. Therefore, after investigation, we turn to Oracle modeling tools. Although its ease of use is very different from power designer.
ETL development is using the Etljet tool.
How to quickly automate the generation of Etljet configuration files based on Datamodeler, hive build table statements is a valuable issue?
My ideas and solution ideas
Analysis of the current logic of @zhangkai05 Model_sql
Main code formation