Source Connection Parameters
A data source is created by default while onboarding and only one source connection is available per client. However, you can configure the advanced options of a new or existing connection by accessing the source connection parameters through Administration > Data Sources on the Remedy Smart Reporting Admin Console.
This topic explains the parameters available when connecting to a database.
This section allows you to define the basic metadata for your connection; Name, Description, and Tags. These items should be descriptive as users will need them to identify the connection when building content.
These are the connection parameters that need to be defined in order for Remedy Smart Reporting to know how to access your database. You can configure a list of parameters is based on the type of the database that you want to connect to.
You can configure the following parameters:
|Connection Method||Specify the type of connection. For example, JDBC.|
|Specify if you want to use the standard database authentication method, or pass through system user authentication to the database.|
|Database Type||Specify the type of database that you want to connect to.|
|Include Schema in SQL||Select to include the schema name while addressing the database tables in the SQL queries.|
|Database Host||Specify the name of the Remedy AR System server that is hosting the database.|
|Database Port||Specify the TCP/IP port number of the database.|
|Custom Parameters||Specify the custom parameters if any. The custom parameters can be a separated by a semicolon(;). For example, refreshCache=10;DateTimeFormat=MM/dd/yyyy hh:mm:ss;|
|JDBC Driver||Specify the JDBC driver.|
|User Name||Specify the database user name. This name must be the same as the one specified in Remedy AR System.|
|Password||Specify the password for the database user. You can change this password by clicking the Click here to change password link.|
|Schema||Specify the schema to be used while connecting to the database.|
You can configure the following connection pool parameters:
|Min Connections||Specify the minimum number of connections that can be open simultaneously.|
|Max Connections||Specify the maximum number of connections that can be open simultaneously.|
The number of connections must not exceed the JDBCMaxCount value configured in the web.xml file. For more information on configuration values for performance tuning, see the knowledge base article at Configuration checklist.
|Refresh Time||Specify the connection refresh time interval.|
|Timeout||Specify the time interval (in seconds) after which the connection is closed.|
|Use secondary pool||Enable if you want to use a secondary connection pool for the database for running background tasks.|
When you change the connection pool settings, you do not have to restart the server.
This section allows you to define who has access to this data source connection for view creation, freehand SQL reports, and Transformation Flows.
The following two options available:
- Public—Select to allow all users with required role permissions to access and use this connection for view creation.
- Private—Select to allow only specified users, with required role permissions to access and use this connection for view creation.
If you set the data source to private, define specific users or groups of users who can access the connection. Each user can be assigned one of the following levels of access:
- Read—Allows users to see views based on this data source in the data sources and views page, and when creating a report.
- Update—Allows users to create, edit, or copy a view based on this data source, as well as the above Read level of access.
- Delete—Allows the user to Delete this data source connection, as well as both of the above Read and Update levels of access.
This section allows you to add new or manage existing access filters. For more information, see Access Filters .
This section allows you to define some general parameters related to the use of the data source. You can configure the following parameters:
Max Rows Returned
|Enable to define a limit to the number of rows returned by queries that are run on this connection.|
Analysis Max Rows Returned
|Enable to define a limit to the number of rows returned by queries run on this connection when we are running analysis queries such as Assisted Insights and Signal analysis.|
|Writable||Enable if you want to grant the users the write access to the database.|
|Time zone||Specify the time zone associated with this database connection and related schedules if any.|
|Broadcast||Enable if you want the users to broadcast the content created on this connection.|
Important: If you disable this parameter after enabling, the existing scheduled broadcast tasks, if any, get executed. However, disabling this parameter prevents you from creating new Broadcast tasks.
|Subscribe||Enable to allow the users to subscribe to the content created on this connection.|
|Data Profiling||Enable if you want to disallow data profiling in the views using this data source.|
Views & Content
This allows you to view a list of content that has been created based on this data source connection.