How to create a "Client Warning" rule in TIBCO Data Virtualization using Workload Management?
Article ID: KB0075843
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.0 and later |
Description
TIBCO Data Virtualization allows to create a custom warning message that can be sent to any client application which is connected to TDV using JDBC, ODBC or ADO.NET client drivers. This article provides the steps to setup a "Client Warning" rule in TDV using the Workload Management functionality.
Issue/Introduction
This article provides steps to setup a Client Warning rule in TIBCO Data Virtualization using Workload Management functionality
Environment
All supported operating system
Resolution
Prerequisite: A TDV user trying to access a Published TDV resource
1. To create a Rule, navigate to TDV Web Manager > Configuration tab > WorkLoad Management > Add Rule
Rule Name: [rule_name]
Select box 'Enable'
Rule Type: Row Limit
Action: Client Warning
Maximum Row Count: [add_number]
Client Warning Body: [warning_message_text]
Select the Users/ Group the restriction should be applied
Path to the TDV published resources
Edit Rule page screenshot for reference:
Click Save.
2. Create an ODBC connection for the same user the above rule is applied.
DSN creation example for reference:
3. An attempt to import the data from any ODBC client tool is now restricted and the Client warning message is displayed.
Screenshot of the warning message received in Microsoft Excel:
1. To create a Rule, navigate to TDV Web Manager > Configuration tab > WorkLoad Management > Add Rule
Rule Name: [rule_name]
Select box 'Enable'
Rule Type: Row Limit
Action: Client Warning
Maximum Row Count: [add_number]
Client Warning Body: [warning_message_text]
Select the Users/ Group the restriction should be applied
Path to the TDV published resources
Edit Rule page screenshot for reference:
Click Save.
2. Create an ODBC connection for the same user the above rule is applied.
DSN creation example for reference:
3. An attempt to import the data from any ODBC client tool is now restricted and the Client warning message is displayed.
Screenshot of the warning message received in Microsoft Excel:
Feedback
Yes
No
Powered by
