I need to automate pulling certain types of information(users with tokens, group/role membership, etc.) from RSA to use in reporting/dashboards outside of Authentication Mgr. Using SQL Server Integration Services, would it be better to use a direct connection to the database on a replica OR use a Web Service as described in the SDK? Any other thoughts on how to do this is welcomed. Thanks.
The RSA admin guides state that you should run PSQL queries on a replica to lighten the load on the Primary AuthMan server. This page describes how to automate SQL reports directly into Excel: Running PSQL Queries to AM 8.x Directly From Excel