What is being referred to as Failover? I am assuming it is within the "availability group" and not across different "availability group listener".
I see there are two usecase, not sure which usecase you are trying....
UseCase-1 : If it is failover within a single "availability group listener"; then.....
From a logical standpoint any client connecting to "availability group listener" should be unaware of the underlying physical servers. "availability group listener" would be masking the underlying database architecture. To the client "availability group listener" is emulating as a physical server & "availability group listener" is always up. To any client (including CA SSO) the failover within the availability group should be masked. Like I mentioned, though it seems simple logically, may it needs some testing / support effort on CA SSO to formally introduce support.
UseCase-2 : If it is failover across multiple "availability group listener"; then.....
Like I mentioned it may not be supported or tested with CA SSO / Data Direct Drivers (shipped with CA SSO).
Reference :
Listeners, Client Connectivity, Application Failover | Microsoft Docs
Behavior of Client Connections on Failover
When an availability group failover occurs, existing persistent connections to the availability group are terminated and the client must establish a new connection in order to continue working with the same primary database or read-only secondary database. While a failover is occurring on the server side, connectivity to the availability group may fail, forcing the client application to retry connecting until the primary is brought fully back online.
If the availability group comes back online during a client application’s connection attempt but before the connect timeout period, the client driver may successfully connect during one of its internal retry attempts and no error will be surfaced to the application in this case.
Our support matrices does specifically mention for Oracle whether RAC is supported or not. I am unsure if "AlwaysOn" feature of MS SQL does fit into such a scenario, wherein we may to specifically state if the feature is tested / supported. It is always good to know via Support Matrices.
My recommendation is to raise a Case & if needed followup with an ER (ideation) to formally include support for the HA feature of MS SQL (if the word turn out to be not tested / supported).