Business Example to Create a Custom Model
In the following use case, the requirement is to ingest the extracted metadata from the Microsoft Access database that you provide in the links.csv and objects.csv files. Enterprise Information Catalog does not provide a model for Microsoft Access database and you cannot use any of the existing models in Enterprise Information Catalog. You must create a custom model to represent the metadata for Microsoft Access database, in the catalog.
The custom resource must extract custom metadata for the following classes, attributes, and associations from the data source:
Classes
Class | Type |
|---|
AccessSchema | Schema |
AccessTable | Table |
AccessTableColumn | Column |
AccessView | View |
AccessViewColumn | View column |
Attributes
Attribute | Data Type |
|---|
Name | String |
Abbreviation | String |
BusinessUsage | String |
DateCreated | String |
Datatype | String |
Length | String |
Associations
Association | Association Type |
|---|
AccessSchemaAccessTable | Parent-child |
AccessTableAccessTableColumn | Parent-child |
AccessSchemaAccessView | Parent-child |
AccessViewAccessViewColumn | Parent-child |
In the model that you define for the Microsoft Access data source, make sure that you include the required classes, attributes, and associations in the definition.
You can create a custom model in one of the following ways:
- •Export an existing model definition file and update the file to create the custom model.
- •Create a custom model following the recommendations in the model definition file that you can download in Catalog Administrator.
See chapter Creating Custom Models for more information about creating custom models.