Products | Versions |
---|---|
TIBCO Data Virtualization | - |
1.Login to TDV Studio and create a new folder in the shared directory and name it "System Views"
2. Create an individual view for each of the tables you want to access
3. Customize your SQL query as needed:
Example: SELECT * from /services/databases/system/SYS_TASKS
4. Confirm that the view works correctly by saving and running it.
5. Publish the created view:
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
We are able to access the contents of the selected system table using an external client: