Tibco Data Virtualization (TDV) introspection for tables with names having special characters do not introspect

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.