All data in Hitachi ID Group Manager is available via ODBC and accessible using standard analytical tools (Crystal Reports, Cognos, MS-Excel, SQL queries, etc).
The schema is well documented and this documentation is available to all product licensees and to evaluators under NDA. The current release schema documentation is about 127 pages long, and includes detailed descriptions of every field, table, relation, value constraint, etc.
Data available through Group Manager includes:
- A list of user IDs per target Active Directory domain.
- A list of group IDs per target Active Directory domain.
- A cross-table connecting users to groups in which they are members.
Group Manager includes a number of standard reports, available through a web user interface, from the command-line, or by e-mail:
- Users who have accounts on specific domains.
- User groups available on target systems.
- Membership of users in user groups on target systems.
- Transaction history per time period.
- Authorizer actions.
- Delegations (current and pending).
- Requests, by status, state and result.
- Request statistics.
- Past Reports.
All Group Manager reports are available in either HTML or CSV formatted output. HTML output can be displayed directly on the reporting page of the Group Manager administration web GUI. Both HTML and CSV output may be generated asynchronously (i.e., in the background), with output delivered via a network share or e-mail when ready. In this way, any report data can be easily exported from Group Manager and imported into external spreadsheets, database tables, etc.
In addition to directing report output to CSV files, it is possible to generate direct extracts of Group Manager tables, either by attaching an ODBC driver to a copy of the Group Manager database or by using a command-line program included in Group Manager to generate a CSV file. These methods allow Group Manager to extract any data, including data that is not available through packaged reports and develop its own reports or integrations.
A full schema of the Group Manager database is available to all customers. It is about 127 pages long and describes the contents of and relationships between every table and field.