The data model is a modelization of the structure of the data in a data source. It contains all the elements necessary to be able to structure the data.
Database models in DOT Extract contain the following elements:
- Tables, as well as the different columns that populate each table, and their corresponding data,
- Foreign keys, and
- Primary keys.
The data model is generated when the data source connection is established. DOT Extract detects the data structure in the data source and creates a model of its structure. The model is stored in the Extract Server in XML format.
When the connection to the data source is modified, the data model is recalculated automatically and updated. In case the data structure in the data source is modified, you need to launch manually the update of the data model. Click the Update button to launch the generation of the data model update.
Data models are accessed and managed in the Data Sources view. Click the View Model button to access each data source model.
About data model status
When the data source connection is created, DOT Extract accesses the database and creates the corresponding data model. The data source creation status is In Progress.
Once the data model is created, the status of the data source is Available. Click the Refresh button in case your data source is not displayed yet in the list, or to check its status at all times.
If DOT Extract cannot access the database or create a data model, the status is Failed. When this is the case, you can click the View log button to display the data source description and the details of the log, providing information about why the connection failed.
You are warned when trying to get the data model of a schema that does not exist in the database.
About foreign keys
If required, you can modify manually the foreign keys in a data model. To do so, click the View button to view the details of the data model, then click the Edit button appearing next to the foreign keys. Click the Update button to save the changes.
To remove foreign key links, click the Delete button.