How to import column descriptions from Oracle data sources

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 29 May 2020
Tags: Oracle Data Governance JDBC data sources

Download document

You can translate the document:

Content

In Denodo Virtual DataPort when importing a base view from an Oracle data source it is possible to import the columns along with their descriptions as defined in the Oracle source. To do so, enable the TABLE_REMARKS property in the JDBC data source configuration to instruct Oracle to allow Denodo to retrieve the column description when introspecting the schema.

In order to enable this property, in the Oracle data source configuration of Virtual DataPort do the following,

  • Click on “Driver Properties
  • Locate the property remarksReporting and change the value to true. (default value is false)
  • If the above mentioned property does not exist, click “New” and add the following property:
  • Name = remarksReporting
  • Value = true

Once the changes are saved, the newly created base views will propagate the Description field by retrieving the column comments.To retrieve the Description of already created base views, click on the “Source Refresh” option available on the “Edit” tab of the base view.

Note: It may take longer to build base views than without the property enabled, this is the reason this option is set off by default.

References

Connection Properties Recognized by Oracle JDBC Drivers

Source Refresh

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training