Page History
Table of contents
Table of Contents
...
This component persists data in a database, that must be configured as a connection. See Platform Support for the supported databases.
Installation
...
In order to use this component, the
profile must be active. More information on how to configure the application using Spring Profiles can be found here : External application configuration with Spring Profiles. Include Page _ProfileReporting _ProfileReporting
Add the artifact with groupId com.blueriq
and artifactId blueriq-component-reporting-sql-store
as a dependency to your Blueriq runtime POM file
...
title | .NET |
---|
...
.
Configuration
Database
Scripts to create the required database content are provided for the following supported databases:
...
.
Info | |
---|---|
For customers that are upgrading an existing version of Blueriq, database upgrade scripts are provided in the Upgrade Instructionsinstructions when applicable. | |
UI Expand | |
title | Java
See Configuring database connection for information on how to create new connections for the different datasources.Use the following steps to configure the database connection:
Using JDBC datasource:
If necessary, create a new connection. The connection needs to be configured in the
file.Include Page _PropertiesFileJava _PropertiesFileJava Code Block language powershell title application.properties (SQL Server example) blueriq.connection.reporting_local_sql.sql.url=jdbc:sqlserver://<database_url>:<port_number>;databaseName=<database_name>;instance=<instance_name> blueriq.connection.reporting_local_sql.sql.username=<username> blueriq.connection.reporting_local_sql.sql.password=<password> blueriq.connection.reporting_local_sql.sql.type=jdbc blueriq.connection.reporting_local_sql.sql.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver blueriq.connection.reporting_local_sql.sql.poolInitialSize=0 blueriq.connection.reporting_local_sql.sql.poolMaxIdle=8 blueriq.connection.reporting_local_sql.sql.poolMaxTotal=8 blueriq.connection.reporting_local_sql.sql.poolMaxWait=-1L blueriq.connection.reporting_local_sql.sql.poolMinIdle=0 blueriq.connection.reporting_local_sql.sql.minEvictableIdleTimeMillis=1800000 blueriq.connection.reporting_local_sql.sql.numTestsPerEvictionRun=3 blueriq.connection.reporting_local_sql.sql.testOnBorrow=true blueriq.connection.reporting_local_sql.sql.testOnReturn=false blueriq.connection.reporting_local_sql.sql.testWhileIdle=false blueriq.connection.reporting_local_sql.sql.timeBetweenEvictionRunsMillis=-1 blueriq.connection.reporting_local_sql.sql.validationQuery="SELECT 1" blueriq.connection.reporting_local_sql.sql.validationQueryTimeout=-1
- Using JNDI datasource:
...
- If necessary, create a new connection. The connection needs to be configured in the
file.Include Page _PropertiesFileJava _PropertiesFileJava Code Block language powershell title application.properties blueriq.connection.reporting_local_sql.sql.jndi=java:/comp/env/jdbc/reporting blueriq.connection.reporting_local_sql.sql.type=jndi
- If necessary, create a new connection. The connection needs to be configured in the
In Encorethe previously configured connection name needs to be used as the Connection parameter of the AQ_Report service.
Example configuration: In the previous example the name of the connection is reporting_local_sql .
- Configuring the database connection from the Development Dashboard
Go to Settings Widget → Connections
...
- tab → On the left side menu : select SQL connection. The same properties are available for configuration as from the properties file. You can perform CRUD operations on connections from here
...
...
title | .NET |
---|
Use the following steps to configure the database connection:
...
Example configuration:
...
title | .NET database configuration example |
---|
...
- .
...
In Studio the previously configured connection name needs to be used as the Connection parameter of the AQ_Report service.
Example configuration: In the previous example the name of the connection is
ReportingDao
.
Supported dialects:
...
All necessary DLL files the Reporting SQL Store component depends on can be found in the /bin
directory of the .NET webapp ZIP file.
...