How to introspect Oracle resources that have a special character in their name into TIBCO Data Virtualization?

How to introspect Oracle resources that have a special character in their name into TIBCO Data Virtualization?

book

Article ID: KB0075882

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All supported versions

Description

This article describes the steps to follow in order to introspect Oracle resources into TDV that contain special characters in their names.

Note:
By default, if an Oracle resource contains special characters in its name, then they do not show up in the TDV Studio introspection list. 

Issue/Introduction

How to introspect Oracle resources that have a special character in their name into TIBCO Data Virtualization?

Resolution

1. Open TDV Studio and navigate to Administration > Configuration > Data sources > Oracle Data Source > Introspect All Objects
2. Change 'Introspect All Objects' value to TRUE (Note: It is FALSE by default)
3. Click on 'Apply' to confirm the changes.

For reference:
User-added image