ODW integration

The ODW Integration package creates menu items for the standard ODW SSRS reports, and data object types and properties used for the ODW Export.

Configuring ODW SSRS reports

If you have installed the ODW Integration package, you must go to Customer Settings and here update the customer setting SSRSUrl to point to the correct SQL Server Reporting Services Server URL.

For more information, refer to the Reports section of the documentation.

Exporting context assignments to companies and cost centers

The ODW Export exports the contexts Cost Center and Company in the standard setup of the ODW Export. The export ignores assignments to these types of contexts if the property that holds these assignments on the Identity object does not exist.

If context assignments to one or both of these context types are to be exported from the Data Warehouse, the IDENTCOMPANY and/or IDENTCOSTCENTER properties must be added manually to the Identity DOT.

You must then restart timer service to add these to the database. The last step is to run the CreateObjects.OISAudit.sql in the Omada Identity Audit database. The script is located in C:\Program Files\Omada Identity Suite\Datawarehouse\Support Files.