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:
Group Manager includes a number of standard reports, available through a web user interface, from the command-line, or by e-mail:
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 portal. 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 Hitachi ID Systems customers. It is about 127 pages long and describes the contents of and relationships between every table and field.