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
...
...
title | Java |
---|
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
...
.
...
...
In order to use this component, make sure to have the BlueriqComponentReportingSqlStore.dll in the /bin directory of your .NET webapp installation.
Configuration
Database
Scripts to create the required database content are provided for the following 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 | ||
|
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
Example configuration:
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
- If necessary, create a new connection. The connection needs to be configured in the
...
application.properties blueriq.connection.reporting_local_sql.sql.jndi=java:/comp/env/jdbc/reporting blueriq.connection.reporting_local_sql.sql.type=jndi
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:
Configuring the database connection for the Reporting SQL Store component in .Net is done by adding a connection configuration to the
Web.config
file:Example configuration:
Code Block title .NET database configuration example <hibernate-configuration> <session-factories> <session-factory name="ReportingDao"> <properties> <property name="connection.provider" value="NHibernate.Connection.DriverConnectionProvider" /> <property name="dialect" value="NHibernate.Dialect.MsSqlCeDialect" /> <property name="connection.driver_class" value="NHibernate.Driver.SqlServerCeDriver" /> <property name="connection.connection_string" value="Data Source=|DataDirectory|\LocalDB\ReportingDB.sdf" /> <property name="show_sql" value="false" /> <property name="current_session_context_class" value="Aquima.WebApplication.WebPersistenceUtility.Session.CurrentHibernateSessionContext, WebPersistenceUtility" /> </properties> </session-factory> </session-factories> </hibernate-configuration>
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.
...