How to find out the Datasource name for a particular view by using a query from ADS metadata/repository.

How to find out the Datasource name for a particular view by using a query from ADS metadata/repository.

book

Article ID: KB0079929

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 7.0.6, 7.0.7, 7.0.8, 8.0, ALL

Description

How to find out the Datasource name for a particular view by using a query from ADS metadata/repository.

Issue/Introduction

How to find out the Datasource name for a particular view by using a query from ADS metadata/repository.

Environment

Any

Resolution

These below system table will help us query the data: (metadata tables) using filters. 

/services/databases/system/ALL_RESOURCES
/services/databases/system/SYS_DATASOURCES
/services/databases/system/SYS_SESSIONS
/services/databases/system/ALL_DATASOURCES
Powered by Wolken Software