Under In this section, you will find instructions on how to create creating connections to various data sources and descriptions to set their associated properties. 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 of creating the connection and verify if the connection to your data source is made successfully. This process is entirely secure in Kyvos Reporting.
Kyvos Reporting Server supports multiple database connections. A database connection needs to be configured for Kyvos Reporting to fetch data for reports and to access metadata.
You need to must have Super Administrator privileges to set up database connections.
Click To create a connection, click Navigate > Administration > Configure > Connections to access the Database Connections page.
...
If Kyvos Reporting runs in security-disabled mode, you can access this page by specifying the following URL in the browser’s address bar.
If you are using a computer that acts as a web server
...
- http://localhost:<portnumber>/Kyvos Reporting/pattern/conf and then click the Databases tab
In other cases
...
- http://<IP of the server:port number>/Kyvos Reporting/pattern/conf and then click the Databases tab
Action Buttons
Add: Configure a new connection using the Connection Name and Provider details.
Test: Test a database connection’s validity. A Connection Test Succeeded message will appear if the selected connection is valid. When the user clicks on the ‘Failed’ marker for an invalid connection, a pop-up will open to show the detailed error message behind the failed connection.
Save: Save the selected connection once it has been successfully tested.
Discard: To discard unsaved connections.
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. Select Select the data connection to refresh the metadata manually 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 Actions menu next to Refresh Schema): Remove an existing connection.
| Panel | |
|---|---|
|
...
| |||||
Note You can download the database configuration file in encrypted form by clicking the ellipsis next to the Help icon. |
Finding a Connection
For more than 10 connections, the list of connections can be searched as shown below:
...