Announcements

SecurID® Discussions

Browse the SecurID discussion board to get product help and collaborate with other SecurID users.
SpencerMay
Beginner
Beginner

Best way to extract data from RSA using SSIS?

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.

Labels (1)
0 Likes
1 Reply
DavidAllison
Respected Contributor Respected Contributor
Respected Contributor

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 

0 Likes