2020-04-29
11:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- Authentication Manager
- automation
- Community Thread
- Discussion
- Forum Thread
- Integration
- Integrations
- RSA SecurID
- RSA SecurID Access
- RSA SecurID Integration
- SecurID
1 Reply
2020-05-06
01:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
