When your definitions are complete, you can use them to generate your schema. This produces:
- The types and other configuration required to hold the data in the schema designer.
- The types and other configuration required to modify the data in a change set in the schema designer.
- The definition files required to drive data consolidation in the data hub.
- The DDL required to set up tables in the data hub.
The schema is updated by creating a release and then applying the release. This process is additive, adding new definitions, overwriting definitions with the same references, but not deleting parts of the schema. If you want to delete parts of the schema, navigate to those parts in the schema designer, and use the standard delete options.
To create a release, go the the releases folder and use the New Release button to create a new release. On the release:
- List the entities you want to include (including ones you haven't changed). Data hub and schema designer definitions will be created for all of these.
- List new or changed source systems from which you want receive data.
- Select the type of database for which you want to generate DDL.
Save the release then use the Apply option under the Action button to apply the changes.
The release process is additive, but each run recreates the default schema. Each release should therefore list all entities, including ones you have not changed.