How to access TIBCO Data Virtualization (TDV) system tables using an external client?

How to access TIBCO Data Virtualization (TDV) system tables using an external client?

book

Article ID: KB0071622

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

By design, we cannot directly access the system tables using an external client connected to the TDV Server, in order to be able to access these tables we must do these steps:

Issue/Introduction

How to access TIBCO Data Virtualization (TDV) system tables using an external client such as DB Visualizer?

Resolution

1.Login to TDV Studio and  create a new folder in the shared directory and name it "System Views"

User-added image

2. Create an individual view for each of the tables you want to access

User-added image

3. Customize your SQL query as needed:

             Example: SELECT * from  /services/databases/system/SYS_TASKS 

User-added image
             
4. Confirm that the view works correctly by saving and running it.         
           
5. Publish the created view:

User-added image

 6. Add a new composite service, name it "System Views" , add a catalog and schema and name for the view as required. Publish all the views in to this new service.

7. Now point your IDE(Integrated Development Environment) / SQL Editor to this newly published service instead of the default System one to see the published views and query them directly.

Below is an illustrated example that uses DBVisualizer, using a JDBC string connection string : jdbc:compositesw:dbapi@localhost:9401?domain=composite&dataSource=System Views

User-added image
    
We are able to access the contents of the selected system table using an external client:

User-added image