Administration Guide › Services and CA Adapters › Service Configurations › ODBC Server Considerations

ODBC Server Considerations

You can install an ODBC client or a JDBC client to access the CA Enterprise Log Manager event log store from an external application like SAP BusinessObjects Crystal Reports.

You can perform the following tasks from this configuration area:

• Enable or disable ODBC and JDBC access to the event log store.
• Set the service port used for communications between the ODBC or JDBC client and CA Enterprise Log Manager server.
• Specify whether communications between ODBC or JDBC client and CA Enterprise Log Manager server are encrypted.

The field descriptions are as follows:

• Enable Service

  Indicates whether the ODBC and JDBC clients can access data in the event log store. Select this check box to enable external access to events. Clear the check box to disable external access.

  The ODBC service is not currently FIPS-compatible. Clear this check box to prevent ODBC and JDBC access if you intend to run in FIPS mode. This prevents non-compliant access to event data. If you intend to disable the ODBC and JDBC service for FIPS mode operations, ensure that you set this value for each server in a federation.

• Server Listening Port

  Specifies the port number used by the ODBC or JDBC services. The default value is 17002. The CA Enterprise Log Manager server refuses connection attempts when a different value is specified in the Windows Data Source or the JDBC URL string.

• Encrypted (SSL)

  Indicates whether to use encryption for communications between the ODBC client and the CA Enterprise Log Manager server. The CA Enterprise Log Manager server refuses connection attempts when the corresponding value in the Windows Data Source or JDBC URL does not match this setting.

• Session Timeout (minutes)

  Specifies the number of minutes to keep an idle session open before it is closed automatically.

• Log Level

  Defines the type and level of detail recorded in the logging file. The drop-down list is arranged in order of detail, with the first choice providing least detail.

• Apply to all loggers

  Controls whether the Log Level setting overrides all log settings from the properties file of the log. This setting only applies when the Log Level setting is lower (showing more detail) than the default setting.