Implementation Guide › Installing CA User Activity Reporting Module › Install the ODBC Client › Create an ODBC Data Source on Windows Systems › ODBC Data Source Considerations

ODBC Data Source Considerations

The following are the descriptions of the ODBC data source fields as they relate to CA User Activity Reporting Module:

Data Source Name

Create a name for this data source. Client applications that want to use this data use this name to connect to the data source.

Service Host

Specifies the name of the CA User Activity Reporting Module server which the client connects. You can use either a hostname or an IPv4 address.

Service Port

Specifies the TCP service port on which the CA User Activity Reporting Module server listens for ODBC client connections. The default value is 17002. The value you set here must match the setting for the ODBC Server service or the connection fails.

Service Data Source

Leave this field blank, otherwise the connection attempt fails.

Encrypted SSL

Specifies whether to use encryption on the communications between the client and the CA User Activity Reporting Module server. The default value is to have SSL enabled. The value you set here must match the setting for the ODBC Server service or the connection fails.

Custom Properties

Specifies the connection properties for use with the event log store. The delimiter between the properties is a semi-colon with no space. The recommended default values include the following:

querytimeout

Specifies the timeout value in seconds with no data returned after which the query is closed. The following is the syntax for this property:

querytimeout=300

queryfederated

Specifies whether to perform a federated query. Setting this value to false performs a query only on the CA User Activity Reporting Module server to which the database connection is made. The following is the syntax for this property:

queryfederated=true

queryfetchrows

Specifies how many rows to retrieve in a single fetch operation, if the query is successful. The minimum value is 1, and the maximum value is 5000. The default value is 1000. The following is the syntax for this property:

queryfetchrows=1000

offsetmins

Specifies the offset for the timezone for this ODBC client. A value of 0 uses GMT. You can use this field to set your own timezone offset from GMT. The following is the syntax for this property:

offsetmins=0

suppressNoncriticalErrors

Indicates the Interface Provider’s behavior in case of noncritical errors such as a database not responding or a host not responding.

The following is the syntax for this property:

suppressNoncriticalErrors=false