Some of our MS SQL Server application databases are part of availability groups whereby we can only read from the standby/read-only copy of the databases. To ensure our requests are routed to the read-only segment, we have to specify the ApplicationIntent=ReadOnly parameter on our SQL connection.
This works fine when setting up an ODBC server connection for Data Services to use but is there a away we can set our Datastore configuration within Data Services?
I’ve tried adding the Application Intent parameter as a session parameter in the datastore configuration but that isn’t working.
ErikR 
(BOB member since 2007-01-10)