Denodo - Ingesting Table/Column Comments into Base Views
This article provides instructions VDB administrators must follow for Denodo to automatically ingest the table and column comments into base views.
By default when sourcing from a relational database, such as Oracle or Microsoft SQL Server, Denodo will not automatically include the table and field comments in base views.
To turn this functionality on, follow these steps:
- Open the data source configuration in Design Studio.
- On the Advanced tab, expand the Driver Properties section.
- Scroll down the list to the remarksReporting and set the value from false to True.
- NOTE: if the remarksReporting entry is not listed, click +New Property and add the following:
- Name: remarksReporting
- Value: True
- NOTE: if the remarksReporting entry is not listed, click +New Property and add the following:
- Save the changes.
- Open the Base View created from this data source and in the Edit section, click the Source Refresh link.
- Descriptions of the tables/columns should now be listed.
Note: If you have already imported a base view, you can do a Source Refresh on the base view to ingest comments after this feature has been turned on.
Note: the Data Catalog is updated on the 45th minute of every hour. The Data Catalog will be updated to include newly added metadata during the next update.