Introspecting Data Source Table and Column Comment Metadata
Data sources, such as Oracle and Teradata, include the ability to add annotations or comments for added understanding. During the introspection process, TDV can retrieve this information and add it to the annotations field for each resource. The annotation field can be viewed on the Info tab of each resource.
Requirements
Requires one of the following data sources:
• Oracle
• DB2 LUW
• Teradata
• Netezza
• PostgreSQL
• DB2 mainframe
• Vertica, Composite
• SAP HANA
• HSQLDB
• Hbase
You can enable or disable the comments introspection for Oracle data sources.
To enable comment introspection
For data sources other than Oracle, comment introspection is performed by default.
1. Open the Oracle data source for which you want table and column level metadata retrieved.
2. Select the Advanced tab.
3. Locate and select the Introspect comments check box.
4. Run the introspection process.
5. Review the comments by opening a resource editor and selecting the Info tab.