This documentation supports the 18.08 version of Remedy IT Service Management Suite.

To view the latest version, select the version from the Product version menu.

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.

Connection Description

This section allows you to define the basic metadata for your connection; NameDescription, and Tags. These items should be descriptive as users will need them to identify the connection when building content. 

Connection Settings

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:

NameDescription
Connection MethodSpecify the type of connection. For example, JDBC.

Authentication Adapter

Specify if you want to use the standard database authentication method, or pass through system user authentication to the database.
Database TypeSpecify the type of database that you want to connect to.
Include Schema in SQLSelect to include the schema name while addressing the database tables in the SQL queries.
Database HostSpecify the name of the Remedy AR System server that is hosting the database.
Database PortSpecify the TCP/IP port number of the database.
Custom ParametersSpecify 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 DriverSpecify the JDBC driver.
User NameSpecify the database user name. This name must be the same as the one specified in Remedy AR System.
PasswordSpecify the password for the database user. You can change this password by clicking the Click here to change password link.
SchemaSpecify the schema to be used while connecting to the database.

Connection Pool

You can configure the following connection pool parameters:

NameDescription
Min ConnectionsSpecify the minimum number of connections that can be open simultaneously.
Max ConnectionsSpecify the maximum number of connections that can be open simultaneously.

Important:

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 TimeSpecify the connection refresh time interval.
TimeoutSpecify the time interval (in seconds) after which the connection is closed.
Use secondary poolEnable 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.

Security

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.

Access Filters

This section allows you to add new or manage existing access filters. For more information, see Access Filters .

Usage Parameters

This section allows you to define some general parameters related to the use of the data source. You can configure the following parameters:

NameDescription

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.
WritableEnable if you want to grant the users the write access to the database.
Time zoneSpecify the time zone associated with this database connection and related schedules if any.
BroadcastEnable 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.
SubscribeEnable to allow the users to subscribe to the content created on this connection.
Data ProfilingEnable 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.


Was this page helpful? Yes No Submitting... Thank you

Comments