Tibco Data Virtualization (TDV) introspection for tables with names having special characters do not introspect
book
Article ID: KB0080488
calendar_today
Updated On:
Products
Versions
TIBCO Data Virtualization
-
Description
In Oracle 8.1.7 and above, there are many schema objects that are not useful for Tibco Data Virtualization (TDV). Therefore, TDV applies a built in filter to exclude those schema objects during introspection. But, it is possible to allow introspection for all objects by changing datasource configurations from the Studio interface.
For example, tables with special characters like this will be skipped with default configuration: abc$def_DOCUMENT
Issue/Introduction
This document shows how to enable Tibco Data Virtualization (TDV) introspection for Oracle tables with names having special characters.
Resolution
Go to Studio->Administration->Configuration and then enter "Introspect All Objects" in the search Window. Then attempt to introspect again. Now all tables should get introspected.