In the Full Generation tab, you can generate DDL and ETL/ELT code. To do this, select the desired settings from the drop-down lists. Firstly, select your project, data vault and data vault release. Then, you must choose which sources to include in the generation. You can choose to generate the code for all sources or for one specific source. The DB type is filled in automatically, since this was chosen when you created the data vault. Subsequently, you must choose the ETL generation type and the load type. The ETL generation type corresponds to the output language. Depending on the DB type, you can choose, among others, SQL, Groovy and Talend. The load type can be the initial load, incremental load or both. Lastly, you can specify for which layers/objects types you want to generate code.

Clicking one of the blue buttons will launch a set of tasks for generating and sending the code to your agent.

By default, the generated code is put in the “generated_files” folder inside the folder where your agent is located. If you changed the “path.in” variable in the “client.properties” file, the files can be found in the specified path instead. You will find a zip file named “id_DDL.zip” or “id_GENERATE_ETL.zip”, where “id” is the ID for a certain code generation, so the latest generation will have the largest ID.

To deploy the generated code, see Deployment of generated code.

Make sure you have defined your ODI or Talend setting before generating any ETL/ELT.