Under this section, you will find the instructions on how to create connections to various data sources and description descriptions to set their associated properties. Intellicus Kyvos Reporting helps you fetch data from multiple data sources at once. Refer to the description of your required data sources to understand the process to create of creating the connection and verify if the connection to your data source is made successfully. This process is completely entirely secure in IntellicusKyvos Reporting.
Intellicus Kyvos Reporting Server supports multiple database connections. A database connection needs to be configured for Intellicus Kyvos Reporting to fetch data for reports and to access metadata.
You need to have Super Administrator privileges to be able to setup set up database connections.
To get to the Database connections page, click Click Navigate > Administration > Configure > Connections to access the Database Connections page.
Figure 1: Connection Configuration page
...
If Intellicus is running under security Kyvos Reporting runs in security-disabled mode, specify you can access this page by specifying the following URL in the browser’s address bar to get this page.
If you are using the a computer that acts as a web server,
http://localhost:<portnumber>/intellicusKyvos Reporting/pattern/conf and then click the Databases tab
In other cases,
http://<IP of the server:port number>/IntellicusKyvos Reporting/pattern/conf and then click the Databases tab
Action Buttons
Add: To start configuring Configure a new connection with using the Connection Name and Provider details.
Test: Test a database connection’s validity. If the selected connection is valid, A Connection Test Succeeded message will appear . For an invalid connection, when if the selected connection is valid. When the user clicks on the ‘Failed’ marker for an invalid connection, a pop opens -up will open to show the detailed error message behind the failed connection.
Save: To save Save the selected connection once it has been successfully tested.
Discard: To discard unsaved connectionconnections.
Refresh Schema: To manually refresh the schema of the selected connection. Metadata is cached when a database connection is created. It is refreshed depending on the value set in MetaData Cache Purge Frequency. To Select the data connection to refresh the metadata manually , select the data connection and click the Refresh Schema button. On the Confirm Refresh dialog, click Yes to proceed. A message ‘A request for refreshing (name of the connection) schema has been sent to the Report Server’ will be displayed.
Remove Connection (available under ellipsis next to Refresh Schema): To remove Remove an existing connection.
Note: You can download the database configuration file in encrypted form by clicking the ellipsis next to the Help icon.
...
For more than 10 connections, the list of connections can be searched upon as shown below:Figure 2: Finding Connections
...
Deciding the preference of connections for a report run
The data that the user gets on a report is fetch fetched from a database using a data connection. Based on the Kyvos Reporting edition of Intellicus and license, you can set one or more data connection connections in IntellicusKyvos Reporting.
Database The database (data connection) to be used to run reports can be set in the following ways:
While actually running the report.
While specifying just after login logging into Intellicus Kyvos Reporting (at session level). This , this remains the default for any type of database use (report running, running queries, etc.).
By setting up on User Preferences
By specifying it as a part of the Report Details (while uploading a report through the portal or through cab).
By specifying it in while designing the report (IRL file).
By specifying a default data connection.
When a report is being run, Intellicus Kyvos Reporting will use the data connection in the following order:
Use the data connection that was selected while actually running the report from Report Delivery Options
If the connection was not selected on Report Delivery Options page, use the database connection selected at the time of login into Intellicus Kyvos Reporting (session level).
If the connection was not selected while during login, use the chosen connection selected on User Preferences.
If a connection is not selected on the User Preferences page, use the chosen connection selected while deploying the report (report details).
If a connection is not selected as a report detailsdetail, use the connection selected while when designing the report (irl file).
If a connection is not selected in the irl file, use the default connection set in Intellicus Kyvos Reporting on Connection Configuration
...
Order is controlled by values specified in <CONNECTIONPRIOIRTY> tag in ProviderInfo.xml located at path:
<installation path>IntellicusReportEngineConfig path>Kyvos ReportingReportEngineConfig .
Values (and the default sequence) are:
CALLBACK: Connection The connection is set on the Report Delivery Options page.
SESSION: Connection set from the home page of IntellicusKyvos Reporting.
USERPREFERENCE: Connection The connection is set on the user preference page.
REPORTDEPLOYMENT: Connection set at the time of report deployment.
NAMEDCONNECTION: Connection set during report design.
DEFAULT: Connection is set as the default on the Database page of IntellicusKyvos Reporting.
To change the order, change the order of appearance of the above values in the CONNECTIONPRIORITY tag. This tag , which is the last tag in the file.
For example, the default order:
<CONNECTIONPRIOIRTY>CALLBACK, SESSION, USERPREFERENCEUSER PREFERENCE, REPORTDEPLOYMENT, NAMEDCONNECTION, DEFAULT</CONNECTIONPRIOIRTY>
...
<CONNECTIONPRIOIRTY> SESSION, CALLBACK, USERPREFERENCEUSER PREFERENCE, REPORTDEPLOYMENT, NAMEDCONNECTION, DEFAULT</CONNECTIONPRIOIRTY>