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. 

All supported operating system

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: 

This article provides steps to setup a Client Warning rule in TIBCO Data Virtualization using Workload Management functionality