ApplicationIntent=ReadOnly not working for datamaker connection properties
Article ID: 131899
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.
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.
Feedback
Yes
No
Powered by
