ApplicationIntent=ReadOnly not working for datamaker connection properties

book

Article ID: 131899

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We have the follwoing set of paramters sent into our connections:

integrated security=SSPI,Persist Security Info=False,encrypt=true,ApplicationIntent=ReadOnly

We have this in parameter settings for our Prod application databases data source connections, but it is not working in our environment. When ApplicationIntent=ReadOnly is set, all the SQL queries need to run on the secondary node, but that is not the behavior that we are noticing. We need to know how to set ReadOnly for our PROD where where the data should be read only.

Environment

TDMWeb 4.6

Resolution

This is resolved with TDMWeb-4.6.52.0 as well as being placed in the 4.8 GA.  Please contact BC Support for this patch or later to enable this functionality.  This is considered an enhancement and not an error.