Perform the following actions to manually add views to generate reports.
Download the IDM_4.7.0.0_Downloads.zip file from https://nu.novell.com/designer/idmrpt600.
Unzip the IDM_4.7.0.0_Downloads.zip file.
Browse to the directory with the report name and unzip it.
Example: <ReportName>.zip
Copy the SQL file to the server running the reporting database.
Open the database administration tool, such as pgadmin or sqldeveloper with administrator credentials.
Establish a connection to the server running the reporting database.
Open a new SQL Editor window.
Paste the SQL file content that you copied in Step 4 in the SQL Editor window.
Run the SQL query.
This will list the views under idm_rpt_data
To start Data Collection Services for these views:
Log in to Identity Manager Data Collection Services.
Goto Identity Vaults.
In Manage System Gateway Driver, set Collection State to Active.
Click Save.
Login to Identity Reporting and run the reports.