As per CA Documentation, Under SQL Server Authentication Mode Considerations Section
"CA SiteMinder® data sources do not support Windows authentication. Configure the CA SiteMinder® data source with the credentials of a user that is stored in the database."
As per the Client's Database authentication standards the connections to all the Databases should only happen through windows authentication and no SQL authentication mode is enabled.
Hence we would like to raise an enhancement request for Siteminder policy & Audit stores to connect the databases via Windows authentication. I have contaced the CA support for the same and was advised to raise an enhancement request in this forum.
Please consider this and keep me posted.