Quest Knowledge Portal is a reporting solution based on Microsoft SQL Server Reporting Services, extending its functionality to provide easy report management and delivery. All together improving and expanding SQL Server Reporting Services (SSRS) functionality and usability, the Knowledge Portal enables you to:
To install and configure the Knowledge Portal and Report Packs, follow the instructions provided in the Installation Guide.
After installation you can open the Knowledge Portal home page by clicking Start | Programs | Quest | Knowledge Portal.
Also, you can connect to the Knowledge Portal by typing its URL in the Internet Explorer address bar in one of the following formats:
When supplying the URL, you can enter the path to Knowledge Portal's sub-entity (for example, Enterprise Reporter) you want to be displayed as the root node of the treeview. For that, use the following format when entering the URL:
The Knowledge Portal main page is displayed; for example, to work with Enterprise Reporter reports, select Enterprise Reporter in the tree on the left, and browse for the report you need. To work with the data sources, click the corresponding tab.
In the reporting solutions based on Reporting Services, data sources are databases that store the information used in reports. The Knowledge Portal uses the concept of shared data sources defined by Microsoft SQL Server Reporting Services. For more information about shared data sources, see Microsoft SQL Server Reporting Services documentation (for example, Shared Data Sources and Report-Specific Data Sources MSDN article).
During the Report Pack setup process, predefined data sources are configured so that they point to corresponding databases (for example, the InTrust audit data source is associated with an InTrust audit database.
If the data sources were not configured during the Report Pack setup, you should do it manually before you start generating reports. Sample procedure described below helps you associate predefined data source with your product database. You can take similar steps to associate other data sources with the product databases.
To associate a data source with a database
Note: To use Windows authentication, make sure the account you supply has the following rights:
If you select Integrated Windows authentication, the SQL server will be accessed under the account of user currently logged on. In this case, however, the Temporary Tables Clean-up job cannot be scheduled. For details, see the Cleaning Temporary Tables topic.
If you need, you can create an additional data source, or modify an existing one. For example, to associate the Enterprise Reporter data source with a different database, you have to modify this data source.
To create or modify a data source